2015-10-25 12:49:43 UTC

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


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

Guest
3030 Answers
author avatar
TOP 5LEADERBOARDConsultant

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

2018-11-15 17:55:20 UTC
author avatar
TOP 5Real 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).

2017-07-31 12:58:38 UTC
author avatar
TOP 10Vendor

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.

2017-04-11 13:40:17 UTC
author avatar
TOP 10Consultant

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.

2017-02-13 17:28:30 UTC
author avatar
TOP 20Consultant

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

2017-02-02 07:03:40 UTC
author avatar
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.

2016-11-15 15:41:36 UTC
author avatar
TOP 5LEADERBOARDReal User

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

2019-01-24 20:07:30 UTC
author avatar
TOP 5Real User

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

2018-10-23 22:52:40 UTC
author avatar
TOP 20Real User

The most important is the scalability,compatibility, support

2018-07-31 11:17:13 UTC
author avatar
TOP 20Real User

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

2018-07-30 16:18:31 UTC
author avatar
TOP 20Real 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

2018-05-31 15:12:12 UTC
author avatar
TOP 5Real 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!

2018-05-12 22:49:56 UTC
author avatar
Vendor

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

2018-02-22 00:15:43 UTC
author avatar
TOP 20Real User

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

2017-12-20 14:53:37 UTC
author avatar
Consultant

Security is the first and foremost.

2017-11-20 18:23:06 UTC
author avatar
Vendor

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

2017-11-06 15:30:00 UTC
author avatar
TOP 20Real User

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

2017-06-26 11:38:16 UTC
author avatar
Consultant

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!

2017-06-22 20:35:05 UTC
author avatar
Vendor

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

2017-03-17 12:39:28 UTC
author avatar
TOP 20Vendor

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.

2017-02-21 02:13:39 UTC
author avatar
Consultant

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)

Thanks,
XYZ

2017-02-10 03:02:30 UTC
author avatar
Consultant

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

2017-02-02 05:07:23 UTC
author avatar
Consultant

Is developer/contributor base is strong or not.

2016-12-16 09:06:35 UTC
author avatar
Vendor

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

2016-11-19 01:46:33 UTC
author avatar
TOP 10Vendor

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.

2016-07-30 07:14:36 UTC
author avatar
Vendor

Technical Support offerings.

2016-06-02 06:30:31 UTC
author avatar
TOP 10Consultant

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

2016-03-29 07:50:16 UTC
author avatar
Vendor

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.

2015-11-13 15:06:47 UTC
author avatar
Vendor

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.

2015-11-03 19:44:34 UTC
author avatar
Vendor

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

2015-11-03 08:59:57 UTC
Find out what your peers are saying about Oracle, MariaDB, PostgreSQL and others in Open Source Databases. Updated: January 2020.
391,329 professionals have used our research since 2012.