tags
Postgres
6 posts tagged here.
A Session-Scoped Test Fixture in Rust
Rust's test framework lacks pytest-style fixtures. This post shows how to build them using traits, global state, and ctor.
DO NOT USE LISTEN/NOTIFY for a PostgreSQL Queue
Consumers of a Postgres Queue can either choose LISTEN/NOTIFY or poll for new items. This post recommends polling for PostgreSQL queues.
Why your next queue should use PostgreSQL
Postgres features like FOR UPDATE SKIP LOCKED and UNLOGGED tables make it a strong candidate for queueing. This post explains why and sets up detailed benchmarks.
Use AI Assistants to build pg-logstats
A series that documents building pg-logstats with AI Code Assistants
Database Access Stack in Rust
A primer on accessing databases in Rust
Open Source SQL Parsers
A survey of open source SQL parsers to extract information from query history