Latest News

SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration

SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration Today's Highlights This week's highlights feature a de…

DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist

DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist Today's Highlights This week's highlights include powerful new Iceberg data manip…

Moving MySQL, Postgres, SQLite, or SQL Server to Cloudflare D1? @zintrust/d1-migrator does it resumably — checkpoints, row-count + checksum verification, dry-run preview, and zero downtime. No more silent data loss halfway through a million-row import.

Migrate MySQL, Postgres, SQLite, or SQL Server to Cloudflare D1 — with checkpoints and integrity checks zintrust Zin zintrust Zin zintrust Zin Follow …

Epic Clarity Data Model Guide for Healthcare Data Engineers

Epic is installed at approximately 38% of US hospitals . If you work in healthcare data engineering long enough, you will encounter Epic Clarity. This…

How do I answer "what did my data look like last month" in Postgres?

Sooner or later, someone asks: "What did this customer's plan look like when they signed up last February?" The current row won't tell you that; it's …

ORA-00060 Deadlock: Find It, Fix It, Prevent It

ORA-00060: deadlock detected while waiting for resource is one of the most misunderstood errors Oracle throws. The two myths that cause the most damag…

AI-Assisted SQL Development with Claude Code — Rules, Skills and Agents That Enforce Conventions

A stored procedure, a migration script, a complex report — Claude Code writes them in seconds. That's the easy part. The hard part starts afterwards: …

2am.tech Releases SQL Migration Tool to Streamline Database Changes

Database migrations have a reputation for going wrong at the worst possible moment. Omitted rollback scripts, schema changes applied to production but…

SQL Server Heaps: Understanding Tables Without Clustered Indexes

Database Deep Dive Series – Part 1 Welcome to the Database Deep Dive Series , where I explore database concepts through practical examples, SQL script…

Your Postgres already knows why it's slow — you just have to ask it

Keeping our database fast at Atlas was part of my job — alongside writing code and shipping features. And a big chunk of that job was unglamorous: cha…

Open Source Project of the Day (#116): SAG — Multi-Hop RAG Retrieval via SQL JOINs Instead of PageRank

Introduction "Graph RAG typically pre-builds a global graph offline, then uses PageRank for query-time scoring and expansion — but PageRank has decay:…

SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension

SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension Today's Highlights This week, we delve into SQLite's secure deletion and blob upd…

Database Indexing and Query Optimization for Python Developers

Introduction Fixing N+1 queries with select_related / prefetch_related or selectinload (see the previous post ) gets you down to a small, sane number …

Database Indexing and Query Optimization for Java Developers

Introduction Fixing N+1 queries (see the previous post ) gets your Hibernate app down to a handful of queries per request. The next bottleneck is what…

Why Your Database Index Gets Ignored (and How to Design One That Isn't)

TL;DR: An index can exist and still do nothing for your query. A multi-column index only serves queries that use its columns from the left, in the ind…

The Database Architect Teaches His Nephew: Where the Real Interview Happens

Same uncle, this time in "Database Architect" mode. Same nephew, this time asking the question every backend developer eventually asks out loud. Part …

Tracking Tableau Viewership with PostgreSQL

Tracking Tableau Viewership with PostgreSQL Tableau's native "Who has seen this view?" panel is a flat list — no trends, no way to tell if usage is re…

Data Engineer LeetCode: What to Grind and What to Skip

I spent about 80 hours grinding LeetCode before my first FAANG data engineering loop. Binary trees, dynamic programming, graph traversal. I could reve…

Today I got a very painful reminder of the importance of using transactions in database migrations.

How to implement RBAC in Go

My intention with this article is to show how I'd implement role-based access control (RBAC) if I had to - in the hope that it acts as a guide for whe…

CTE vs Temporary Tables in SQL: Which One Should You Use?

One of the most common questions I get from developers working with SQL is: Should I use a CTE or create a temporary table? Both solve similar problem…

When to denormalize, when to join: A ClickHouse guide (2026)

Denormalization has been the standard approach to analytical data modeling for good reason. Moving joins, lookups, and business rules out of query tim…

One query language for SQL, Mongo, and the browser: the case for Forge

There's a moment in most TypeScript backend projects when the data layer stops being one thing. Maybe you started on Postgres, then a feature shipped …

Day 83 of Learning MERN Stack

Hello Dev Community! 👋 It is officially Day 83 of my 100-day full-stack and database engineering streak! Yesterday, I mastered DML mutations like UPDA…

Day 82 of Learning MERN Stack

Hello Dev Community! 👋 It is officially Day 82 of my 100-day full-stack engineering run! Yesterday, I unpacked reporting pipelines using aggregation b…

Day 76 of Learning MERN Stack

Hello Dev Community! 👋 It is officially Day 76 of my 100-day full-stack engineering streak! For the past several weeks, I have been heavily immersed i…

How to Talk to Any Database Using AI: Building a Text-to-SQL App

In today’s data-driven world, getting information out of a database usually requires knowing SQL. But what if you could just ask your database a quest…

sqlex — A Modern Drop-in Replacement for jmoiron/sqlx

title: sqlex — A Modern Drop-in Replacement for jmoiron/sqlx published: false description: sqlex is a fully API-compatible modernization of jmoiron/sq…

I Reverse Engineered a Closed-Format App. Everything Was in SQLite.

I had accumulated over two thousand notes in Youdao Cloud Note over several years. When I decided to move to Obsidian, the first thing I checked was t…

SQL window functions: what separates a mid-level from a senior developer

Most developers know SELECT, JOIN, and GROUP BY. Window functions are where the gap between mid and senior starts to show. What makes window functions…