Database for multiregional projects
Hello, I'd like to ask what the best practices are for databases serving users in multiple regions. In my case, majority of my users will be coming from either USA or Sweden (Europe). So ideally, I'd like to spin up one database in USA and one in Europe and have users connected to the one with the best latency for them.
But I'm a bit unsure whether this is really possible in any good way, without it being very "hacky".
Currently using: nextjs, payloadcms, vercel, neondb.
I'd assume majority of the heavy lifting would have to be done by my own backend/some sort of a middleware, as neon doesnt seem to be offering such services built in, yeah?
Would love to hear your takes or tips if you've dealt with something similar.
But I'm a bit unsure whether this is really possible in any good way, without it being very "hacky".
Currently using: nextjs, payloadcms, vercel, neondb.
I'd assume majority of the heavy lifting would have to be done by my own backend/some sort of a middleware, as neon doesnt seem to be offering such services built in, yeah?
Would love to hear your takes or tips if you've dealt with something similar.
