> For the complete documentation index, see [llms.txt](https://woodrowpearson.gitbook.io/woodrow-wiki/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://woodrowpearson.gitbook.io/woodrow-wiki/databases/postgresql.md).

# PostgreSQL

## Notes

* [Can use `::1` in Postico to remove unsafe connection warning](https://github.com/jakob/Postico/issues/637)

## Links

* [PostgreSQL Exercises](https://pgexercises.com/)
* [Skor](https://github.com/hasura/skor) - Listen to Postgres events and forward them as JSON payloads to a webhook.
* [PipelineDB](https://github.com/pipelinedb/pipelinedb#readme) - High-performance time-series aggregation for PostgreSQL.
* [pgsync](https://github.com/ankane/pgsync) - Sync Postgres data between databases.
* [Bye bye Mongo, Hello Postgres](https://www.theguardian.com/info/2018/nov/30/bye-bye-mongo-hello-postgres) ([HN](https://news.ycombinator.com/item?id=18717168))
* [The Internals of PostgreSQL](http://www.interdb.jp/pg/index.html) ([HN](https://news.ycombinator.com/item?id=18950460))
* [Slonik](https://github.com/gajus/slonik) - PostgreSQL client with strict types, detail logging and assertions for node.js
* [Postico](https://eggerapps.at/postico/) - Modern PostgreSQL Client for the Mac.
* [prettier-plugin-pg](https://github.com/benjie/prettier-plugin-pg) - Work-in-progress plugin for prettier to support formatting of PostgreSQL-flavour SQL.
* [PostGraphile](https://github.com/graphile/postgraphile) - Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database.
* [WAL-G](https://github.com/wal-g/wal-g) - Archival restoration tool for Postgres.
* [migra](https://github.com/djrobstep/migra) - Like diff but for PostgreSQL schemas.
* [PGHoard](https://github.com/aiven/pghoard) - PostgreSQL backup and restore service.
* [postgresqltuner.pl](https://github.com/jfcoz/postgresqltuner) - Simple script to analyse your PostgreSQL database configuration, and give tuning advice.