We changed our name from IT Central Station: Here's why

Top 8 Open Source Databases Tools

MySQLMariaDBPostgreSQLFirebird SQLEDB Postgres Advanced ServerOracle MySQL Cloud ServiceSQLitePercona Server
  1. leader badge
    We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good.MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa.
  2. leader badge
    A valuable feature is that we can use it for quite a few things, all the things you'd expect from a server—along the lines of Linux's Lightweight Directory.
  3. Find out what your peers are saying about Oracle, MariaDB, PostgreSQL and others in Open Source Databases. Updated: January 2022.
    563,208 professionals have used our research since 2012.
  4. leader badge
    It is very scalable and comes with a bonus: no licensing issues as you scale with your databases. The solution is scalable, it is very good.
  5. Firebird SQL is an open-source solution and can run on most operating systems, such as Linux, Unix, and Windows.I can deploy it on Linux, Mac OS, and Windows — it's very easy.
  6. The low cost and functionality allows us to save money on smaller database projects.It gives us a solid, less expensive alternative to deploying with Oracle.
  7. Everything from the dashboards to the user experience to compatibility with other solutions is very good.The most valuable feature is the data aggregation function.
  8. report
    Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
    563,208 professionals have used our research since 2012.

Advice From The Community

Read answers to top Open Source Databases questions. 563,208 professionals have gotten help from our community of experts.
Ariel Lindenfeld
Let the community know what you think. Share your opinions now!
author avatarOsama Mustafa
Consultant

I think he most important factors is Functionality, Security , cost, Support, Maintenance, Reliability,Performance, Scaleability and Useability

author avatarit_user712137 (System's Leader Dpt. at a tech services company with 51-200 employees)
Real User

You need to use the product you know better or, failing that, the one with the best support in the community. Other topics to keep in mind in parallel are what you want to use it for; There are databases that have some characteristics that make them better or worse for certain tasks. But basically it is best that you always use the product that best suits what you need, regardless of the type of license (whenever you can, of course).

author avatarNgeno Gabriel (Indra)
Real User

Security, performance and scalability is what i will go for, security of the data stored is very crucial to any organisation and how fast can the data be accessed/retrived and finally how well is the database engine handling growing volumes of data

author avatarit_user644883 (Java Architect / Liferay Expert/ Lead at a logistics company with 10,001+ employees)
Vendor

The selection aspects are the same as the others are already mentioned.
Here is a live case:

In my opinion postgreSQL is the right database for even enterprise class applications. It is know everything that the commercial knows: stored procedures/functions / views / constraint checking etc. It has a relative small footprint of memory and disk space. The command line console & the GUI is also quite good. Easy to install, and it is not need too much maintenance effort. Extremely configurable,it has database connector to Java / C#(?) etc. We use it for a 11 liferay instances and all in all 1800 microsite maintenance.

author avatarit_user608283 (Global IT Project Manager at a tech services company with 11-50 employees)
Consultant

Evaluation of open database must be simple to use, graphical user interface is a plus. Then if you have a huge amount of data, scalability and performance to flesh the data is also important. Secure database is one of most important aspect in database, because is where critical data are there. An other aspect of monitoring, replication and backup is also important. After depending of your choice SQL database or non SQL, that is related to your application. Let see if you have a well structured datas like ERP system for a example, then scalability and security are the most criteria to choose the right opensource database. However if the size of the database table is increasing exponential, more than 32 terabyte. then a vendor solution may be more suitable like ORACLE or less expansive Aurora from AWS.

author avatarit_user552921 (Senior IT Consultant at a tech services company)
Consultant

With open source databases, I think you first have to consider your present requirements with regard to security, evolution over time, usability, reliability. You should also think of new requirements that might come in the future. it might be wise to select a database solution that has as enough flexibility y to meet the new challenges of your organisation.

author avatarDEEPEN DHULLA
Real User

I, who (which team) am going to work and extract maximum benefit from that database ASAP and will check whether it serves the purpose for which it has been taken into the project or not?.


Standard check-list of the management goes into functionality, security, cost, support, maintenance, reliability/performance, scalability and usability as told by @Osama Mustafa. ​

author avatarJohan Sarmiento
Real User

Mainly security, then performance and the most important point interoperability.


Find out what your peers are saying about Oracle, MariaDB, PostgreSQL and others in Open Source Databases. Updated: January 2022.
563,208 professionals have used our research since 2012.