A talk exploring PostgreSQL generated columns by example, covering virtual vs stored behavior, performance trade-offs, and Django integration.
Guide to creating Azure HorizonDB clusters, compute scaling, graph DB, and AI pipelines in Microsoft's new PostgreSQL-based data platform.
A blog post listing database job opportunities for June 2026, with rules for employers to post positions and links to related hiring posts.
Talk at PyCon Italia 2026 on Django's GeneratedField, covering practical examples, trade-offs, and evolution from Django 5.0 to 6.0.
Solutions to SQLAlchemy 2 exercises covering database queries, relationships, and async features.
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.
