21h ago · 2 min read · PostgreSQL patterns that separate basic SQL from production-grade queries. Window functions without GROUP BY collapsing rows -- Top 3 earners per department: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC)...
Join discussion1d ago · 2 min read · PostgreSQL diagnostics and the patterns you need before you're staring at production slow queries. psql meta-commands — faster than any GUI \l -- list databases \c mydb -- connect to database \dt -- list tabl...
Join discussion1d ago · 2 min read · MySQL diagnostics and the patterns you need before you're staring at a slow query in production. EXPLAIN type column — what you're looking at The type column in EXPLAIN tells you how MySQL is scanning the table: typeMeaningAction constPrimary ...
Join discussion2d ago · 7 min read · The numbers are worse than you think SQL injection is not a legacy problem. It is an active one. In 2024, over 2,400 SQL injection CVEs were filed in open source projects alone. In closed source appli
Join discussion