Developers - What's your database solution for spinning up new projects?
Hey folks! First time posting and excited to be here.
I'm wondering what y'all use as database solutions for spinning up new projects. I'm using Supabase for a few things on their free tier, but I've hit my cap for new projects on the free tier. I have a few new projects I want to start, but don't know what to do about the database. I'm trying to remain on the free tier of these managed db services.
Options I see -
- Start a new ProofOfConcept Supabase DB project with a different email and throw a bunch of different project tables in it, and move to a more mature solution if and when any individual project pops off.
- Create a new email address for each project and create a new account with each email. Set up a spreadsheet of all my accounts and their emails.
- Identify a bunch of different managed Db solutions with free tier, as I know there are a lot - Vercel, Render, etc - and spin up one account per service for each different project.
I'd love to hear what y'all do to spin up new ideas and not get stuck in this db service anaysis paralysis! Thanks.
I am using PostgreSQL on render.com but I am always upgrading to the lowest paid tier immediately. I think if your product have found product-market fit you should be able to find customers that pay you and then you should be able to pay for the database. Even paying the paid plan for supabase like two months is acceptable.
That's legit. "I need to charge enough to pay for my managed db subscription" is both an incredibly attainable goal and a good incentive to actually charge for my work!
I tried Neon as it was part of the Nextjs template I choose but I find it not as easy to use as Supabase.
I love supabase but the 2 project limit is indeed very limiting, i was thinking about maybe hosting an instance of supabase myself with a raspberry pi.
That's a cool idea. With a self hosted Supabase, do you still get the UI (on your local server) or is the only benefit the client side hooks?
for hobby d1 from cloudflare its in alpha but for hobby projects it is ok. For commercial projects postgres either local or by some provider.
SQLite is the new hotness these days.
I built PagePundit an AI-powered book recommendation service using DynamoDB by AWS. Its a noSQL database with a great free tier. Admittedly AWS can be a little intimidating when first learning...
Alternatively if you are looking just for a proof of concept I don't see anything wrong with dumping some JSON data in an S3 bucket. You'd have to implement your own update logic and reads will be slower, but it will do the job.
Since I use heroku for all my projects, I'm using the postgresql add-on to give you a managed postgresql database for $5 a month. Decent choice I think if your app is on heroku.
I am using AWS RDS with PostgreSQL for https://worldofthis.com.
Highly recommend https://planetscale.com/