Chart Key
Average Rating
Average rating based on reviews
Views
Number of total page views
Comparisons
Number of times compared to another product
Reviews
Total number of reviews on IT Central Station
Followers
Number of followers on IT Central Station
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.
Most Views
From IT Central Station visitors
Most Reviews
Within the last 24 months
Most Followed
By IT Central Station users
Most Compared
From IT Central Station visitors

What is Open Source Databases?

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.
PostgreSQL
Real User
Senior DB Engineer at a university with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Oracle
Real User
Software Architect at a tech consulting company with 51-200 employees
Dec 19 2017

What is most valuable?

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.

How has it helped my organization?

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.

What needs improvement?

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»

Have A Question About Open Source Databases?

Our experts can help. 278,861 professionals have used our research on 6,302 solutions.
Oracle
Real User
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...
PostgreSQL
Real User
Sr. Database Engineer at a non-tech company with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Oracle
Real User
Senior Web Manager at a university with 501-1,000 employees
Feb 04 2018

What is most valuable?

* 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

How has it helped my organization?

Due to the open source licensing model, it has allowed small businesses like ours to adopt enterprise-grade database systems without incurring significant licensing costs.

What needs improvement?

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
Consultant
Partner - PostgreSQL support manager at a tech company with 51-200 employees
Jul 25 2016

What is most valuable?

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»

How has it helped my organization?

We have migrated some databases from Oracle to PostgreSQL lowering licensing fees and reducing the vendor lock-in, gaining sovereignty.

What needs improvement?

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»
PostgreSQL
Real User
Senior Database Engineer at a Consumer Goods with 1,001-5,000 employees
Oct 26 2016

What is most valuable?

The reliability, performance, and extensive list of features are what I think matter the most in a production environment.

How has it helped my organization?

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.

What needs improvement?

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
Real User
Director of Operations / Senior Software Engineer at a software R&D company with 51-200 employees
Sep 06 2016

What is most valuable?

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.

How has it helped my organization?

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»

What needs improvement?

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»
Oracle
Consultant
IT Consultant, Business Owner, Lecturer at a tech consulting company with 10,001+ employees
Jul 31 2017

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

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»
Oracle
Real User
Academic application support at a university with 1,001-5,000 employees
Jul 12 2017

What is most valuable?

Speed and stability of the MySQL DB are the most valuable features since we use it as the data store for most of our web applications.

How has it helped my organization?

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»

What needs improvement?

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
Real User
Analista Funcional Líder at a government with 5,001-10,000 employees
Jul 13 2017

What is most valuable?

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»

How has it helped my organization?

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.

What needs improvement?

I have noticed that it consumes a lot of resources. I would improve this aspect.
PostgreSQL
Real User
CEO at a tech services company with 51-200 employees
Sep 01 2016

What is most valuable?

* 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»

How has it helped my organization?

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.

What needs improvement?

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
Consultant
Senior Database DevOps Engineer at a tech services company with 1,001-5,000 employees
Aug 28 2016

What is most valuable?

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»

How has it helped my organization?

PostgreSQL allows us to have a single database engine used for OLTP and OLAP workloads, for relational and non-relational data. Its robust and battlefield-proven replication makes us sleep better.

What needs improvement?

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»
PostgreSQL
Real User
Senior PostgreSQL Database Adminstrator at a financial services firm with 51-200 employees
Aug 28 2016

What is most valuable?

This database is highly reliable and offers excellent disaster recovery. In short, I can depend on it to be available and operational.

How has it helped my organization?

As we’ve used this since our founding, I cannot speak to how it has improved any function.

What needs improvement?

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»
Oracle
Real User
Senior Application Programmer/Analyst, Team Lead at a university with 1,001-5,000 employees
Dec 12 2017

What is most valuable?

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.

How has it helped my organization?

MySQL is widely supported. We were able to integrate it with several different projects using various different programming languages with no issues. Worked with Java, Perl, PHP, C# and C code.

What needs improvement?

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»
PostgreSQL
Real User
Consultant at a tech consulting company
Oct 25 2016

What is most valuable?

Strong enforcement of data types, because it can catch many errors and mistakes and protects data. Standard conformance, because in the end you are not locked to single vendor.

How has it helped my organization?

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»

What needs improvement?

It needs more parallelism for big tables. This is already in PostgreSQL 9.6 beta so things are looking promising.
PostgreSQL
Consultant
Data Architect at Blue Treble Solutions
Aug 28 2016

What is most valuable?

In my experience, the data quality and extensibility are valuable.

How has it helped my organization?

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.

What needs improvement?

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»
PostgreSQL
Real User
Developer at a comms service provider with 51-200 employees
Mar 22 2017

What is most valuable?

* Free and open-source RDBMS, with a permissive license * ACID compliance * Multi-version concurrency control * Custom data types * Array data types * PL/Python stored procedures

How has it helped my organization?

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»

What needs improvement?

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»
Oracle
Real User
QA Lead at a logistics company with 1,001-5,000 employees
Mar 04 2018

What is most valuable?

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»

How has it helped my organization?

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»

What needs improvement?

I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see.
Oracle
Consultant
Powerbuilder Consultant at a government with 1,001-5,000 employees
Jul 27 2017

What is most valuable?

* Relational database (Although it's not 100% compliant with Standard SQL) * Performance * Open Source * Ease of setup and use * Ease of use with PHP, Python, and Java

How has it helped my organization?

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»

What needs improvement?

The simplicity of the product lets people abuse it. I've seen so many people create tables and add indices in PHP code. Some of these web developers only know some things about the database.

Have A Question About Open Source Databases?

Our experts can help. 278,861 professionals have used our research on 6,302 solutions.
2,244
IT Consultant, Business Owner, Lecturer
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>>
7,515
TOP REVIEWER
Project Manager
Hi, I am working as Linux Admin with a MNC. My expertise are messaging with all platforms including Microsoft Exchange, Open Source Postfix, McAfee IronMail and IBM Lotus Domino. :)
6
TOP 5
Data Scientist / Consultant
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>>
334
Senior Production Support Engineer
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>>
664
Technology Architect
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>>
297
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>>
478
Founder and Business Intelligence Consultant
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).
139
Senior Database DevOps Engineer
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>>
159
Senior Consultant / Manager Technical Operations
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>>

Sign Up with Email