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.
Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

Interactive simulators let you break systems first
devopsdaily profile

Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

#database #systemdesign #sql #caching
11
Comments 5
5 min read
I Replaced SQLite's C Driver with 800 Lines of Pure Python Stdlib: What the Docs Don't Tell You About Raw B-Trees, 9-Byte Varints, and 48-Bit Integers
sandman_sh profile

I Replaced SQLite's C Driver with 800 Lines of Pure Python Stdlib: What the Docs Don't Tell You About Raw B-Trees, 9-Byte Varints, and 48-Bit Integers

#python #sql
Comments
15 min read
PostgreSQL MVCC: Why Bloat Doesn't Automatically Mean Expensive Reads
franckpachot profile

PostgreSQL MVCC: Why Bloat Doesn't Automatically Mean Expensive Reads

#postgres #sql #database #mvcc
Comments
22 min read
How I built one open-source SQL workspace for five database engines
cccadet profile

How I built one open-source SQL workspace for five database engines

#opensource #sql #database #typescript
Comments
4 min read
SQL JOINs: A Practical Guide to Combining Data from Multiple Tables
melvinkip profile

SQL JOINs: A Practical Guide to Combining Data from Multiple Tables

#sql
1
Comments
8 min read
SQL Joins: Combining Data Across Tables
fidel_okumu profile

SQL Joins: Combining Data Across Tables

#database #programming #sql #tutorial
1
Comments
2 min read
An AI-generated login endpoint "works" - I still found SQL concatenation before launch
yuan_ming_3549dae7e400994 profile

An AI-generated login endpoint "works" - I still found SQL concatenation before launch

#ai #python #security #sql
Comments 1
3 min read
SafariConnect: From a Broken Excel Export to a Board-Ready Analysis in PostgreSQL
leahkivuti profile

SafariConnect: From a Broken Excel Export to a Board-Ready Analysis in PostgreSQL

#data #database #sql
Comments 1
11 min read
SQL Fundamentals: DDL and DML Commands with Practical Examples
melvinkip profile

SQL Fundamentals: DDL and DML Commands with Practical Examples

#database #sql #tutorial
1
Comments
7 min read
DDL & DML: The Two Halves of SQL
fidel_okumu profile

DDL & DML: The Two Halves of SQL

#beginners #database #sql #tutorial
1
Comments
2 min read
Six Tables Out of 260
ashish_sinha_5241c7673d93 profile

Six Tables Out of 260

#ai #sql #python #database
Comments
3 min read
Why RBAC Alone Isn't Enough for Enterprise Data Agents
arisyndata profile

Why RBAC Alone Isn't Enough for Enterprise Data Agents

#ai #agents #llm #sql
1
Comments 1
7 min read
Subqueries & CTEs: Breaking Complex Queries into Steps
fidel_okumu profile

Subqueries & CTEs: Breaking Complex Queries into Steps

#backend #database #sql #tutorial
1
Comments
2 min read
SQL NULL vs empty string vs zero
nexus_vibes profile

SQL NULL vs empty string vs zero

#sql
Comments 1
1 min read
DDL and DML in PostgreSQL: Cleaning 286 Messy Hotel Bookings.
leahkivuti profile

DDL and DML in PostgreSQL: Cleaning 286 Messy Hotel Bookings.

#postgres #database #beginners #sql
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.