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.
DuckDB 2.0 for Data Engineers: Upgrade Risks and What to Know

DuckDB 2.0 for Data Engineers: Upgrade Risks and What to Know

2
Comments 1
9 min read
I Failed a Technical Interview After 10 Years. Here's the Feedback.

I Failed a Technical Interview After 10 Years. Here's the Feedback.

1
Comments 11
6 min read
QueuePool Limit Reached - When FastAPI Runs Out of Database Connections

QueuePool Limit Reached - When FastAPI Runs Out of Database Connections

Comments
10 min read
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

Comments
8 min read
Three months of sales vanished, and every dbt run was green

Three months of sales vanished, and every dbt run was green

Comments
5 min read
AI Agents Can Run SQL Now. Where Should Database Teams Draw the Line?

AI Agents Can Run SQL Now. Where Should Database Teams Draw the Line?

13
Comments 10
5 min read
My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

My Experience Using SQL: DDL, DML, WHERE and CASE WHEN

Comments
2 min read
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint

Comments
4 min read
The Empty SMALLINT Column That Led Me to Nine More Missing Types

The Empty SMALLINT Column That Led Me to Nine More Missing Types

Comments
2 min read
MSSQL LEDGER TABLES Bulletproof Data Integrity and Authenticity

MSSQL LEDGER TABLES Bulletproof Data Integrity and Authenticity

Comments
4 min read
How AI can investigate a 12 GB export without reading it into a prompt

How AI can investigate a 12 GB export without reading it into a prompt

Comments
6 min read
Query Optimization

Query Optimization

5
Comments
18 min read
PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

PostgreSQL serial vs identity: Which to Use, and How to Convert Old serial Columns

Comments
9 min read
Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Postgres Indexes Under Write Load: Every Index Is a Tax on Every Write

Comments
4 min read
SQL Agents Need Business Context, Not Just Schema

SQL Agents Need Business Context, Not Just Schema

1
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.