What is the best scalable Database to integrate with my Next Website?
Unanswered
Satin Angora posted this in #help-forum
Satin AngoraOP
Planning on deploying a commercial website, the number of users could eventually grow into the thousands or larger. Instead of switching database platforms midway i’d like to stick with a secure, reliable, scalable, cheap, easy to integrate with nextjs database. What database platforms would you guys recommend?
15 Replies
cheap and reliable doesn't fit in same sentence
though I use postgres for everything but if I knew that my project will get many users, I would choose planetscale
@Yi Lon Ma cheap and reliable doesn't fit in same sentence
Satin AngoraOP
Lol reasonably priced then, so do you use supabase since its built on postgres, then prisma to interact with the database in the api routes?
supabase has been highly unreliable when I used it
random disconnections, very high latency etc
Satin AngoraOP
And isnt postgres scalable so it could cater to many users?
if I use postgres, I mostly self host it but if this was a serious project, I would use a managed service
I won't trust neon or prisma postgres as they're still very new
I would use Digital ocean's managed service or AWS RDS
@Yi Lon Ma I would use Digital ocean's managed service or AWS RDS
Satin AngoraOP
Oh gotcha, yeah mines serious. So you’d recommend for me planetscale, digital oceans managed service and aws rds is that correct?
yes
Satin AngoraOP
Awesome thanks man i’ll do some research into those
but you are free to checkout other services and choose which one fits you best based on price and everything
Satin AngoraOP
Yeah i’ll have to weigh the pros and cons of each but the suggestions are very helpful
If anyone else has any recommendations feel free to send em through