PostgreSQL

Notes

• Can use ::1 in Postico to remove unsafe connection warning

Links

• PostgreSQL Exercises

• Skor - Listen to Postgres events and forward them as JSON payloads to a webhook.

• PipelineDB - High-performance time-series aggregation for PostgreSQL.

• pgsync - Sync Postgres data between databases.

• Bye bye Mongo, Hello Postgres (HN)

• The Internals of PostgreSQL (HN)

• Slonik - PostgreSQL client with strict types, detail logging and assertions for node.js

• Postico - Modern PostgreSQL Client for the Mac.

• prettier-plugin-pg - Work-in-progress plugin for prettier to support formatting of PostgreSQL-flavour SQL.

• PostGraphile - Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database.

• WAL-G - Archival restoration tool for Postgres.

• migra - Like diff but for PostgreSQL schemas.

• PGHoard - PostgreSQL backup and restore service.

• postgresqltuner.pl - Simple script to analyse your PostgreSQL database configuration, and give tuning advice.