3 ms·
Definitely use a big database, until you can't. My advice to anyone starting with a relational data store is to use a proxy from day 1 (or some point before add
by ryanisnan 4y ago
Definitely use a big database, until you can't. My advice to anyone starting with a relational data store is to use a proxy from day 1 (or some point before adding something like that becomes scary).
When you need to start sharding your database, having a proxy is like having a super power.
- _ben_ 4y agoDisclaimer: I am the founder of PolyScale [1]. We see both use cases: single large database vs multiple small, decoupled. I agree with the sentiment that a large database offer simplicity, until access patterns change. We focus on distributing database data to the edge using caching. Typically this eliminates read-replicas and a lot of the headache that goes with app logic rewrites or scaling "One Big Database". [1] https://www.polyscale.ai/ https://www.polyscale.ai/
- chromatin 4y agoAre there postgres proxies that can specifically facilitate sharding / partitioning later?