Analysis of a complex RCE attack chain in PostHog exploiting SSRF, a ClickHouse SQL 0day, and default PostgreSQL credentials.
A guide on integrating Asyncpg with FastAPI and Air for direct PostgreSQL database access, bypassing heavier ORMs like SQLAlchemy.
A guide to setting up asynchronous PostgreSQL operations with SQLModel and FastAPI, including code examples for async engines and sessions.
Explains the difference between restart_lsn and confirmed_flush_lsn in PostgreSQL replication slots for troubleshooting and optimization.
Best practices for managing PostgreSQL replication slots to prevent WAL bloat and ensure reliable CDC pipelines in production.
Explains how Postgres 17 introduces built-in failover replication slots, improving high availability for logical replication and CDC tools like Debezium.
Explains how to automatically maintain 'updated_at' timestamps in PostgreSQL using DEFAULT values, offering a simpler alternative to triggers.
Explains how to use Debezium for CDC from Postgres 16 stand-by servers and manage logical replication slots during failover.
Investigates unexpected WAL growth in an idle Postgres database due to an inactive replication slot, with analysis and solution.
A tutorial on building a REST API using Express.js and PostgreSQL, covering database integration and CRUD operations.
A tutorial on connecting a PostgreSQL database to an Express.js application using the Sequelize ORM.
Exploring how to use Java 16's new Unix-domain socket support to connect to a PostgreSQL database for improved security and performance.
A guide to automating PostgreSQL database backups using scripts and AWS S3 for secure, reliable cloud storage.
A guide on using pg_dump and pg_restore to backup and restore a PostgreSQL database, crucial for data protection in DevOps.
A step-by-step tutorial for installing and setting up PostgreSQL on MacOS using Homebrew, including database creation and server management.
A step-by-step tutorial for installing and setting up PostgreSQL 11 on a Windows operating system.
Analysis of the 'fsyncgate' email thread discussing PostgreSQL's unsafe handling of fsync errors that can lead to data corruption.
Explores using PostgreSQL's full text search and trigram similarity in Django for a college search feature, detailing implementation choices.
A tutorial on configuring a Laravel application to use a PostgreSQL database when deploying on the Heroku platform.
