Alain AinaOwner at TRS
Jason TumusiimeSoftware Developer at a healthcare company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The solution is very stable. It was originally built under MySQL. It has a similar level of stability."
"This solution is user-friendly."
"The most valuable feature of MariaDB is the replication mode."
"I would say that for most use cases it works fine."
"The performance is very good."
"MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL."
"From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL."
"What I like best about MariaDB is that it is open-source and reliable."
"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 interface should be more user-friendly. It should be able to connect directly to the database and Interact with it without having to use commands. It needs better integration."
"In the next release, I would like to see improvements in the scalability and redundancy features."
"Maria DB has to improve from a management perspective."
"It's not very stable. It needs improvement."
"It would be helpful if I could specify multiple drives for the database storage."
"I would like to see more compatibility going forward. This would help if there is a need to change databases."
"The scaling for database online transactions needs improvement."
"Master-master replication is something that needs to be simplified."
"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."
"The price of this solution represents a very good compromise between the cost and what it offers."
"It's an open-source solution."
"The licensing cost is approximately $4000.00 per year and the licensing is based on the software and the number of posts that you make."
"I used the open-source version, which is available free of charge."
"This is an open-source product, which can be used free of charge."
"This is an open source solution with no licensing fees."
"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."
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:
MariaDB is ranked 2nd in Open Source Databases with 14 reviews while PostgreSQL is ranked 3rd in Open Source Databases with 16 reviews. MariaDB is rated 8.0, while PostgreSQL is rated 8.0. The top reviewer of MariaDB writes "Provides great database for systems monitoring data and performance stability". On the other hand, the top reviewer of PostgreSQL writes "Can be clustered which allows for fault tolerance". MariaDB is most compared with SQL Server, Oracle Database, CockroachDB, Amazon Aurora and Percona Server, whereas PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, Percona Server, MySQL and SQLite. See our MariaDB 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.