Ask HN: What database (and database hosting) to use for small projects?

#1

Post by reeeeee » Sat, Sep 25, 2021, 12:11 PM UTC

I just started on a project that will probably have no more than 100 customers, keeping track of basic accounting tasks. I'm now thinking about which database service I will use. Looking at the prices of AWS databases, it will cost me $30 per month just to host the smallest RDS instance in the region of my choice.

When starting out on smaller projects that are hosted in the cloud, which database and database hosting/provider do you use? What service do you think offers the best price to quality ratio?

Re: Ask HN: What database (and database hosting) to use for small projects?

#2

Post by aaronrobinson » Sat, Sep 25, 2021, 12:14 PM UTC

You can run a Linode or Digital Ocean droplet for $5 a month all in. Then just run the DB yourself.

Re: Ask HN: What database (and database hosting) to use for small projects?

#3

Post by verdverm » Sat, Sep 25, 2021, 4:19 PM UTC

I prefer Google Cloud, it is more expensive than Linode or DO, cheaper and easier than AWS.

You can use a fully managed Postgres for $30, maybe less. They charge based on the VM size.

Postgres is always a solid choice.

Re: Ask HN: What database (and database hosting) to use for small projects?

#4

Post by JasonCannon » Sat, Sep 25, 2021, 4:52 PM UTC

SQLite will almost certainly work for your purposes, and you can run it on the same server you already run your web application on.

Re: Ask HN: What database (and database hosting) to use for small projects?

#5

Post by FdezRomero » Sat, Sep 25, 2021, 7:56 PM UTC

MongoDB Atlas offers a fully managed M0 instance with 512MB of storage and shared RAM for free. You can choose among AWS, GCP or Azure and the region. I use this or the Firebase Firestore free tier.

Re: Ask HN: What database (and database hosting) to use for small projects?

#6

Post by Something1234 » Sun, Sep 26, 2021, 5:47 AM UTC

JasonCannon wrote: post #4

SQLite will almost certainly work for your purposes, and you can run it on the same server you already run your web application on.

I've been wondering if it's a terrible idea to run a SQLite database on an efs (the amazon hosted nfs solution) volume. I think it would work but I'm not sure.

Re: Ask HN: What database (and database hosting) to use for small projects?

#7

Post by reeeeee » Sun, Sep 26, 2021, 2:12 PM UTC

JasonCannon wrote: post #4

SQLite will almost certainly work for your purposes, and you can run it on the same server you already run your web application on.

SQLite is a solid solution, can't believe I didn't think of it. Thanks!

Re: Ask HN: What database (and database hosting) to use for small projects?

#8

Post by JasonCannon » Mon, Sep 27, 2021, 5:29 PM UTC

Something1234 wrote: post #6

JasonCannon wrote: post #4

SQLite will almost certainly work for your purposes, and you can run it on the same server you already run your web application on.

I've been wondering if it's a terrible idea to run a SQLite database on an efs (the amazon hosted nfs solution) volume. I think it would work but I'm not sure.

Quick google-fu suggests that yes, that is a terrible idea.

https://sqlite.org/forum/info/8e84712c9d8b79e7