📝
knowledge
  • links
  • 14-Pure-Education
    • My Knowledge Wiki 🌿
      • .github
        • ISSUE_TEMPLATE
          • Question 🤔
          • bug_report
          • Feature ✨
        • Summary
      • design
        • Animation
        • Fonts
        • Framer
        • Color
        • figma
          • Figma
          • Figma plugins
        • Inkscape
        • Blender
        • Design
        • Interior Design
        • Icons
        • Design inspiration
        • 3D modeling
        • Design systems
        • Industrial Design
        • User Experience
        • Logos
      • databases
        • Neo4j
        • Fauna
        • sql
          • SQL
        • blockchain
          • Cardano
          • Arweave
          • Tezos
          • Polkadot
          • Uniswap
          • Ethereum
          • Blockchain
        • Kdb+
        • Cassandra DB
        • PostgreSQL
        • FoundationDB
        • SQLite
        • Prometheus
        • Dgraph
        • Redis
        • DynamoDB
        • Databases
        • Memcached
        • MariaDB
        • Prisma
        • MongoDB
      • augmented-reality
        • Augmented Reality
        • ARKit
      • art
        • Art
        • Pen plotting
        • Drawing
        • Photography
        • Generative art
        • Sketching
        • Comics
        • Anime
        • Furniture
        • Dancing
        • Architecture
        • Clothes
        • Tattoos
      • computer-graphics
        • computer-vision
          • Optical character recognition
          • Computer vision
        • Procedural generation
        • Metal
        • SVG
        • WebGPU
        • [Ray tracing](https://en.wikipedia.org/wiki/Ray_tracing_(graphics))
        • Computer graphics
        • WebGL
        • CUDA
        • OpenGL
        • Vulkan API
        • Bézier curves
        • Shaders
        • Image processing
        • [Rendering](https://en.wikipedia.org/wiki/Rendering_(computer_graphics))
      • computer-science
        • Parsing
        • algorithms
          • Algorithms
          • Compression
        • Computer Science
        • Computer architecture
        • formal-verification
          • Formal verification
          • TLA+
        • Automata theory
        • data-structures
          • Data structures
      • business
        • startups
          • Marketplaces
          • Funding
          • Values
          • Onboarding
          • Venture capital
          • Startups
          • Payroll
        • Products
        • Business
        • Restaurants
        • Landing pages
        • Pricing
      • compilers
        • LLVM
        • Linters
        • build-systems
          • Build systems
          • Bazel
        • Compilers
      • books
        • Mind for numbers - Review
        • Thinking, fast and slow
        • Brave new world
        • Elements of programming interviews
        • Rich dad poor dad
        • Programming in Haskell
        • Code: hidden language of software
        • Surely you are joking Mr Feynman
        • Books
        • Mindstorms
        • Eloquent ruby
        • go-in-action
        • Crafting interpreters
        • Cracking the coding interview
        • Artificial Intelligence: A Modern Approach
      • devops
        • Observability
        • DevOps
        • Site Reliability Engineering
        • Terraform
      • cryptocurrencies
        • Nano
        • Cryptocurrencies
        • Bitcoin
        • Stellar
        • Libra
        • TON
      • backups
        • Backups
      • 3d-printing
        • 3D Printing
      • distributed-systems
        • message-queue
          • Message queue
          • ZeroMQ
          • MQTT
        • [Load balancing](https://en.wikipedia.org/wiki/Load_balancing_(computing))
        • rpcs
          • gRPC
          • Remote Procedure Calls
        • Distributed systems
        • Conflict-free replicated data type
      • cli
        • Command Line Tools
        • Tmux
        • Ngrok
        • Sed
      • automation
        • Home automation
        • Automation
      • biology
        • Computational biology
        • Biology
        • Evolution
        • genomics
          • DNA
          • Genomics
        • immunology
          • Immunotherapy
          • Immunology
        • Bionics
        • bioinformatics
          • Bioinformatics
        • Viruses
      • cloud-computing
        • serverless-computing
          • AWS Lambda
          • Serverless computing
          • Cloudflare workers
        • Cloud computing
        • gcp
          • Google Cloud
        • aws
          • AWS Amplify
          • AWS
        • azure
          • Azure
      • articles
        • Articles
      • anki
        • Anki
      • data-science
        • Data Science
        • Data Visualization
        • Data processing
        • Apache Kafka
      • consciousness
        • Consciousness
        • Ego
      • documentaries
        • Documentaries
      • Summary
      • api
        • API
      • animals
        • Birds
        • Animals
      • courses
        • Courses
      • analytics
        • Analytics
      • chemistry
        • Chemistry
Powered by GitBook
On this page
  • Notes
  • Links

Was this helpful?

  1. 14-Pure-Education
  2. My Knowledge Wiki 🌿
  3. databases

PostgreSQL

PreviousCassandra DBNextFoundationDB

Last updated 4 years ago

Was this helpful?

Notes

Links

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

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

  • - Sync Postgres data between databases.

  • ()

  • ()

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

  • - Modern PostgreSQL Client for the Mac.

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

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

  • - Archival restoration tool for Postgres.

  • - Like diff but for PostgreSQL schemas.

  • - PostgreSQL backup and restore service.

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

  • ()

  • - PostgreSQL driver and toolkit for Go.

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

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

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

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

  • ()

  • ()

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

  • - Flamegraph generator for Postgres EXPLAIN ANALYZE output.

  • - Serves a fully RESTful API from any existing PostgreSQL database. () () ()

  • - Automatic indexer for Postgres.

  • ()

  • ()

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

  • - Performance dashboard for Postgres.

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

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

  • - PostgreSQL Audit Extension.

  • () ()

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

  • - Low-level IO utilities for PosgtreSQL drivers.

  • - Cross-platform client for PostgreSQL databases.

  • - Postgres migrations and seeding made easy.

  • - Analyze, visualize and share Postgres Query Plans.

  • - PostgreSQL's explain analyze made readable.

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

  • - Advanced scheduling for PostgreSQL. ()

  • - Catch unsafe migrations in development.

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

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

  • - Postgres CLI with autocompletion and syntax highlighting.

  • ()

  • - VueJS component to show a graphical visualization of a PostgreSQL execution plan. () ()

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

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

  • ()

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

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

  • - Postgres partitioning as easy as pie.

  • () ()

  • - PostgreSQL SQL syntax beautifier. ()

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

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

  • - PostgreSQL performances monitoring and auditing tool. ()

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

  • ()

  • - PostgreSQL to Elasticsearch sync.

  • ()

  • ()

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

  • - Adds realtime and restful APIs to Postgres without a single line of code. ([]) () () () ()

  • - Faster PostgreSQL performance and easier scaling.

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

  • - Retrieve a web page from inside the database.

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

  • - Generate Typescript types from Postgres.

  • ()

  • - Modern cryptography for PostgreSQL using libsodium. ()

  • () ()

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

  • ()

  • - Lightweight connection pooler for PostgreSQL. ()

  • ()

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

  • ()

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

  • - Harmful workload generator for PostgreSQL.

  • ()

  • ()

  • - Build Postgres Extensions with Rust. ()

  • ()

  • - Utilities for having a temporary database per test.

  • ()

  • ()

  • - Postgres jumphost with query audit-logging.

  • - Continuous Archiving for Postgres.

  • ()

  • ()

  • - PostgreSQL support company.

  • ()

  • () ()

  • - Supercharges PostgreSQL.

  • ()

  • ()

  • - Isomorphic PostgreSQL client for node. ()

  • - Professional PostgreSQL services. ()

  • - Parse Postgres interval columns.

  • ()

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

  • - Tuning PostgreSQL config by your hardware. ()

  • ()

  • ()

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

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

  • - Prometheus exporter for PostgreSQL server metrics.

  • ()

  • ()

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

  • - Shield sensitive data in Postgres and MySQL.

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

  • - Package for managing PostgreSQL connections at serverless scale.

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

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

  • - Postgres LISTEN & NOTIFY that works.

  • - Handy helpers for PostgreSQL users.

  • ()

  • - Postgres load testing tool.

  • - PostgreSQL Statistics Collector.

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

  • - Create temporary postgres instances. () ()

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

  • - Graph database extension for PostgreSQL.

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

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

  • - Run periodic jobs in PostgreSQL.

  • - PostgreSQL Remote Control. ()

  • ()

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

  • - Command line tool for PostgreSQL server activity monitoring.

  • ()

  • ()

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

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

  • ()

  • ()

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

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

  • ()

  • - PostgreSQL Migrator in PostgreSQL.

  • - Web development platform built entirely in PostgreSQL.

  • ()

Can use ::1 in Postico to remove unsafe connection warning
PostgreSQL Exercises
Skor
PipelineDB
pgsync
Bye bye Mongo, Hello Postgres
HN
The Internals of PostgreSQL
HN
Slonik
Postico
prettier-plugin-pg
PostGraphile
WAL-G
migra
PGHoard
postgresqltuner.pl
Common mistakes in PostgreSQL
HN
pgx
postgres-operator
Fastest Way to Load Data Into PostgreSQL Using Python (2019)
pgfutter
The Art of PostgreSQL
Lobsters
PLV8
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
PostgreSQL Notes
pg_flame
PostgREST
HN
HN 2
Introduction to Postgrest
Postgres Explain Visualizer (pev)
Dexter
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
HN
Web
PgHero
pg-structure
Odyssey
PostgreSQL at low level: stay curious! (2019)
pgAudit
Message DB: Event Store and Message Store for PostgreSQL (2019)
HN
Code
Supabase Realtime
py-pgproto
pgweb
plow
New Plan
New Explain
postgresql.conf
My GOTO Postgres Configuration for Web Services (2020)
pg_timetable
Article
PostgreSQL at Scale: Database Schema Changes Without Downtime (2019)
Strong migrations
PostgreSQL Documentation
HN: The state of full text search in PostgreSQL 12 (2020)
pgmetrics
Web
pgDash
pgcli
Transactionally Staged Job Drains in Postgres (2017)
HN
Postgres source code
Postgres Explain Visualizer (pev)
Code
HN
Awesome Postgres
PostgreSQL Automatic Failover
pgagroal
Distinct On: The Confusing, Unique and Useful Feature in Postgres (2020)
HN
Simplify: move code into database functions
Postgres Weekly
graphile-migrate
pgslice
Things I Hate About PostgreSQL (2020)
HN
Lobsters
pgFormatter
Code
graphile-worker
pgBadger
Code
pgCluu
Code
ZomboDB
Full Text Search in Milliseconds with Rails and PostgreSQL
Using PostgreSQL for JSON Storage
HN
PGSync
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
Supabase
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
Patroni
PostgreSQL HTTP Client
Crunchy Data
Kanel
5 Ways to Host PostgreSQL Databases (2020)
Jepsen: PostgreSQL 12.3 (2020)
HN
pgsodium
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
Web
GitHub
Postgres...as an App? (2020)
Lobsters
PostgreSQL query JIT (2020)
PgBouncer
Code
Indexing JSONB columns in PostgreSQL (2020)
Lobsters
Splitgraph
HN
Running Postgres in Kubernetes
HN
Zero dependancy Pub / Sub system with PostgreSQL (2018)
Ephemeral PostgreSQL
Docs
Managing PostgreSQL Logical Replication (2020)
Noisia
Foreign data wrappers: PostgreSQL's secret weapon? (2020)
HN
PostgreSQL Templates (2020)
HN
pgx
HN
PostgreSQL EXPLAIN glossary
Postgres Job Queues & Failure By MVCC (2020)
PostgreSQL beginner guide (2020)
HN
pgxtesting
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
WAL-E
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
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
PostgreSQL community impact of 2nd Quadrant purchase (2020)
HN
PostgreSQL Contributors
Measuring the Memory Overhead of a Postgres Connection (2020)
HN
prostgles-server
Web
pg_squeeze: Optimizing PostgreSQL storage (2020)
CYBERTEC PostgreSQL
Web
Efficient Evenly Distributed Sampling of Time Series Records in PostgreSQL (2020)
postgres-interval
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
PGTune
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 Observability
HN
PostgreSQL Server Exporter
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
Hypershield
PostgreSQL to PostgreSQL in minutes
Serverless-postgres
pg-shortkey
HN
pg-mem
pg-listen
pgtricks
PGCon 2020
HN
Mastering Postgres indexes in 10 minutes (2020)
pgreplay-go
pg_stat_monitor
hasql-queue
Introducing hasql-queue
tmp-postgres
Keeping Database Tests Fast with tmp-postgres
Faster Database Testing with the New tmp-postgres
DbSchema
Apache AGE
Bucardo.org
Re-Introducing Hash Indexes in PostgreSQL (2021)
postgresql-hll
pg_cron
temBoard
Web
Postgres Guide
Code
Postgres Book Collection
Embedded Postgres Binaries
pg_activity
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
pllua
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
FlameExplain
Code
AWS Babelfish: The Elephant in the PostgreSQL Room? (2021)
HN
Metagration
Aquameta
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)