Tutorial on backing up PostgreSQL in Docker locally, to S3, and using Plakar, including restore steps.
A personal recap of Data Saturday Rheinland 2026, covering PostgreSQL, SQL Server, GenAI, and data literacy sessions.
PostgreSQL 20 adds min() and max() aggregate functions for UUID type, enabling chronological queries with UUIDv7.
Techniques for achieving partition pruning in PostgreSQL when filtering by non-partition key columns.
PostgreSQL 20 adds per-backend lock statistics with a new system function pg_stat_get_backend_lock() for detailed lock monitoring.
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.
Explores Dynamic Consistency Boundary (DCB) in Event Sourcing with Marten 9.0, highlighting new HSTORE-based performance improvements.
Step-by-step guide to upgrade PostgreSQL from version 17 to 18 on Ubuntu 26.04 after a system update.
Guide on adding Polish text search configuration to PostgreSQL, including future support in version 19.
PostgreSQL 19 adds CONCURRENTLY option to REPACK, reducing locks during table repacking by using replication slots and logical decoding.
PostgreSQL 19 introduces online enabling and disabling of data checksums without cluster downtime.
A technical guide on implementing the Saga pattern in .NET using Wolverine, covering setup, message routing, and saga state persistence.
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.
