I'm building a small booking app and looking for an affordable, reliable PostgreSQL database for production.
Expected usage:
• 400–500 DAU
• 15–20 concurrent users at peak times (or maybe less)
• Around 30 rooms
• Room availability checks, bookings, orders, and purchases
• An admin dashboard
I'm considering AWS RDS but am open to other platforms as well.
My questions:
I'll handle the API separately using either a Next.js backend on Netlify or AWS Lambda, so I'm only interested in database hosting costs.
Would appreciate recommendations based on real world production experience.
Artensonart98 is seeking advice on affordable and reliable PostgreSQL hosting for a small booking app with specific usage metrics. They are considering AWS RDS, Neon, and Supabase, and are looking for recommendations based on cost, reliability, backups, and maintenance. The user plans to handle the API separately and is focused on database hosting costs.
Just get one VPS server closer to the target region and use it for both for the main app and to run a PostgreSQL server...
for 400–500 dau, i'd go with neon launch or supabase pro ($25/month). neon is cheaper for low usage, while supabase gives you daily backups and easier management. aws rds feels like overkill at this stage. just make sure you use connection pooling and database transactions to prevent double bookings. btw, are you expecting traffic throughout the day or mostly during peak hours??