Just now · 12 min read · Materialization strategies: how Bruin and dbt turn SELECT queries into tables Every SQL-based data pipeline tool faces the same problem: you wrote a SELECT query, and now you need it to exist as a table (or view) in your warehouse. The logic that bri...
Join discussion1d 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
2d ago · 6 min read · You push the code on Friday afternoon. Tests pass. Staging looks fine. You deploy and go home. At 2am your phone rings. Response times are 8 seconds. Users are abandoning. The on-call engineer is star
Join discussion
3d ago · 7 min read · There are three serious open source SQL static analyzers worth knowing about in 2026. Most engineers have heard of SQLFluff. Fewer know Squawk. SlowQL is newer. They solve different problems and the d
Join discussion
2d ago · 3 min read · The Default Habit That Kills Scalability It is the default in almost every tutorial on the internet. You create a new database migration, and the very first line creates a nice, clean, auto-incrementi
Join discussion