When it comes to relational databases, I've mainly worked with just MySQL and a bit of PostgreSQL.
Some of the most popular alternatives include Oracle, MariaDB, SQLite, ElevateDB and lots of others.
What is your preferred choice when it comes to relational databases and why would you recommend it?
Discussion (17)
Microsoft SQL because of tooling and documentation. I like also PostgreSQL with its additional NoSQL features.
PostgreSQL is so feature rich
Always an interesting discussion topic!
Postgresql
MSSQL
I'm a TSQL fan (Microsoft). They provide free of charge the Microsoft SQL Express product. More than enough for a small buisness.
MySQL, for me maybe just because I grew up with it.
But it works, easy to understand and I know the queries from the top of my head.
MSSQL was allways one of the few MS products I really respected, especially it's tooling. However, lately it's Postgres.
MySQL, it was my first experience.
MSSQL because of customer support. lol. For OSS projects, postgreSQL.
looking forward for the
developers 10 favorit RDBMS
article 😉I like CouchDB. Since Version 2.0 I think we can also consider it a relational DB.
Postgres, MSSQL took too much memory from my server.
PostgreSQL is my DB of choice if it comes to relational DB with the main reason being that it's so feature rich.
SQLite for local development and ease of use.
PostgreSQL, MariaDB and SQLite, in order of use and preference
They all just work, no weird problems
MySQL
Microsoft SQL Server when it comes to Banks and Telecom in Toronto, good tools and documentation, and supported by Microsoft, you can always get someone from Microsoft to look at the server instance and figure out which new changed messed up the system :)
Anything else for startup and small projects, usually MySQL because of popularity, but it looks like it is deteriorating in quality (the installer not the db) so I am starting to worry that it will affect the overall quality of the none paid (free) version of MySQL
None of the above databases or any on the market are ideal, they waste everyone's time, but that is what is currently out there.