PostgreSQL 19 introduces new pg_get_*_ddl() functions to generate DDL for databases, roles, and tablespaces.
A developer builds a Django-powered site to host 20,000 photos, exploring the intersection of photography, coding, and tool-building philosophy.
Explores using non-ACID storage (csv_tam) as a workaround for missing autonomous transactions in PostgreSQL, balancing performance and crash safety.
PostgreSQL 19 adds UPDATE/DELETE FOR PORTION OF for temporal tables, simplifying history management.
Overview of multi-tenancy features in the Critter Stack (.NET ecosystem), covering Marten, Wolverine, and Polecat tools.
PostgreSQL 19 adds JSON format to COPY TO, enabling NDJSON-style export of query results and table data.
Guide to using pgvector in .NET for vector search with PostgreSQL, embeddings, and semantic similarity queries.
PostgreSQL 19 adds EXCEPT TABLE support to ALTER PUBLICATION for managing exclusion lists.
PostgreSQL 19 introduces pg_plan_advice, a module to stabilize or override planner decisions for query execution plans.
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.
PostgreSQL 19 adds non-text output formats to pg_dumpall, enabling parallel restore and selective database restoration from cluster-wide backups.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to replicate production query plans in dev environments.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to test production query plans without moving large datasets.
A retrospective on the Marten .NET library's growth over five years, covering adoption drivers like commercial support and documentation improvements.
Explores change-driven architecture on Azure using Drasi to replace polling with Change Data Capture for real-time, efficient data processing.
Guide on connecting PostgreSQL to Dremio Cloud for federated queries, analytics acceleration, and building a semantic layer without data movement.
![[Video] Office Hours at Atlantis, Bahamas](https://crawljobs-blogs-media.s3.us-east-1.amazonaws.com/alldevblogs/thumbs/article-62b73516f150-full-71f9446b.webp)
Brent Ozar answers top-voted SQL Server questions from the community in a video Q&A session recorded in the Bahamas.
Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
Analysis of corporate contributions to the latest PostgreSQL 18 release, ranking companies by commits, code changes, and number of contributors.
