PostgreSQL

Search…
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)​
Cassandra DB
FoundationDB
Last modified 5mo ago
Copy link
Contents
Notes
Links