4 ms·
How do ya'll deal with the distance between DB and edge?
by threatofrain 3y ago
How do ya'll deal with the distance between DB and edge?
- tracker1 3y agoAt this point, my first choice would be https://www.cockroachlabs.com/ https://www.cockroachlabs.com/ (CockroachDB SaaS), which can allow for distributed instances... if your concern is more localized reads. Most cloud databases have tradeoffs. CockroachDB's advantages are pretty good horizontal scaling and mostly compatible to PostgreSQL from the wire protocol, datatypes and most basic queries. The down sides, is it does help to at least understand horizontal database scaling, sharding, etc. so that you can use techniques that will avoid the worst bottlenecks (namely sequential number generation and joins). Not sure what this provider offers and there are definitely other solutions from other cloud providers and service (Mongo, and others) or self-hosting a multi-region db with ScyllaDB/Cassandra even.
- rad_gruchalski 3y agoHave a look at YugabyteDB. Fully distributed Postgres with geo data placement constraints, replication, read replicas, joins, triggers, Postgres extensions. It's actual Postgres under the hood. They offer managed solutions but YugabyteDB can be self-hosted and the database is Apache 2 licensed. I'm unaffiliated with the company, happy user.
- jgrahamc 3y agohttps://blog.cloudflare.com/announcing-workers-smart-placement/ https://blog.cloudflare.com/announcing-workers-smart-placeme...