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.

• Common mistakes in PostgreSQL (HN)

• pgx - PostgreSQL driver and toolkit for Go.

• postgres-operator - Controller that runs within a Kubernetes cluster that provides a means to deploy and manage PostgreSQL clusters.

• Fastest Way to Load Data Into PostgreSQL Using Python (2019)

• pgfutter - Import CSV and JSON into PostgreSQL the easy way.

• The Art of PostgreSQL - Book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries. (Lobsters)

• PLV8 - V8 Engine Javascript Procedural Language add-on for PostgreSQL.

• HN: PostgreSQL 12 release (2019)

• PostgreSQL: When it’s not your job (2017)

• Postgres Is Underrated—It Handles More than You Think (2019) (Lobsters)

• Postgres Schema Design (HN)

• PostgreSQL for Beginners book - Intended for those who only start getting acquainted with the world of PostgreSQL.

• PostgreSQL Notes

• pg_flame - Flamegraph generator for Postgres EXPLAIN ANALYZE output.

• PostgREST - Serves a fully RESTful API from any existing PostgreSQL database. (HN) (HN 2) (Introduction to Postgrest)

• Postgres Explain Visualizer (pev)

• Dexter - Automatic indexer for Postgres.

• Hypothetical Indexes in PostgreSQL (2019)

• System design hack: Postgres is a great pub/sub & job server (2019) (HN)

• Turning PostgreSQL into a queue serving 10,000 jobs per second (HN)

• PGLoader - Migrate to PostgreSQL in a single command. (HN) (Web)

• PgHero - Performance dashboard for Postgres.

• pg-structure - Get PostgreSQL database structure as a detailed JS Object.

• Odyssey - Advanced multi-threaded PostgreSQL connection pooler and request router.

• PostgreSQL at low level: stay curious! (2019)

• pgAudit - PostgreSQL Audit Extension.

• Message DB: Event Store and Message Store for PostgreSQL (2019) (HN) (Code)

• Supabase Realtime - Listens to changes in a PostgreSQL Database and broadcasts them over websockets.

• py-pgproto - Low-level IO utilities for PosgtreSQL drivers.

• pgweb - Cross-platform client for PostgreSQL databases.

• plow - Postgres migrations and seeding made easy.

• New Plan - Analyze, visualize and share Postgres Query Plans.

• New Explain - PostgreSQL's explain analyze made readable.

• postgresql.conf - Postgres configuration reference. Helps tune and optimize PostgreSQL configuration.

• My GOTO Postgres Configuration for Web Services (2020)

• pg_timetable - Advanced scheduling for PostgreSQL. (Article)

• PostgreSQL at Scale: Database Schema Changes Without Downtime (2019)

• Strong migrations - Catch unsafe migrations in development.

• PostgreSQL Documentation

• HN: The state of full text search in PostgreSQL 12 (2020)

• pgmetrics - Collect and display information and stats from a running PostgreSQL server. (Web)

• pgDash - Comprehensive diagnostic and monitoring solution designed to help you ensure the ongoing health and performance of your PostgreSQL deployment.

• pgcli - Postgres CLI with autocompletion and syntax highlighting.

• Transactionally Staged Job Drains in Postgres (2017) (HN)

• Postgres source code

• Postgres Explain Visualizer (pev) - VueJS component to show a graphical visualization of a PostgreSQL execution plan. (Code) (HN)

• Awesome Postgres

• PostgreSQL Automatic Failover - High-Availibility for Postgres, based on industry references Pacemaker and Corosync.

• pgagroal - High-performance protocol-native connection pool for PostgreSQL.

• Distinct On: The Confusing, Unique and Useful Feature in Postgres (2020) (HN)

• Simplify: move code into database functions

• Postgres Weekly - Free, once–weekly e-mail round-up of PostgreSQL news and articles.

• graphile-migrate - Opinionated SQL-powered productive roll-forward migration tool for PostgreSQL.

• pgslice - Postgres partitioning as easy as pie.

• Things I Hate About PostgreSQL (2020) (HN) (Lobsters)

• pgFormatter - PostgreSQL SQL syntax beautifier. (Code)

• graphile-worker - Job queue for PostgreSQL running on Node.js.

• pgBadger - PostgreSQL log analyzer built for speed with fully detailed reports and professional rendering. (Code)

• pgCluu - PostgreSQL performances monitoring and auditing tool. (Code)

• ZomboDB - Brings powerful text-search and analytics features to Postgres by using Elasticsearch as an index type.

• Full Text Search in Milliseconds with Rails and PostgreSQL

• Using PostgreSQL for JSON Storage (HN)

• PGSync - PostgreSQL to Elasticsearch sync.

• Improved (auto)vacuum in PostgreSQL 13 (2020) (HN)

• HN: Ask HN: What PostgreSQL client do you use? (2020)

• Recursive SQL Queries with PostgreSQL (2020)

