Databases are something I always wanted to explore more and get better at. Thus the question, what DBs would you recommend learning for 2021? Which ones do you see holding future potential?
As of now, I like PostgreSQL for relational and MongoDB for all the non-relational stuff. Both seem to be solid for their purposes.
Latest comments (32)
I think MySQL is still very much relevant and not leaving any time soon but other available DB is also a good try.
Also, the nature of your project can influence the DB to use in some cases.
Check out HarperDB! We strive to combine the best of both relational and non-relational worlds into a single database solution. It's simple and easy to use, all operations are executed through a single API endpoint, so you can focus on your application instead of database administration.
I think is not about learning because of what has potential or is trending.
It depends on what type of data you are going to store!
Is it a graph-like structure with millions of nodes? consider neo4j
is it relational data types? Postgres seems fine
Do you need Geospatial, maps querying? try PostGIS
...
Edit:
Sergey Podgornyy shared an interesting video about this.
RDBMS is still enough for most of the application. Adding to that, one thing that interesting to me is the NewSQL, to name a few, TiDB and CockroachDB. It is like RDBMS with NoSQL scalability.
Here is my hot-take, rather than what to master, what not to even bother with. That's MongoDB. There is no use case for that DB that can't be quickly replaced by a good DB such as Postgres.
My suggestion is:
Searching: Elastic Search
Graphos: Neo4J
Cache: Redis
Clouds Data bases: SQL Azure, Cosmos DB, Dynamo DB
Documentals: MongoDb, Firebase
Relationals: SQL Server, Postgress, Oracle, Whatever is good
That's a great list, thanks 🙏❤
As for CMS / existing software, MySQL seems promising.
But having broader perspectives and choices would be interesting as well.
In the end, I think it depends on how much you get to choose...
HarperDB
what he said
There's quite a few companies using Elasticsearch nowadays. It could be worthwhile to also learn a bit about natural language processing (if you're interested in search).
SingleStore! (Formerly known as MemSQL)
singlestore.com
And then Redis, DUH!
redis.io