How to use PostgreSQL row-level security (RLS) with EF Core to enforce tenant isolation in multi-tenant apps.
Drasi, a CNCF Sandbox project, enables continuous queries to detect absent events, replacing polling-based systems.
Learn how to download and restore the Stack Overflow database dump into PostgreSQL for practice with real-world data.
Learn how to design effective SQL indexes using query patterns and EXPLAIN ANALYZE, with a case study showing performance improvement from 17ms to 0.04ms.
CritterWatch RC.10 final release before 1.0, with performance optimizations and new SQLite support, ready for live stream demo.
A solution for running database migrations safely when multiple Kubernetes pods start simultaneously, using PostgreSQL advisory locks.
Marten adds TimescaleDB support for hypertables, enabling time-partitioned tables with compression, retention, and continuous aggregates via opt-in configuration.
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.
