Hey everyone! I'm currently building apps on Vercel and I really appreciate how they effectively distribute my frontend globally. However, I'm facing some challenges with database latency for users who are located far from my primary database region. I'm on the hunt for databases that can offer global distribution 'on the edge'—meaning that they can automatically replicate or cache data geographically. This way, users can access a database instance that's closest to them, much like how Vercel takes care of my static assets and functions. Specifically, I'm looking for:
* Global distribution with minimal latency
* Compatibility with Vercel's serverless functions
* Automatic handling of replication/synchronization
* Open to both SQL and NoSQL options
I've thought about a few options like PlanetScale (which has some edge capabilities but I'm uncertain about its full potential), Upstash Redis (great for caching but also need persistent storage), and Supabase (awesome, but it appears to be single-region).
Has anyone tackled this issue? Are there any databases that genuinely provide global distribution and automatically direct queries to the nearest region? I'd also love to hear if you've used any in production with Vercel. Thanks for your help!
1 Answer
You might want to look into Cloudflare D1. It's a solid option, but it really works best if you're also running your functions on Cloudflare rather than Vercel.
I looked into D1 and R1 too, but I heard they're mainly for use with Cloudflare Workers. Is that right?