DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Postgres pg_stat_statement setup via docker

Postgres pg_stat_statement setup via docker

4
Comments
2 min read
Horizontal Scaling vs. Vertical Scaling for SQL: What's the Difference?

Horizontal Scaling vs. Vertical Scaling for SQL: What's the Difference?

3
Comments
2 min read
A Next-Generation ORM: Prisma

A Next-Generation ORM: Prisma

63
Comments 1
6 min read
Running SSIS Packages with Python

Running SSIS Packages with Python

6
Comments
3 min read
Constraints in SQL

Constraints in SQL

3
Comments
1 min read
Utilizing BigQuery as a Data Warehouse in a distributed application

Utilizing BigQuery as a Data Warehouse in a distributed application

4
Comments
9 min read
Anvil Platform : Build Full-Stack Apps with only Python

Anvil Platform : Build Full-Stack Apps with only Python

51
Comments 5
2 min read
SQL queries through REST available now!

SQL queries through REST available now!

5
Comments
1 min read
How to create table in SQL?

How to create table in SQL?

5
Comments
1 min read
pg_hint_plan and single-table cardinality correction

pg_hint_plan and single-table cardinality correction

5
Comments
8 min read
Which database to choose for your project

Which database to choose for your project

24
Comments 5
5 min read
Security vulnerabilities – how to find and fix them

Security vulnerabilities – how to find and fix them

3
Comments
4 min read
How to build internal tools on Stripe with SQL

How to build internal tools on Stripe with SQL

5
Comments
19 min read
Using Dapper over EntityFramework for database operations in .NET Core

Using Dapper over EntityFramework for database operations in .NET Core

9
Comments 2
4 min read
Different Ways to Load Data From CSV Files in PostgreSQL

Different Ways to Load Data From CSV Files in PostgreSQL

6
Comments
3 min read
GitHub Stargazers over time using Google Charts

GitHub Stargazers over time using Google Charts

3
Comments
4 min read
Querying ActiveStorage Attachments

Querying ActiveStorage Attachments

13
Comments 2
1 min read
Know Your Indices

Know Your Indices

4
Comments
26 min read
My favourite backend tools

My favourite backend tools

7
Comments
7 min read
What is Cost-based Optimization?

What is Cost-based Optimization?

3
Comments
5 min read
How to connect to an Azure SQL Database from C# using Azure AD

How to connect to an Azure SQL Database from C# using Azure AD

4
Comments
8 min read
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

25
Comments 9
3 min read
Introducing DataStation, the open-source data IDE for developers

Introducing DataStation, the open-source data IDE for developers

2
Comments
2 min read
Dicas de Grails #2 - acessando o contexto do Spring

Dicas de Grails #2 - acessando o contexto do Spring

4
Comments
2 min read
Writing a graphQL fullstack Svelte Web App with Sapper & Postgraphile

Writing a graphQL fullstack Svelte Web App with Sapper & Postgraphile

12
Comments 2
8 min read
Installing Microsoft SQL Server on your Mac with docker

Installing Microsoft SQL Server on your Mac with docker

2
Comments
1 min read
The SSDT Refactor Log

The SSDT Refactor Log

3
Comments
4 min read
Level Up Your dbt Schema Tests in 4 Easy Steps

Level Up Your dbt Schema Tests in 4 Easy Steps

3
Comments
3 min read
Python function to work with dynamic SQL Queries

Python function to work with dynamic SQL Queries

4
Comments
4 min read
Write Faster and More Efficient SQL Queries

Write Faster and More Efficient SQL Queries

6
Comments
9 min read
Too Good to Be True: Why NewSQL Failed

Too Good to Be True: Why NewSQL Failed

2
Comments 1
10 min read
Brief Introduction to ORM

Brief Introduction to ORM

5
Comments
1 min read
TypeORM - Prevent SQL Injection with Node.js, React and TypeScript

TypeORM - Prevent SQL Injection with Node.js, React and TypeScript

22
Comments 2
9 min read
Docker: how to build & use your first image

Docker: how to build & use your first image

6
Comments
6 min read
Introduction to NoSQL (with Pros & Cons)

Introduction to NoSQL (with Pros & Cons)

3
Comments
6 min read
Amazon Redshift ML - Creating Machine Learning Models with Standard SQL.

Amazon Redshift ML - Creating Machine Learning Models with Standard SQL.

10
Comments 1
6 min read
Raw SQL vs Rails Queries

Raw SQL vs Rails Queries

12
Comments
2 min read
5 Data Sources for Your Next Data Engineering Projects

5 Data Sources for Your Next Data Engineering Projects

19
Comments
6 min read
SQL Or NOSQL: That is the question!

SQL Or NOSQL: That is the question!

5
Comments
5 min read
What I Learned This Week: Database Constraints

What I Learned This Week: Database Constraints

5
Comments
2 min read
Exploit Website Databases Using SQLmap

Exploit Website Databases Using SQLmap

3
Comments
2 min read
Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

Build a Streaming SQL Pipeline with Apache Flink and Apache Kafka

9
Comments
11 min read
Database Design and SQL for Beginners

Database Design and SQL for Beginners

4
Comments 2
3 min read
Connection Leak in MSSQL

Connection Leak in MSSQL

5
Comments
1 min read
[SQL] Find third largest record from a table

[SQL] Find third largest record from a table

6
Comments
1 min read
SqlAlchemy Python ORM

SqlAlchemy Python ORM

6
Comments
2 min read
Connect to MySQL

Connect to MySQL

6
Comments
1 min read
Dialect differences between SQLite and Postgres in Sequelize

Dialect differences between SQLite and Postgres in Sequelize

5
Comments
4 min read
SQLite, Perl, and a Boolean

SQLite, Perl, and a Boolean

6
Comments 6
2 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

92
Comments 6
12 min read
Quick post about the SQLite UPSERT and the new RETURNING clause.

Quick post about the SQLite UPSERT and the new RETURNING clause.

4
Comments
2 min read
SQL vs NoSQL - Which is better for you?

SQL vs NoSQL - Which is better for you?

5
Comments 3
5 min read
SQLAlchemy Core in Python: Getting Started

SQLAlchemy Core in Python: Getting Started

7
Comments
2 min read
Bases de datos: Vistas

Bases de datos: Vistas

5
Comments 1
2 min read
Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)

Ծրագրային անվտանգություն՝ SQL Injection (մաս 2)

5
Comments
2 min read
Funções - PostgreSQL

Funções - PostgreSQL

5
Comments
5 min read
PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?

PostgreSQL: como permitir acesso de leitura a apenas algumas colunas de uma tabela?

7
Comments
2 min read
Sanitizing SQL in Rails/ActiveRecord

Sanitizing SQL in Rails/ActiveRecord

7
Comments
3 min read
PlanetScale CLI Basics

PlanetScale CLI Basics

15
Comments
5 min read
Inner and Outer Joins in SQL

Inner and Outer Joins in SQL

10
Comments 2
3 min read
loading...