What is your database of choice?

At the moment my preference is mongoDB however I am trying to get back up to speed with SQL so I can use PostgreSQL as well.

Comments

[Din]

MongoDB of course, I was very hesitant to start using it but man did it pay off...

[Eduardo Wronscki]

PostgreSQL

[Mohammad Mostajeran]

Postgres

[Evaldas Buinauskas]

My rule of thumb is start with any modern relationshal database such as SQL Server, PostgreSQL, MySQL and use NoSQL only when product needs very specific problem to be solved and database is designed for that specific use case

[Rhamses]

MongoDB on side projects and Neo4j at work, but I’m looking to learn Postgree as well, many projects that I have interest to contribute with use it alongside python (which I need to practice more as well)

[Andrew Baisden]

Python and SQL thats the stack I am trying to learn right now. It seems to be very good for job prospects.

[Rhamses]

That seems to be the choice to get into Data science and B.I stuff. I hope I start studying this soon

[Rémy 🤖]

PostgreSQL is my choice because

• It is well supported by the Django ORM (and the Django ORM is fantastic, especially migrations-wise)
• It is ACID and conceptually correct
• It has all the features I ever needed (full text search, fuzzy matching, constraints, materialized views, ...)
• It is very widespread in managed database services (DigitalOcean, AWS, GCP, etc)
• Despite what the Uber monkeys think, it scales
• It has plenty of convenient types (arrays, hash maps, JSON) that let you be very flexible with how you represent your data (even get the flexibility of NoSQL when you need it)
• And of course you can index and query those types (yes you can make an indexed query deep into a JSON field)

[Andrew Baisden]

All good reasons I can see why its so popular now looking at all of these responses.

[Yann Barraud]

Mongo is overrated AFAIC. PosgreSQL & ArangoDb,which is underrated... 😃

[Garret]

DynamoDB is by far my favorite. I do not really have a need for SQL in most of the stuff I do because I do not care for analytical data.

Dynamo being serverless which means I only pay for what I use and it scales basically infinitely is just the best thing in the world too. I will admit it's hard to learn but once you know how to use it, it is super super powerful.

[Yuan Gao]

Postgres is my RDB of choice, but if the situation demands it. mongo for noSQL, Redis for in-mem data and pub/sub, elasticsearch for full-text search. These are the four I use most often

[Tom Lienard]

I use MySQL/MariaDB for small websites, but I prefer MongoDB for larger ones and for Java applications. I often use Redis to cache data too