4 ms·
Most companies usually use more than one. At my current job we use PostgreSQL and MySQL in production, and H2 in development. At my previous job we used Sybase
by martinp 14y ago
Most companies usually use more than one.
At my current job we use PostgreSQL and MySQL in production, and H2 in development. At my previous job we used Sybase SQL Anywhere (horrible, wouldn't recommend it), Microsoft SQL server, MySQL, Amazon RDS and H2.
- bdcravens 14y agoWhat databases do you use in RDS? RDS isn't a database, it's hosted MySQL, SQL Server, or Oracle.
- martinp 14y agoSorry, forgot to specify which one. It was MySQL if I remember correctly.
- pimentel 14y agoI don't have the best knowledge on DBs, but why would you use more than one of the same "tech"/paradigm? Why postgreSQL and MySQL? Don't they work similarly? Or is it because you use postgreSQL for the things it is better than MySQL, and vice-versa?
- martinp 14y agoIn my experience the database usually gets evaluated on a per-project basis. It's a good way to determine the strengths and weaknesses of each. Currently we use PostgreSQL for all new projects, but we have a few legacy projects still using MySQL that we haven't bothered migrating. Additionally, most developers find it a hassle if they have to configure a fullblown database just to do development on a given project. That's why we use H2 (in-memory database) for development.
- deleted 14y ago[deleted]