Our great sponsors
REST API for any Postgres database
I love postgres for most things but these days (Especially while my product is in development, embedded, or just not internet-facing) sqlite is amazingly workable.
Killer postgres features however: Row-level security (Amazing when you're using something like postgrest for rapid application development ), and its built in fulltext search engine is 'good enough' for use cases like when you have an enormous users table and need to index something simple enough, like email addresses for quick login.
Postgres extension and service for automated failover and high-availability
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
A curated re-sources list for awesome Apache Kafka
Messaging is the first use-case given by the Kafka docs  and is the first core capability they mention on the Kafka landing page .
I think use (and think of) Kafka as a message bus, with distributed commit logging being the mechanism for how it accomplishes that task.
Postgres operator creates and manages PostgreSQL clusters running in Kubernetes (by zalando)
My favorite route right now is running a postgres operator on Kubernetes & letting it do all the work for me.
Zalando's operator use Patroni under the hood, to create a cluster over streaming replication. It also has Spilo, which orchestrates pg_basebackup or WAL-E for point-in-time backup. https://github.com/zalando/postgres-operator#postgresql-feat...
CrunchyData operator seems to have built their own streaming replication system coordinated by Raft. https://access.crunchydata.com/documentation/postgres-operat...
Distributed PostgreSQL as an extension
As always: it depends. For some workloads something like Citus  might allow you stay within the PostgreSQL ecosystem even when you are trying to do OLAP.
Synchronous multi-master replication library
Talks on PostgreSQL, Go and YACC (by jmscott)
postgresql handles queues well. the trick is skip lock.
Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.
Can someone share experience configuring Highly Available PgSQL?
8 projects | reddit.com/r/PostgreSQL | 26 Mar 2023
How to use Supabase RLS with third-party client library?
2 projects | reddit.com/r/Supabase | 17 Feb 2023
Features I'd Like in PostgreSQL
14 projects | news.ycombinator.com | 28 Jan 2023
Any self hostable postgres clustering, replication and fail over system?
3 projects | reddit.com/r/PostgreSQL | 25 Jan 2023
A Poor Man's API
7 projects | news.ycombinator.com | 28 Nov 2022