Comment by fabianlindfors 5 days ago
I've been working on extending Postgres to run on top of FoundationDB, effectively turning Postgres into a distributed database with all the modern features one would expect. Hoping to release an initial version for people to try out very soon!
Sure! So my prototype is implemented as a Postgres extension that hooks into transaction as well table and index storage and implements them on top of FoundationDB.
This makes Postgres itself stateless and all data storage and transaction processing is handled by FoundationDB, turning Postgres into a fully distributed database akin to CockroachDB and others.
This has a number of advantages: - Simple horizontal scaling simply by adding more nodes, including automatic sharding (no need for Citus or similar) - Distributed and strictly serializable transactions across all your data - Automatic replication for durability and read performance. No need to set up read replicas or configure your client to route queries to them. - Built-in fault tolerance that can handle node failures and full zone outages. No need to configure replication and failovers. - Multi-tenancy through FoundationDB's built-in tenants feature
All this while not just maintaining Postgres compatibility but actually being Postgres, so hopefully all the features/extensions you know and love will be supported.
I'm planning on publishing to this repo if you want to keep an eye on it: https://github.com/fabianlindfors/pgfdb. Likely won't publish any of the source at first but just some instructions for testing it out.
Can you provide more info? Use-cases, how would it work, where will you publish it?