5 ms·
We're currently grappling with trying to build a system similar to https://stripe.com/sigma https://stripe.com/sigma with a single multi-tenant Postgres db as t
by markhalonen 3y ago
We're currently grappling with trying to build a system similar to https://stripe.com/sigma https://stripe.com/sigma with a single multi-tenant Postgres db as the source and an SQLite read replica per tenant. Currently we re-generate the world every night. We need fine-grained control over the SQLite schema (it's a public api we let users write sql against). Any related projects would be great to point me towards!
- kobieps 3y ago[dead]
- hinkley 3y agoWe need a standardized WAL format. Too many people trying to write software to simulate it.
- social_quotient 3y agoWAL = write-ahead logging?
- hinkley 3y agoYep, and the world is now full of apps that read one WAL format and copy the data somewhere else. This app, Kafka, “data lake” replication to heterogeneous databases, several other flavors of database replication, on and on. And every bit of it is custom to the WAL format of the source database.