Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Cover image for READ COMMITTED anomalies in PostgreSQL

Franck Pachot for AWS Heroes

Jul 13 '21

READ COMMITTED anomalies in PostgreSQL

#database #sql #postgres

5 min read

Cover image for Common Table Expressions(CTE) in SQL Server

Jul 13 '21

Common Table Expressions(CTE) in SQL Server

#sqlserver #webdev #sql #database

12 min read

Aashish Chaubey 💥⚡️

Jul 11 '21

What is the difference between SQL and SQL Server (and similar tools)? 😇🎉

#sql #mustknow #beginners #programming

3 min read

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

Gavin for YugabyteDB

Jul 9 '21

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

#yugabytedb #distributedsql #sql #database

2 min read

Jul 7 '21

A Next-Generation ORM: Prisma

#webdev #sql #node #javascript

6 min read

John Baker

Jul 8 '21

Running SSIS Packages with Python

#python #ssis #sql #etl

3 min read

Cover image for Constraints in SQL

Jul 7 '21

Constraints in SQL

#sql #database

1 min read

Cover image for Anvil Platform : Build Full-Stack Apps with only Python

Bek Brace

Jul 5 '21

Anvil Platform : Build Full-Stack Apps with only Python

#python #javascript #html #sql

2 min read

Cover image for Utilizing BigQuery as a Data Warehouse in a distributed application

Arctype Team for Arctype

Jul 6 '21

Utilizing BigQuery as a Data Warehouse in a distributed application

#database #sql #tutorial #python

9 min read

Cover image for SQL queries through REST available now!

Nicolas Penot for Siodb

Jul 6 '21

SQL queries through REST available now!

#sql #database

1 min read

Cover image for How to create table in SQL?

Jul 5 '21

How to create table in SQL?

#sql #database

1 min read

Franck Pachot for YugabyteDB

Jul 5 '21

pg_hint_plan and single-table cardinality correction

#postgres #yugabytedb #sql #database

8 min read

Cover image for Which database to choose for your project

Vladislav Kopylov

Jul 3 '21

Which database to choose for your project

#database #programming #sql #nosql

5 min read

Cover image for Security vulnerabilities – how to find and fix them

Nikita Pupko for datarockets

Jul 2 '21

Security vulnerabilities – how to find and fix them

#sql #ruby #rails

4 min read

Cover image for How to build internal tools on Stripe with SQL

Jul 1 '21

How to build internal tools on Stripe with SQL

#stripe #sql #tutorial #postgres

19 min read

Jun 29 '21

Postgres pg_stat_statement setup via docker

#postgres #sql

2 min read

Cover image for Using Dapper over EntityFramework for database operations in .NET Core

Jun 28 '21

Using Dapper over EntityFramework for database operations in .NET Core

#dotnet #database #performance #sql

4 min read

Cover image for Different Ways to Load Data From CSV Files in PostgreSQL

Jun 27 '21

Different Ways to Load Data From CSV Files in PostgreSQL

#postgres #python #sql #programming

3 min read

Jun 26 '21

GitHub Stargazers over time using Google Charts

#github #sql #selenium #python

4 min read

Jun 25 '21

Querying ActiveStorage Attachments

#activestorage #rails #ruby #sql

1 min read

InterSystems Developer for InterSystems

Jun 25 '21

Know Your Indices

#indexing #performance #sql #practice

26 min read

Rob Reid

Jun 24 '21

My favourite backend tools

#tooling #backend #kubernetes #sql

7 min read

Cover image for What is Cost-based Optimization?

Alexey Goncharuk

Jun 2 '21

What is Cost-based Optimization?

#queryoptimizer #apachecalcite #sql #database

5 min read

Alexandre Nédélec

Jun 22 '21

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

#sql #azure #csharp #dotnet

8 min read

Jun 16 '21

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

#database #sql #mysql

3 min read

loading...