Ask HN: What web database should a newbie learn first? It seems the field of databases is constantly changing. As such, what would you recommend someone just getting into website coding and applications should study as their first database, and why? Are there any databases a beginner should avoid for a while? Any on the downswing so heavily that maybe they should not be bothered with at all? |
It does a lot of things right, it's open-source, and it's mainstream enough that there's plenty of learning material online and plenty of job opportunities if that's a concern.
When you have something specific in mind there are databases optimised for specific applications, but you can always fake it with MySQL for till you are ready.
This is old, boring tech but works fine and will scale up without issues for the workloads you mentioned. IIRC even stackoverflow.com is powered by a SQL db.
For a beginner, learning this will offer most value.
For more scalability, you have to enter nosql territory. Typically you add caches in front of your db to speed things up. These are not tables, but key-value stores. Redis and memcached are quite popular.
When you need even more, you can use nosql databases. Normally you would just use what your cloud provider offers, unless you have a team who can administer your own. However, it’s important to understand that they don’t offer more functionality than SQL dbs, but less: features are often sacrificed for the sake of performance, at the expense of increasing complexity as well.
So in my opinion, just learn SQL first, and anything else if needed.
The managed instances by cloud vendors (microsoft azure, google cloud platform, amazon web services, digitalocean) should also help you getting up and running without worrying about the infra side of things on small scale projects
Bit outdated but comparisons
When I need scale, I switch to managed solution offered by one of the hyperclouds.
Free tier. Schemaless. Frees you up to focus on your app. Infinitely scalable. And you can train sophisticated models with AutoML. Best of Luck ;)