Postgres HyperLogLog Extension
This domain may be for sale!
citusdata/postgresql-hll: PostgreSQL extension adding HyperLogLog data structures as a native data type
PostgreSQL extension adding HyperLogLog data structures as a native data type
How to effectively dump PostgreSQL databases – select * from depesz;
recovery.conf is gone in PostgreSQL v12 - Cybertec
In PostgreSQL v12, "recovery.conf" has been absorbed into "postgresql.conf". This article describes the changes and how you can adapt to them.
message-db/message-db: Microservice native message and event store for Postgres
Microservice native message and event store for Postgres
porsager/postgres: Fastest full featured PostgreSQL client for Node.js
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare - GitHub - porsager/postgres: Postgres.js - The Fastest full featured PostgreSQL client for Node.js, ...
ElephantSQL - PostgreSQL as a Service
ElephantSQL - PostgreSQL as a Service. The most advanced open-source database, hosted in the cloud.
Amazon RDS を PostgreSQLのメジャーバージョンとマイナーバージョンにアップグレードするためのベストプラクティス | Amazon Web Services ブログ
オープンソースの PostgreSQL は、頻繁に発生するバグ、セキュリティの問題、データ破損の問題の修正 […]
Supabase
Supercharge PostgreSQL.
Odyssey Advanced multi-threaded PostgreSQL connection pooler and request router
PostgreSQL count(*) made fast - Cybertec
count(*) is often quite slow in PostgreSQL. This article explores how to count rows faster using approximations and other tricks.
djrobstep.com
migra is a schema comparison tool for PostgreSQL.
PostgreSQL at low level: stay curious! · Erthalion's blog
RDS PostgreSQL トランスポータブルデータベースを使用したデータベースの移行 | Amazon Web Services ブログ
Amazon RDS for PostgreSQL が、バージョン 11.5 以降および 10.10 以降で、 […]
The Art of PostgreSQL: a modern PostgreSQL book in 2019
The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!
yandex/odyssey: Scalable PostgreSQL connection pooler
Scalable PostgreSQL connection pooler. Contribute to yandex/odyssey development by creating an account on GitHub.
State of Postgres
postgrespro/pg_variables: Session wide variables for PostgreSQL
Azure Database for PostgreSQL - Hyperscale (Citus) now generally available - Microsoft Tech Community - 1014865
Relational databases have been around since the dawn of time, well not quite that long, but it has been a long time for them. The biggest knock against them..
erthalion/pg_simdjson: Postgres extension for parsing json using simdjson library
Postgres extension for parsing json using simdjson library
B-tree index improvements in PostgreSQL v12 - Cybertec
The B-tree index has improved in PostgreSQL v12. This article describes these improvements using examples to make them easy to understand.
karlkeefer/pngr: dockerized (postgres + nginx + golang + react)
dockerized (postgres + nginx + golang + react). Contribute to karlkeefer/pngr development by creating an account on GitHub.
Pulling the trigger: How to update counter caches in your Rails app without Active Record callbacks — Martian Chronicles, Evil Martians’ team blog
Keeping your counter caches in sync using nothing but database triggers
Similarity in Postgres and Rails using Trigrams · pganalyze
We look into the pg_trgm extension, seeing first what trigrams actually are, and then how we can practically use similarity functions and operators in our Rails apps.
Avoid OR for better PostgreSQL query performance - Cybertec
OR in the WHERE condition of a PostgreSQL database query is usually a cause of bad query performance. How to rewrite queries without OR.
vitaly-t/pg-minify: Minifies PostgreSQL scripts.
Minifies PostgreSQL scripts. Contribute to vitaly-t/pg-minify development by creating an account on GitHub.
Postgres.ai / postgres-checkup β · GitLab
[Beta] postgres-checkup: PostgreSQL Health Check and SQL Performance Analysis
Architecting petabyte-scale analytics by scaling out Postgres on Azure with the Citus extension
How does the Windows team at Microsoft assess the quality of new software builds to decide if an update is ready to ship?
はじめてのPostgreSQLモニタリング入門 / PostgreSQL 11 Monitoring - Speaker Deck
System design hack: Postgres is a great pub/sub & job server
If you need a publish/subscribe or job server at any point in your project, try using Postgres. It'll give you lots of data integrity and performance guarantees, and it doesn't require you or your team learning any new technology.