Database for open source?

Publish Date: Mar 27 '21

3 8

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

Comments 8 total

Syed Faraaz AhmadMar 27, 2021
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:
- Firebase (firebase.google.com/)
- MongoDB Atlas (mongodb.com/cloud/atlas)
- zer0Mar 27, 2021
  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.
  - Syed Faraaz AhmadMar 27, 2021
    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
    - zer0Mar 27, 2021
      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
      - awaliasMar 30, 2021
        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.
        
        BeastByte-prgApr 19, 2021
        ❤ Love open source SQL database 👉github.com/supabase/supabase 🚀 support our developers 💪
Pacharapol WithayasakpuntMar 27, 2021
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.
Johan EliassonApr 20, 2021
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.

Add comment

zer0 @zer0

Database for open source?

Comments 8 total