Over 258,953 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»
PostgreSQL, especially the latest versions, comes with a very rich set of server side programming tools, while providing speed, data consistency and the transaction's coherence. This is a very wide answer, but this large environment is... more»
I have a quick example about how it reduced the amount of backend code and also improved the application's performance. When you are in a scenario where your application has an input, and based on that, you have to do several back and forth... more»
Starting with v9 it can be seen an intensive activity to bring more features, more performance or productivity. I would like to see it be more reliable, and easier if possible, to make PostgreSQL clusters - more machines working together as 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»
Most of the enterprise I have worked has been startups and small to medium software industry and data analysis. One of the most improvement it is not in the mean time but in the middle to long time. At first sight it seems to an overkill... more»
I think that data types that decrease the breach against NoSql Databases will be the next steps. I am not talking about changing to a pure NoSql DB but to some features that will face the big change in data analysis and maintenance that that... more»
PostgreSQL is the only open source and multi-functional database solution out in the market today. I have used it to replace Oracle (RDBMS) up to MongoDB (Document DB). Postgres has very rich SQL and NoSQL features that gives it a special... more»
PostgreSQL is the most flexible database I have worked in my career. For example, when I need geographical data processing for my application, I can use PostGIS. It is the best GIS solution out in the market, by installing extension the... more»
PostgreSQL has introduced number of new features to achieve out of the box multi-master replication and reach JSONB features, horizontal and vertical scalability and parallelization features. I’d like to see them to be production ready. As... 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»
Many supported features out of box like fulltext search, partitioning, easy replication - slony, pgpool-II and streaming wal and additional features such as JSON, XML, arrays in columns, and many extensions for it as PostGIS.
I'm working as architect for a custom software development company and we are using Microsoft SQL Server, Oracle DB and PostgreSQL as our main databases, in recent years Postgre is offering more and more useful features which we can use. For... more»
The biggest issue that we are having is upgrading and moving databases between servers and versions. Restoring database is slow with pg_restore because indexes are need to be rebuilt. What I'm missing is a query profiler similar to what is in... 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»
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>>
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>>
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>>
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>>