PGSimCity - How PostgreSQL Works

kept by eddie aug 01

PGSimCity offers an interactive, city‑scape visualization that walks through PostgreSQL’s query execution pipeline, from parsing to storage and highlights optimizer decisions, buffer management, and index usage.

PostgreSQL for Everything
The article argues that PostgreSQL can serve as a versatile backend for diverse applications, from caching to analytics, reducing the need for multiple specialized databases.
also on PostgreSQL, #open-source, #software-engineering, #developer-tools
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue is a zero-bloat Postgres queue engine implemented entirely in PL/pgSQL, using snapshot-based batching and table rotation to avoid the dead-tuple bloat that plagues SKIP LOCKED queues.
also on PostgreSQL, #open-source, #software-engineering, #developer-tools