Karel Van Der WaltData Architect at ACPAS Loan Management Software
Anonymous UserFull Stack Developer at a tech services company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The solution is very simple. It's easy to use. That's the most important feature."
"The solution is free to use, which is its most valuable aspect."
"The initial setup was pretty straightforward. I would have worked with our IT team in terms of the initial setup."
"Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."
"This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
"This product is a good teaching tool for students who want to learn about networked databases."
"This is a lightweight product that is not demanding on the resources, which is what I think gives it the edge."
"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"The database has excellent performance."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"The product is quite flexible."
"What I like is that it's quite powerful in terms of performance."
"The built-in code procedural language is the most valuable. It has a built-in layer for code procedures. Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"From a user perspective, the initial setup could be simplified a bit."
"I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"In terms of what I'd like to see in the next release, one thing that's always missing is dash boarding. There's no real BI tool for MySQL, like there is in Yellowfin and all the different tools that you get. They all have MySQL connectors, but there's no specific BI tool for MySQL. These open source projects have sprung up, but they're more general purpose."
"The documentation is pretty weak and should be improved."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"The user interface for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved."
"It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."
"The user interface could be a bit better."
"It could be improved by using parallelization. You want basically, distributed computing."
"The database and applications can become very slow."
"The pricing could be better."
"I had some issues when I integrated with the Jupyter Notebook."
"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."
"I am using the Community Edition, which is available free of charge."
"This is an open-source product that can be used free of charge."
"It's an open-source database management system that can be used free of charge."
"Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference."
"This product has a good price point."
"There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost."
"It has a community version."
"It is open-source."
"It is free. There is no license on it."
"It is also open-source so it is free."
"PostgreSQL is a free and open-source database."
"It is free, but if you need support, you can go for the commercial version called EnterpriseDB. They provide paid support, and they can even do hosting for you if you want standby and support."
"PostgreSQL is open-source, so if capable admins are available then the setup cost can be $0."
"It is open-source. If you use it on-premise, it is free. It also has enterprise or commercial versions. If you go for the cloud version, there will be a cost, but it is lower than Oracle or Microsoft."
"The solution requires a license."
Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.
MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.
PostgreSQL is a powerful and fully-featured database management system with which business owners can create object relational tables. It is an open source project that can be acquired for free and heavily focuses on elements such as extensibility and strict standard compliance. PostgreSQL is a flexible server system that can manage large workloads that are being contributed and accessed from a wide range of locations such as in a network, as well as small-scale projects like a single machine or user.
Some technical details of interest about PostgreSQL include:
MySQL is ranked 1st in Open Source Databases with 38 reviews while PostgreSQL is ranked 3rd in Open Source Databases with 17 reviews. MySQL is rated 7.8, while PostgreSQL is rated 8.0. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of PostgreSQL writes "Can be clustered which allows for fault tolerance". MySQL is most compared with Firebird SQL, Oracle Database, SAP HANA and IBM Db2 Database, whereas PostgreSQL is most compared with Firebird SQL, MariaDB, EDB Postgres Advanced Server, Percona Server and SQLite. See our MySQL vs. PostgreSQL report.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.