November 22 · ArticleSeven SQL Mechanisms That Trip Teams Up in Production: Row Filtering, Faster Reads, and Deadlocks👍 19
November 22 · NoteSix SQL Constraints That Keep Junk Out of Your Database: Why App Validation Isn't Enough👍 9
November 21 · Thematic roundupThree Practical SQL Techniques: Speeding Up Search from 2.5s to 80ms, Index Cardinality, and Finding Duplicates with LAG3 sections👍 8
November 20 · NoteOpenIDE DB Client 0.0.23: Six New Databases, Parameterized SQL with Preview, and Kerberos Login👍 18
October 25 · Thematic roundupData Processing Cheat Sheet: 50 Common Operations and SQL Execution Order2 sections👍 0
November 15 · NoteSQL Subtotals Without Workarounds: How WITH ROLLUP Builds Hierarchical Reports in One Query👍 22
October 27 · Thematic roundupFresh PostgreSQL Extensions: Hypothetical Indexes, Exact Percentiles, and Incremental Views3 sections👍 0
October 24 · LongreadSteampipe: Declarative Auditing of AWS, GCP, and Kubernetes Infrastructure With SQL👍 0
October 23 · ArticleAI Agents for ClickHouse: Connecting LLMs to Analytical DBs Without Cloud Subscriptions👍 0
October 21 · ArticleData Transformation Made Simple: 10 Operations in SQL, Pandas, and Power BI DAX👍 0