Hey I’m starting to work on a private project right now and since I don’t know a lot about databases I wanted to ask for some help/ideas/suggestions.
Here are my requirements:
- not self-hosted
- preferably free for open source (if non existent then free to a certain amount of data)
- scaleable as the data will probably grow quickly.
- searchable (I know all are but some are faster at it I heared)
- support for sequelize (or if anyone has better alternatives for that feel free to share them 👍)
Thanks in advance
Top comments (8)
I assume you're looking for an SQL database:
Your best choice would be Supabase (dev.to/supabase, supabase.io/). It's free to use while it is in beta. Will charge in the future.
I don't know of any more hosted SQL databases, but you can try No-SQL ones:
Thanks for the quick response.
I’ll check out supabase although it sounds like a trap 😅.
I did use fire base in the past and it’s neat but not necessarily the best choice for open source I think.
How exactly do you want to use it? Because if you deploy on Heroku, you can use its free hosted Postgres solution as well. And regarding Supabase, you can discuss with @awalias
Decentralised app (obviously) running on nativescript and accessing the db via a rest api or “integrated” Api. I didn’t think everything fully through yet. Still planning. But I’m one of those “make it run make it pretty” guys
Hey Syed, thanks for the mention! We just announced our pricing (supabase.io/pricing) yesterday. We will keep our free tier for dev, hobby projects, and students. And since we're open source (github.com/supabase/supabase) and just vanilla postgres under the hood, you can self host or transfer your data out whenever you want.
❤ Love open source SQL database 👉github.com/supabase/supabase 🚀 support our developers 💪
Both MongoDB Atlas, and MongoDB do have built-in search, but not as convenient as PostgreSQL or MySQL.
But, how many rows or database size do you need?
I know you can find both MongoDB and PostgreSQL hosted on AWS for free, by Qovery, somewhere on DEV.to; and hopefully, you can negotiate, if it gets larger.
The last thing is domain names might not be free.
Nhost (nhost.io) might be a good option for you. It's an open source firebase alternative with GraphQL.
It uses PostgreSQL and instantly generates a GraphQL API based on your database.