• How one word in PostgreSQL unlocked a 9x performance improvement (2020) (HN)

• pgCenter - Command-line admin tool for observing and troubleshooting Postgres.

• Supabase - Adds realtime and restful APIs to Postgres without a single line of code. ([HN]) (Code) (Docs) (JS client) (CLI)

• Queries to monitor your PostgreSQL database

• PostgreSQL BRIN Indexes: Big Data Performance With Minimal Storage (2019)

• PostgreSQL query parallelism can be like a box of chocolates (2020)

• Swarm64 - Faster PostgreSQL performance and easier scaling.

• Patroni - Template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes.

• PostgreSQL HTTP Client - Retrieve a web page from inside the database.

• Crunchy Data - Trusted Open Source PostgreSQL & Commercial Support for the Enterprise.

• Kanel - Generate Typescript types from Postgres.

• 5 Ways to Host PostgreSQL Databases (2020)

• Jepsen: PostgreSQL 12.3 (2020) (HN)

• pgsodium - Modern cryptography for PostgreSQL using libsodium. (HN)

• Serializable Snapshot Isolation in PostgreSQL

• How does MVCC (Multi-Version Concurrency Control) work (2020)

• Looking Back at Postgres (2019) (HN) (Notes)

• The Postgres and Illustra Codelines

• Don't Do This - PostgreSQL wiki

• Citus - Distributed PostgreSQL extension for multi-tenant and real-time analytics workloads. (Web) (GitHub)

• Postgres...as an App? (2020) (Lobsters)

• PostgreSQL query JIT (2020)

• PgBouncer - Lightweight connection pooler for PostgreSQL. (Code)

• Indexing JSONB columns in PostgreSQL (2020) (Lobsters)

• Splitgraph - Build and share data with Postgres, inspired by Docker/Git. (HN)

• Running Postgres in Kubernetes (HN)

• Zero dependancy Pub / Sub system with PostgreSQL (2018)

• Ephemeral PostgreSQL - Quickly spin up a temporary PostgreSQL test databases. (Docs)

• Managing PostgreSQL Logical Replication (2020)

• Noisia - Harmful workload generator for PostgreSQL.

• Foreign data wrappers: PostgreSQL's secret weapon? (2020) (HN)

• PostgreSQL Templates (2020) (HN)

• pgx - Build Postgres Extensions with Rust. (HN)

• PostgreSQL EXPLAIN glossary

• Postgres Job Queues & Failure By MVCC (2020)

• PostgreSQL beginner guide (2020) (HN)

• pgxtesting - Utilities for having a temporary database per test.

• PostgreSQL: bloat, pg_repack, and deferred constraints (2020)

• How we used Postgres extended statistics to achieve a 3000x speedup (2020)

• Postgres Execution Plans - Field Glossary (2019)

• Recursive queries in PostgreSQL (2020) (HN)

• Cloud-Native PostgreSQL on Kubernetes (2020) (Slides)

• Quickly debugging Postgres problems (2020)

• pg-jump - Postgres jumphost with query audit-logging.

• WAL-E - Continuous Archiving for Postgres.

• Postgres Tips And Tricks

• Bootstraping Postgres in your project (2020)

• How to use PostgreSQL's LISTEN/NOTIFY as a simple message queue with psycopg2 and asyncio

• PostgreSQL B-Tree index deduplication (2020) (HN)

• PostgreSQL and Machine Learning (2020)

• Things we learned running Postgres 13 (2020) (HN)

• 2ndQuadrant - PostgreSQL support company.

• Mastering PostgreSQL Administration (2020) (HN)

• Cost savings of using managed PostgreSQL

• How to Fix PostgreSQL Performance Issues with PG Extras (2020)

• 7 Tips for PostgreSQL Bulk Data Loading (2020)

• Zheap: Reinvented PostgreSQL storage (2020) (Lobsters) (HN)

• EDB - Supercharges PostgreSQL.

• PostgreSQL community impact of 2nd Quadrant purchase (2020) (HN)

• PostgreSQL Contributors

• Measuring the Memory Overhead of a Postgres Connection (2020) (HN)

• prostgles-server - Isomorphic PostgreSQL client for node. (Web)

• pg_squeeze: Optimizing PostgreSQL storage (2020)

• CYBERTEC PostgreSQL - Professional PostgreSQL services. (Web)

• Efficient Evenly Distributed Sampling of Time Series Records in PostgreSQL (2020)

• postgres-interval - Parse Postgres interval columns.

• The Surprising Impact of Medium-Size Texts on PostgreSQL Performance (2020)

• Run PostgreSQL by hands (2019)

• PostgreSQL Monitoring for Application Developers (2020)

• PostgreSQL Feature Matrix

• Recurring Events and PostgreSQL (2020)

• What's so exciting about Postgres? With Craig Kerstiens (2020) (HN)

• Building a recommendation engine inside Postgres with Python and Pandas (2020)

