Is NeonDB a suitable option for geo-distributed database use cases, like YugabyteDB and CockroachDB?
Is NeonDB a suitable option for geo-distributed database use cases, where YugabyteDB and CockroachDB are commonly chosen, particularly for a B2B SaaS product with users across five continents? Can NeonDB handle latencies effectively in its current form, or are there any plans for improvements in future releases?
10 Replies
foreign-sapphireOP•15mo ago
I am new to NeonDB, can someone please help me on this query as I need to decide which database to use for our new Enterprise SaaS product development? Thanks
genetic-orange•15mo ago
neon has no cross region capabilities
foreign-sapphireOP•15mo ago
Okay, Thanks @Tristan Partin
Is this cross region capability feature on the roadmap to be implemented in the coming days? or that feature is not at all possible for Neon due to the Architectural decision?
genetic-orange•15mo ago
It's not possible on neon at the moment
Unless you logically replicate between 2 being projects in different region
foreign-sapphireOP•15mo ago
Thank you for the clarification
xenial-black•15mo ago
2 separate databases?
@Tristan Partin I get low ping in Europe with db in Frankfurt, but for the same db I get ~300-500ms+ from user in Asia. What should I do in this case? API is served via cloudflare workers.
firm-tan•14mo ago
I personally get 150-200ms delay from East Europe to database in Northern Virginia
xenial-black•14mo ago
I debugged and found the issue. On cloudflare workers, the first query is always the slowest, then the subsequent ones are super fast.. and the bad thing with cloudflare workers, is that you have to always establish a new db connection on every request => always high latency. Cloudflare Hyperdrive minimizes the initial query performance, but not always. The only solution is to use the neon serverless driver, which has no lag on first request (due to http nature of it), but you won't have db transactions support.
@Vlad I. so I decided to move to fly.io.
You're balkan as well brother?😁 Greek here xD
firm-tan•14mo ago
How fast is it? I currently use Prisma + Neon serverless driver
host my apps on fly.io too
I'm from Ukraine 🙂
xenial-black•14mo ago
Niicee, check PM pls 🙂