Spring Boot + PostgreSQL
Advanced Performance Tuning in 2026Continue reading on Towards AI »
Advanced Performance Tuning in 2026Continue reading on Towards AI »
A confessional guide to the queries that burned me — and the fixes I wish someone had shown me on day one.I’m going to tell you something embarrassing.Three months into my first data analyst role, I brought down a production dashboard. Not with some ex…
ChatGPT, Copilot, and Gemini can write SQL fast. Sometimes it’s brilliant. Sometimes it’s subtly wrong in ways that will ruin your numbers. Here’s how to tell the difference.SQL is the language of data. If you work anywhere near a database, you’re writ…
SQLite 3.53.0
SQLite 3.52.0 was withdrawn so this is a pretty big release with a whole lot of accumulated user-facing and internal improvements. Some that stood out to me:
ALTER TABLE can now add and remove NOT NULL and CHECK constraints – I’ve …
Image Generated by GeminiIn the modern data stack, the “Build” phase is usually fast, but the “Govern” phase is notoriously slow. We’ve all been there: you finish a complex Snowflake pipeline only to realize you now have to manually write descriptions …
IntroductionContinue reading on Medium »
The edge is where it all happens. It is where innovation is created and where it is delivered. SQL Server workloads must therefore be just as resilient and highly available there as they are in the cloud or in a traditional data center.
The post Why …
Tool: Syntaqlite Playground
Lalit Maganti’s syntaqlite is currently being discussed on Hacker News thanks to Eight years of wanting, three months of building with AI, a deep dive into exactly how it was built.
This inspired me to revisit a res…
You keep hearing about dbt. Your data team uses it. Job listings mention it. Here’s what it actually is, why engineers love it, and how AI tools are making it accessible even if you’ve never touched it before.If you’ve spent any time in data circles re…
Every Monday morning for eight months, I spent three hours copying numbers into a spreadsheet. Then I spent one Saturday afternoon building the thing that gave those hours back forever.Every Monday morning, without fail, for eight straight months — I m…