• Protocol Buffer extension for PostgreSQL

• Getting Started With Postgres 13 on Ubuntu 20.04 (2020)

• prettier-plugin-pg - Plugin for prettier to support formatting of PostgreSQL-flavour SQL.

• PGTune - Tuning PostgreSQL config by your hardware. (Code)

• Book about PostgreSQL: tuning and scaling (Russian) (Code)

• An Immutable Blog Application in PostgreSQL (2015) (Lobsters)

• Postgres Constraints (2020)

• Distributed Coordination Using Postgres (2020)

• pg_auto_failover - Postgres extension and service for automated failover and high-availability.

• Postgres Observability - Postgres views and functions that contain info you might want to know about a Postgres instance. (HN)

• PostgreSQL Server Exporter - Prometheus exporter for PostgreSQL server metrics.

• How to Analyze a PostgreSQL Crash Dump File (2020)

• PostgreSQL psql command line tutorial and cheat sheet (HN)

• Viva the NoSQL Postgres - Alexande Korotkov (2019)

• The Basics of Views and Materialized Views in PostgreSQL

• Writing a Postgres Foreign Data Wrapper for Clickhouse in Go (2020) (HN)

• RUM access method - Provides access method to work with RUM index. It is based on the GIN access methods code. Can be used for full text search.

• Hypershield - Shield sensitive data in Postgres and MySQL.

• PostgreSQL to PostgreSQL in minutes - Stitch PostgreSQL integration enables you to ETL data from one PostgreSQL database to another PostgreSQL you'd like to use as a data warehouse.

• Serverless-postgres - Package for managing PostgreSQL connections at serverless scale.

• pg-shortkey - YouTube-like Short IDs as Postgres Primary Keys. (HN)

• pg-mem - Experimental in-memory emulation of a postgres database. Useful for unit tests.

• pg-listen - Postgres LISTEN & NOTIFY that works.

• pgtricks - Handy helpers for PostgreSQL users.

• PGCon 2020 (HN)

• Mastering Postgres indexes in 10 minutes (2020)

• pgreplay-go - Postgres load testing tool.

• pg_stat_monitor - PostgreSQL Statistics Collector.

• hasql-queue - Module that utilizes PostgreSQL to implement a durable queue for efficently processing payloads. (Introducing hasql-queue)

• tmp-postgres - Create temporary postgres instances. (Keeping Database Tests Fast with tmp-postgres) (Faster Database Testing with the New tmp-postgres)

• DbSchema - Opinionated database schema management tool that lets you maintain your DB schema with a single ruby file.

• Apache AGE - Graph database extension for PostgreSQL.

• Bucardo.org - PostgreSQL tools for Replication, Monitoring, and Productivity.

• Re-Introducing Hash Indexes in PostgreSQL (2021)

• postgresql-hll - PostgreSQL extension adding HyperLogLog data structures as a native data type.

• pg_cron - Run periodic jobs in PostgreSQL.

• temBoard - PostgreSQL Remote Control. (Web)

• Postgres Guide (Code)

• Postgres Book Collection

• Embedded Postgres Binaries - Lightweight bundles of PostgreSQL binaries with reduced size intended for testing purposes.

• pg_activity - Command line tool for PostgreSQL server activity monitoring.

• Our Journey to PostgreSQL 12 (2021) (HN)

• Postgres Scaling Advice for 2021 (HN)

• Deploy PostgreSQL With TLS in Kubernetes (2021)

• The Image of Postgres (2021)

• Avoiding, Identifying, and dealing with PostgreSQL database corruption (2021)

• Planet PostgreSQL - Aggregator for Postgres blog posts from across the web.

• pllua - Embeds Lua into PostgreSQL as a procedural language module.

• An unexpected find that freed 20GB of unused index space in PostgreSQL (2021) (HN)

• Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses (2021) (HN)

• PostgreSQL: What is a checkpoint? (2021)

• Cleaning Up Your Postgres Database (2021)

• Deep PostgreSQL Thoughts: The Linux Assassin (2021)

• pg-boss - Queueing jobs in Node.js using PostgreSQL like a boss.

• FlameExplain - PostgreSQL EXPLAIN ANALYZE visualizer with advanced quirk correction algorithms. (Code)

• AWS Babelfish: The Elephant in the PostgreSQL Room? (2021) (HN)

• Metagration - PostgreSQL Migrator in PostgreSQL.

• Aquameta - Web development platform built entirely in PostgreSQL.

• Deep PostgreSQL Thoughts: Resistance to Containers is Futile (2021)

• Postgres Trigram search learnings (2021)

• Postgres regex search over 10,000 GitHub repositories (using only a Macbook) (2021)

• JIT-Compiling SQL Queries in PostgreSQL Using LLVM (2017) (HN)

• Faster data migrations in Postgres (2021)

• Fuzzy Name Matching in Postgres (2021)