Ask HN: What's the most affordable and efficient DB for a newbie?
building a web app (ntwrk.site) that allows users to store contacts. Not sure what DB to use. I'm heavily considering Mongo or Supabase.
Affordable in what sense precisely? There are open source and free options everywhere. Or do you mean "affordable with a certain level of traffic?" as in a hosted solution?
Efficient in what sense precisely? All databases are efficient but not magically so. You'll need to read the documentation and learn about indexing and the specific write/read characteristics of your choice.
With where it seems are you currently, I don't actually think those things matter. I'd say ease of use - sqlite has everything beat hands down, but I also wouldn't actually suggest it for a production system if you're hoping to have a bit of traffic.
* Postgres is good
* Mariadb is good
* Mongodb is good
Personally I'd choose Postgres, but I see the advantages of Mongodb when you don't know exactly what you're schema will be. It makes it really easy, almost too easy. Now that's a double-edged sword. I've seen people create major problems for themselves by having variously data-shaped records in their db as they're figuring out their data models but I've seen the same exact thing in Postgres as well (bad schema design).
Whatever you choose, good luck though!
IMHO, pre-built/ready made content relation management tool (crm) would seem to match what's been stated.
For just straight up dumping contacts in a table without considering data/security issues:
a) https://www.postgresql.org/about/news/announcing-sqlpage-build-dynamic-web-applications-in-sql-2672/
b) https://execsql.readthedocs.io/en/latest/
c) https://www.gnu.org/software/recutils/manual/html_node/index.html
tutorial : https://gist.github.com/gmolveau/6be062d9b9005cf985cda98dabdf0baa
https://www.youtube.com/watch?app=desktop&v=A1whwi-Gc0Y
Misc postgres gui tools : https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
If you are using GCP or AWS, take a look at Firestore and Dynamo. They are fully managed (no maintenance for you), reliable, fast, cheap, scalable, and easy to use. Despite being designed for heavy-duty usage, they work perfectly as a simple key-value store.
I use Firestore for all my personal projects, and I only pay a couple dollars per month.
The post isn't about Supabase, but PostgreSQL (the database Supabase uses) and MongoDB. The conversation there may help you make your decision.