#Postgresql vs mysql license#
#Postgresql vs mysql windows#

It seems a bit too much to get one license for one enterprise manager. Currently, you need one license per server. In addition, the enterprise manager should be able to cater to more than one virtual machine. 'There should be more tools to manage the on-premises version and more automation features.' 'MySQL could be improved by adding more automation.' 'The documentation is pretty weak and should be improved.' 'It can have better monitoring. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person.' Instead of having several tables or several relations for one entity, I can adapt this entity. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution.' 'It is very simple to manage.' 'The product is very similar to the SQL Server.' 'PostgreSQL makes it very adaptable to several descriptions of a record. So, there is a big push to go to Postgres.' 'This is an open-source solution, operates at a high speed, and supports more than one SQL language.' 'We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance.' 'The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. Our organization has the initiative to go to open source to cut down on cost. 'What I like is that it's quite powerful in terms of performance.' 'The main value is that it is open source, which means it is free. It's easy to develop, easy to maintain, and easy to back up and restore.' 'It was easy to install.' 'I like the JSON stuff.' 'The easy access to the data and the ability to sort the data with multiple methods are very valuable features.' 'MySQL's clustering features are very strong, and you can automate scripting, so that helps. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance.' 'MySQL is a light database.

With MySQL, you get what you need without any overbloating, for which Microsoft is known.

MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system.

#Postgresql vs mysql windows#

The backups on a Linux machine can be restored on a Windows machine, and vice versa.' 'I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered. 'The solution is very stable.' 'MySQL has cross-platform support for multiple operating systems.