PostgreSQL

2 followers
@Benjie@benjie_gillam2
postgraphql/postgraphql
Execute (internal) GraphQL queries from inside PostgreSQL
solidsnack/GraphpostgresQL
PostgreSQL template databases to restore to a known state | End Point
pgMustard – Take the guesswork out of PostgreSQL performance
Migrations
Using statement_timeout to prevent long locks when running migrations against a table depesz.com/2019/09/26/how-to-run-short-alte…
Waiting for PostgreSQL 13 – Support for FF1-FF6 and SSSS datetime format patterns
Migration software
SQL Formatting
darold/pgFormatter
General parsing stuff
Prettier
Job Queue
graphile/worker
Things Benjie Does
graphile/examples
Query building
typeorm/typeorm
CSNW/sql-bricks
AST
PostgreSQL's regression test suite for queries: github.com/postgres/postgres/tree/master/sr…
postgres/postgres
gram.y
postgres/postgres
PostgreSQL: Documentation: 10: 50.3. The Parser Stage
Query Parsing - PostgreSQL wiki
pyramation/pgsql-parser
Preserve comments · Issue #15 · lfittl/libpg_query
lfittl/libpg_query
lelit/pglast
Migrations
Flyway by Boxfuse • Database Migrations Made Easy.
Home - db-migrate
Sqitch: Sensible database change management
graphile/migrate
Your migrations are bad and you should feel bad - djrobstep.com
Scalability
2ndquadrant.com/en/blog/sequential-uuid-gen… UUIDs vs performance
1
Sequential UUID Generators - 2ndQuadrant | PostgreSQL
1
Lessons learned scaling PostgreSQL database to 1.2bn records/ month
PostgreSQL rocks, except when it blocks: Understanding locks
Security
Authentication in PostgreSQL (slides)
https://www.pgcon.org/2018/schedule/attachments/500_20180531_pgcon_auth.pdf