A developer explains how Claude Code convinced them to simplify SQL JOINs by moving filters from ON to WHERE clauses for better readability.
Explains how to simplify ANTI JOIN queries using jOOQ syntax and implicit join paths.
Explores nine key design tradeoffs in query engines like PostgreSQL, ClickHouse, and DuckDB, covering storage, indexing, execution, and concurrency.
Interview with Branimir Lambov, a Cassandra committer at IBM, discussing his work on Trie in LSM Tree and compaction strategies.
Building a web traffic analytics solution with SQLAlchemy 2, covering blog articles and authors database models.
Guide on adding Polish text search configuration to PostgreSQL, including future support in version 19.
Advanced many-to-many relationships in SQLAlchemy 2, covering join tables with extra columns and order management.
Tutorial on implementing many-to-many relationships in SQLAlchemy 2, using products and countries as an example.
PostgreSQL 19 introduces pg_plan_advice, a module to stabilize or override planner decisions for query execution plans.
Explores the GA release of Copilot in SQL Server Management Studio (SSMS), focusing on its code completion and chat features for SQL development.
EF Core 11.0 introduces a single command to create and apply migrations, streamlining development workflow.
PostgreSQL 19 introduces the REPACK command, merging VACUUM FULL and CLUSTER functionality to combat table bloat.
PostgreSQL 19 will allow excluding specific tables from logical replication publications using the new EXCEPT TABLE syntax.
Announcing a beginner-friendly webinar series on SQL Server indexing concepts, starting with clustered indexes.
Author introduces his book 'SQLAlchemy 2 In Practice', sharing the preface and outlining chapters on the popular Python ORM.
Monthly job board for database professionals, featuring direct hiring posts from companies for February 2026 roles.
Explains how to display PostgreSQL timestamps with a specific timezone offset, including a custom function solution.
Microsoft re-released SQL Server 2022 Cumulative Update 23 (CU23) with fixes, including a security update, and discusses patching strategies.
A developer recounts debugging a PostgreSQL container stability issue that turned out to be a hidden security vulnerability, sharing lessons learned.
Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
