IT Central Station is now PeerSpot: Here's why

When evaluating Open Source Databases, what aspect do you think is the most important to look for?

Ariel Lindenfeld - PeerSpot reviewer
Director of Content at PeerSpot (formerly IT Central Station)

Let the community know what you think. Share your opinions now!

PeerSpot user
3131 Answers

DEEPEN DHULLA - PeerSpot reviewer
Top 5Real 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. ​

Osama Mustafa - PeerSpot reviewer
Top 10LeaderboardConsultant

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

it_user712137 - PeerSpot reviewer
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).

Ngeno Gabriel - PeerSpot reviewer
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

it_user644883 - PeerSpot reviewer

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.

it_user608283 - PeerSpot reviewer

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.

it_user552921 - PeerSpot reviewer

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.

Johan Sarmiento - PeerSpot reviewer
LeaderboardReal User

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

PaulLemmons - PeerSpot reviewer
Real User

Deleted, posted answer to the wrong question. My apologies for the noise.

Andre Luiz Dutra Ontalba - PeerSpot reviewer
Real User

The most important is the scalability,compatibility, support

Juan Carrera - PeerSpot reviewer
Real User

the most important is the scalability, security, compatibility and support

it_user881307 - PeerSpot reviewer
Real User

The security primarily, the scalability, the usability and the processing capacity before complicated query, verify the base code of the same and determine which is the method used to carry out the query

it_user871758 - PeerSpot reviewer
Real User

I considered is relative and depends on the use case. But in the majority of cases the security and scalability are the principles characteristics to found!

Arthur Hicken - PeerSpot reviewer

It's gotta be stable - I love fast, but you can never, ever lose data.

it_user792120 - PeerSpot reviewer
Real User

What kind of traction does the solution as in the industry and why. How can we leverage it for our business challenges.

it_user775743 - PeerSpot reviewer

Security is the first and foremost.

it_user768273 - PeerSpot reviewer

First comes is how secure it is, accuracy , performance, features, does it fit in my requirements . I will consider it in every aspect

Andre Luiz Dutra Ontalba - PeerSpot reviewer
Real User

Stability, Security and Performance which needs to be taken into account when going for an open source databases

it_user690066 - PeerSpot reviewer

Before jump into an Open Source Database, you need to understand that any bug or feature is attached to the workforce behind it. It could be a company/companies or a huge community. Been said, you need to practice patience and learn how to feed the cycle to improve it too. You can be a passive user, it's ok, but part of the joy is to collaborate back to the community. You can do it in many ways.

Inside the Open Source Database ecosystem you will find almost a fit for every need, but certain features (specially those in state of art) are mostly available on privative databases. So, sometimes you will need to get into some imagination and artisan mechanisms to make them work as you need, for very specific purposes. Nowadays, this gray area is shrinking but there are certain areas wether OSD do not fit well or lack of some very advanced features.

And the most important part: do not _only_ read the documentation, improve it if you can!

it_user629100 - PeerSpot reviewer

if I would have to choose one, then the usability from the developers perspective including the whole stack using the db

it_user610077 - PeerSpot reviewer

A good base of partners and developers, and a free form of open source that dont force you to sign just for a poor of entreprise features.

it_user563487 - PeerSpot reviewer
Real User

While Accessing the Open source Database, below information should considered.
1. With any mission critical database, max. recovery should be possible which open source can not gave guarantee
2. From security, and performance prospective no one has accountability to fix the issue. During the catastrophic failure, relying on open source database could prove a big mistake for the organization. Loss of time/Manpower and Loss of business.
3. Open database creates more challenges during day to day support and maintenance of the application and relying on open database technology used may delayed or postpone the business development schedule.
So in long term, It could prove to be costly and a major business failure. You will not find any mission critical database relying on Open Source database technology (e.g. Banking,Capital market stock securities and so on)


it_user600681 - PeerSpot reviewer

Stability, Security and Performance which needs to be taken into account when going for an open source databases

it_user573327 - PeerSpot reviewer

Is developer/contributor base is strong or not.

it_user555195 - PeerSpot reviewer
Real User

Does it meet your needs and is the community active and strong?

it_user488589 - PeerSpot reviewer

Firstly check if it is ANSI SQL compliant so that we can get standard SQL developers from resourcing perspective. Next if it is intended for production and time critical application then timely support for any issues is very important. If there are companies who provide professional support services for this database then that's the best. Check if replication and/or backup & restore capabilities are good to handle High Availability and Disaster Recovery.
Another important point is does this solution fit for the kind of problem we are trying to solve - like are we trying to build a web portal solution and need split second responses or solving bulk data load problem etc.
Also look for data security features like role based object permissions etc.

it_user454548 - PeerSpot reviewer

Technical Support offerings.

it_user413964 - PeerSpot reviewer

While evaluating Open-Source Products, the main concern is limitations to that product as well as support provided either official and community. Secondly using Open Source on Production environment is always risky unless all risk variables are known. So complete knowledge of that open source product especially limitations

it_user340539 - PeerSpot reviewer

if databases are involved, scalability is always my initial concern, then performance(metrics), then finally, but not least, the efficiency and performance of the agent/medium between it and the application that will use the database.

it_user336075 - PeerSpot reviewer
Real User

I think it entirely depends on the use case. If you're looking to dig a hole, you want to evaluate shovels, not all yard tools. If my project is focused on delivering high-scale, real-time analytics, then metrics around latency, replication times, and performance are important. If I'm looking to build a large, web-based application, I would likely evaluate security, ease of scaling out/sharding, and APIs. Choose the right solution for the problems you're trying to solve. Your time should be spent on creating value and functionality, not working with flashy features of the supporting platform.

it_user335691 - PeerSpot reviewer
Real User

security,performance and accuracy with speed are the factory are factory which i believe to be taken into consideration

Buyer's Guide
Open Source Databases
June 2022
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases. Updated: June 2022.
610,336 professionals have used our research since 2012.