Re:EdgeNode: Deploy Serverless Containers on Edge
by rad_gruchalski on Monday July 10, 2023 @06:43PM
(#36674018)
Have 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.
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.