Companion databases | Postgres.FM 072 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss companion databases — when and why you might want to add another database management system to your stack (or not), and some specifics for analytics, timeseries, queues, search, and vectors.
Here are some links to things they mentioned:
Heap were using Postgres + Citus for analytics as of 2022 https://www.heap.io/blog/juggling-sta...
Heap recently moved their core analytics to SingleStore (we only spotted this after recording 🤦♂️) https://www.heap.io/blog/heaps-next-g...
Posthog moved their analytics from Postgres to Clickhouse https://posthog.com/blog/clickhouse-v...
Timescale https://www.timescale.com/
Citus https://www.citusdata.com/
Hydra https://www.hydra.so/
Our episode on real-time analytics https://postgres.fm/episodes/real-tim...
Our episode on queues https://postgres.fm/episodes/queues-i...
Our episode on logical replication https://postgres.fm/episodes/logical-...
Full Text Search in PostgreSQL (docs) https://www.postgresql.org/docs/curre...
ZomboDB https://www.zombodb.com/
ParadeDB https://www.paradedb.com/
PeerDB https://www.peerdb.io/
RUM indexes https://github.com/postgrespro/rum
Debezium https://debezium.io/
pgmq https://github.com/tembo-io/pgmq
Tembo https://tembo.io/
pgvector vs Pinecone (Supabase blog post) https://supabase.com/blog/pgvector-vs...
Jepsen analyses https://jepsen.io/analyses
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.