Over 278,861 professionals have used IT Central Station research.
Compare the best Open Source Databases vendors based on product reviews, ratings, and comparisons.
All reviews and ratings are from real users, validated by our triple authentication process.
The total ranking of a product, represented by the bar length, is based on a weighted aggregate score.
The score is calculated as follows: The product with the highest count in each area gets the highest available score.
(20 points for Reviews; 16 points for Views, Comparisons, and Followers.)
Every other product gets assigned points based on its total in proportion to the #1 product in
that area. For example, if a product has 80% of the number of reviews compared to the product
with the most reviews then the product's score for reviews would be 20% (weighting factor) *
80% = 16. For Average Rating, the maximum score is 32 points awarded linearly based on our
rating scale of 1-10. If a product has fewer than ten reviews, the point contribution
for Average Rating is reduced (one-third reduction in points for products with 5-9 reviews;
two-thirds reduction for products with fewer than five reviews). Reviews that are more than 24 months old,
as well as those written by resellers, are completely excluded from the ranking algorithm.
IT Central Station users agreed that functionality is of utmost importance to a quality Open Source Database (OSD). The specifications will change depending on the task you are trying to accomplish, but any Open Source Database needs to be solidly functional or there is nothing to work with. On an individual basis, scalability, metrics, and security are important features to look for. Users were clear that the efficiency of the medium which will connect the OSD with the application running it is also an essential component. Speed accuracy was also mentioned by a few members as one of the key features to consider when choosing an OSD.
Open Source Databases Reviews
Read reviews of Open Source Databases that are trending in the IT Central Station community:
Your trust is our top concern, so companies can't alter or remove reviews.
For this question I will focus on our usage of PostgreSQL in the company. A great differentiator for this database, if compared with other providers, is its easy extensibility and the existence of data types that would fall in the category of... more»
The company I work for creates economic time series and forecasting’s based on monthly surveys with companies. Besides a set of general questions, different sectors of economic activity include questions specific to their sector. This means... more»
v9.5, which we currently don't have in our productive systems, already has some key features that we would like to use. In particular, row level security, a feature allowing to restrict the visibility of rows based on a set of policies. A... more»
We design web solutions for customers with PHP. MySQL offers a simple, no frills, but effective DBMS solution with a very low hardware footprint. Since it has no licensing fees, it offers great TCO for our customers.
We do software development for our customers on both Windows and Linux. Since these tools are available for both Windows and Linux, we can leverage the knowledge of these tools for development on both platforms.
Only one of the engines, InnoDB, supports ACID transaction control. The best performance engine, MyISAM, has no transactional control support. It would make a lot of sense to include one engine that offers both very good overall performance... more»
ERP System Analyst at a tech services company with 501-1,000 employees
Jan 03 2018
What do you think of MySQL?
We could write books about MySQL and every book could have a different focus: setup, optimization, backup, etc. So, this review will be about sharing some of the experiences that I have had. So, MySQL is probably the most used RDBMS for web applications. The server is really easy to install, literally a straightforward installation. It is very fast and stable and at the same time not resource hungry compared to some other RDBMS products.
For smaller projects, you will not even need to do any "after install" tweaks or configurations, just install and you are ready to go. Nevertheless, for some more demanding projects, you will need to investigate and optimize your setup to fit the requirements.
What is the best configuration for a MySQL server? There is no single best...
Twice now, I have been involved in the decision by a company to migrate away from MS SQL Server to Postgres. The first time, it was simply a matter of scalability. Once you approach 10 TB of data, managing it in MSSQL becomes problematic. You... more»
One of the key ways that Postgres has improved the functioning of our organization is by freeing up financial resources that can then be applied to upgrading existing infrastructure. A side benefit, of course, is that by bringing in another... more»
I would really like to see a more mainstream approach to support what we see as critical extensions. One example is the FDW (foreign data wrapper) for MSSQL. This extension hasn’t been updated in several releases and would benefit from an... more»
* Open-source * Multi-platform * Lightweight * Simple to set up, configure and tune * Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature
It would be helpful if there were a graphical user interface to administer, configure, and tune it. If it had something similar to Microsoft’s DTS engine then it would be the best database system out there.
PostgreSQL provides the perfect combination of freedom, reliability, stability, security, performance, power, and ease of use. Freedom because it is the only world-class RDBMS not owned by a company. Reliability because anyone looking among... more»
The are many items in my wish list - parallel access. Of course, everybody needs to keep in mind that any wish list needs to point to the core features, because PostgreSQL is FOSS, and there are other ecosystems out there developing third... more»
I have never been in an environment where PostgreSQL was not used. It was always used alongside other RDBMS solutions, depending on the specific requirements of each project. In this way, we were always sure that we would get the best out of it.
There are still things missing compared to other RDBMS, for example monitoring is a little behind as there not that many solutions out there. An equivalent of Oracle's RAC and/or flashback logs would be nice to have. There are a lot of steps... more»
PostgreSQL does a great job with scalability and performance. Since we are using Django/Python – it works great with PostgreSQL as well. The current features that really help us are Full-Text Search, Array Fields, and JSON Fields.
By using PostgreSQL, it was easy to get all the developers configured and running. With using it as our back-end for data storage, our company isn’t worried about data loss or data integrity, especially with snapshots and WAL. Our company is... more»
The only thing I would really want/need to improve is pgAdmin3. pgAdmin3 is a nice tool for SQL Admin and Queries. But, I wish it would allow multiple queries to be run and displayed in the output pane. Also, it would be amazing if Full-Text... more»
MySQL is an Open Source RDBMS, which means you keep your costs low, as long as you don’t need to have support and/or you have your own MySQL expert. However, MySQL also offers the enterprise edition for users that would like support and more... more»
For any web project today you are going to need a database system. If you use any Content Management System, MySQL is most of the times the database of your choice. MySQL is easy to use, most developers have experience using it and it is an... more»
Although MySQL should cover most of the needs of an average user, there are constrains that need improvement. For example, MySQL doesn’t support check constraints. MySQL’s performance is not optimal on subqueries and can significantly... more»
Before we used MySQL, we used to access the data used for the dynamic web pages directly from our enterprise data stores and that was a massive performance bottleneck. With MySQL, the data can be accessed much faster. This allowed us to... more»
From where we are, most of the improvements are being handled. With the new improvements that were introduced in MySQL 5.7 and with the testing that we have done to this point, we are looking at updating our web development environment to... more»
PostgreSQL is an open source database, so there is no associated licensing cost for the software and we always have a new version easily available. It runs on all major operating systems, although I have always used it on UNIX platforms. It... more»
I have worked at the Ministry of Economy in the IT area, for more than 20 years ago. Since then, the main developments have always used PostgreSQL for their robustness, reliability, stability, and conformity with the standard SQL.
* Replication which enables us to use it for High Availability. * The Foreign Data Wrapper means we can integrate it, and provide interoperability with other databases. * Multi-master Replication helps us to distribute a database... more»
Before using PostgreSQL, we had a database issue that we were trying to solve with Oracle. However, Oracle is quite expensive and I heard from a colleague that Oracle increases their charges year on year.
There are many places that it could be improved through the provision of more plug-ins and extensions, such as data distribution, load balancing, new data types, indexing and searching, etc. They could also make it easier to access data... more»
PostgreSQL is probably the most SQL-standard-compliant RDBMS on the market. It also goes way beyond standard relational paradigm combining key-value stores, arrays, and columnar stores into a single engine. With the introduction of Foreign... more»
Logical replication would be a major improvement and it's already being worked on. It'll enable true multi-master replication and active-active setups. More OLAP-related performance improvements are also on the way with parallel query... more»
The development team has been teasing me with talk of multi-master capability for some time. Their latest release, 9.5.3, does offer some asynchronous capability, but I really want synchronous multi-mastering as that would allow horizontal... more»
MySQL’s strength is in its fast connection, query and insert performance. I’ve benchmarked MySQL against several NoSQL and SQL databases and found it to be faster for getting lots of data inserted quickly.
The weakest link is replication. MySQL’s replication is touchy and doesn’t support master-to-master setups. MySQL’s replication was implemented by playing back SQL statements getting executed on the master database node. That means if a slave... more»
We used MySQL for many tasks, because there were simply more documentation available, but while using it, we found many serious weaknesses with it like no data validation even for string length, no transactions, etc. PostgreSQL catches a lot... more»
I'm a data consultant that specializes in PostgreSQL. The combination of it's open community, open source approach and it's unique features make it the perfect platform for solving today's sophisticated data challenges.
Extensibility could be even better as there are still too many things that require programming in C to add to the database. There could also be better object-oriented support. The table inheritance feature is critical to some of my work, and... more»
Back in the day, MySQL had storage problems with InnoDB (everything in a single file), and we wanted ACID compliance. So we decided to use PostgreSQL for that, and it helped us achieve that goal. PostgreSQL's feature set was excellent for our... more»
There's always room for improvement. Better SELECT performance is something that PostgreSQL could really benefit from. Replication should also be made easier. PostgreSQL also lacks a good tool like MySQL Workbench. PgAdmin3 works, but it's... more»
The most important features would be querying, the query language where you have the data definition or data modification language, as well. In some cases, we have to create our own tables for testing purposes. In that case, having SQL Server... more»
To give you an example, initially we didn't have a database server as such, and we had to make use of some database. Now we use something where we can share the instances of the database which were created virtually, which is a very good... more»
Using MySQL helps to keep the costs down. With immense material available on the web, training is easy too. This is the de facto DB for web development with PHP. If you worked with LAMP environment, this was the M in it. With open source... more»
Dr Ioannis Syrigos is a Computer and Electrical Engineer, an Entrepreneur, co-owner and Managing Director of Stella Novus LTD, an IT consulting company running several individual online projects (Ancient-Origins.net, Members.Ancient-Origins.net, Evolving-Science.com, EnglishWithJo.com and... more>>
Technically astute, self motivated, highly organized, process&detail focused, results driven and hands-on Physics Ph.D. with excellent research, critical thinking, problem solving, cross-functional team support, and oral & written communication skills. Definitive strengths include the... more>>
Systems Engineer with experience in the areas of Development, Banking, Health, eCommerce and Custom Development, with an attitude of service, leadership and great relationships. Management personnel, resources, monitoring schedules and budgets, knowledge in CMMI and PSP. Ease of expression and... more>>
Expertise in designing & developing solutions in Greenplum which is a distributed and massively parallel processing (MPP) database engine.
Expertise in performance tuning Greenplum design for extracting best performance leveraging MPP capabilities.
Expertise in data modelling (Conceptual,... more>>
Software Architect and Senior Technology Consultant
Soy un profesional con amplia experiencia en el rubro de Tecnologías de la Información. Empresario, emprendedor, investigador, consultor y asesor especializado. Tengo experiencia gestionando equipos de proyectos multidisciplinarios y procesos de mejora continua en empresas. He liderado proyectos... more>>
Working with Business Intelligence since 2009.
Always learning new concepts and studying new ideas to offer better services to my customers.
Expertise in Open Source B.I. Solutions (Pentaho).
Attended the course Dimensional Modelling in Depth with Ralph Kimball (Stockholm - Sweden).
It's awesome that you've decided to take the time to view my profile! Thank you!
So you'd like to know more about me?
I'm a senior GNU/Linux systems administrator and PostgreSQL DBA.
Most of my skills are now called "DevOps" but I have a pretty distinctive view on this hype, you can learn... more>>
As an IT professional, with over twelve year’s of experience, I have specialised my skills in the area of relational database management and IT Management. As CIO and Sybase , Oracle and MS-SQL Server DBA (Database Administrator). I have worked on a number of projects, mainly focused in the... more>>