Go offline with the Player FM app!
Companion databases
Manage episode 384291467 series 3369151
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, 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-state-machines-incident-response-and-data-soup-a-glimpse-into-heaps-engineering-culture
- Heap recently moved their core analytics to SingleStore (we only spotted this after recording 🤦♂️) https://www.heap.io/blog/heaps-next-generation-data-platform
- Posthog moved their analytics from Postgres to Clickhouse https://posthog.com/blog/clickhouse-vs-postgres
- 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-time-analytics
- Our episode on queues https://postgres.fm/episodes/queues-in-postgres
- Our episode on logical replication https://postgres.fm/episodes/logical-replication
- Full Text Search in PostgreSQL (docs) https://www.postgresql.org/docs/current/textsearch.html
- 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-pinecone
- Jepsen analyses https://jepsen.io/analyses
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
109 episodes
Manage episode 384291467 series 3369151
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, 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-state-machines-incident-response-and-data-soup-a-glimpse-into-heaps-engineering-culture
- Heap recently moved their core analytics to SingleStore (we only spotted this after recording 🤦♂️) https://www.heap.io/blog/heaps-next-generation-data-platform
- Posthog moved their analytics from Postgres to Clickhouse https://posthog.com/blog/clickhouse-vs-postgres
- 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-time-analytics
- Our episode on queues https://postgres.fm/episodes/queues-in-postgres
- Our episode on logical replication https://postgres.fm/episodes/logical-replication
- Full Text Search in PostgreSQL (docs) https://www.postgresql.org/docs/current/textsearch.html
- 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-pinecone
- Jepsen analyses https://jepsen.io/analyses
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
109 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.