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
As seen in
30 Answers
Johan SarmientoReal UserTOP 5LEADERBOARD

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

24 January 19
Osama MustafaConsultantTOP 5LEADERBOARD

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

15 November 18
PaulLemmonsReal UserTOP 5LEADERBOARD

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

23 October 18
Andre Luiz Dutra OntalbaReal UserTOP 5

The most important is the scalability,compatibility, support

31 July 18
Juan CarreraReal UserTOP 5

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

30 July 18
Carlos Alberto Pedron EspinettReal UserTOP 20

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

31 May 18
Joha OcaReal UserTOP 5

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!

12 May 18
Arthur HickenVendor

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

22 February 18
Gino Jr. CerroReal UserTOP 20

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

20 December 17
Vaishnavi KetharnathanConsultant

Security is the first and foremost.

20 November 17
Akshay KaleReal UserTOP 20

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

06 November 17
Manuel Trujillo AlbarralReal UserTOP 5

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).

31 July 17
Andre Luiz Dutra OntalbaReal UserTOP 5

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

26 June 17
Emanuel CalvoConsultant

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!

22 June 17
Csaba TenkesReal UserTOP 5

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.

11 April 17
Senior Product Manager at a tech vendor with 51-200 employeesVendor

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

17 March 17
Clóvis WichoskiReal UserTOP 10

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.

21 February 17
Global IT Project Manager at a tech services company with 11-50 employeesReal UserTOP 10

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.

13 February 17
Lead Consultant at a tech services company with 10,001+ employeesConsultant

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

10 February 17
Ngeno GabrielConsultantTOP 20

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

02 February 17
Manager at a tech services company with 10,001+ employeesConsultant

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

02 February 17
Hadoop Consultant/Sr Software Engineer(HPC) at a tech consulting company with 10,001+ employeesConsultant

Is developer/contributor base is strong or not.

16 December 16
Senior Software Engineer at a tech vendor with 501-1,000 employeesVendor

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

19 November 16
Senior IT Consultant at a tech services companyConsultant

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.

15 November 16
Technology Architect at Broadridge Financial SolutionsConsultantTOP 10

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.

30 July 16
Project Manager / Consultant at a tech vendorConsultant

Technical Support offerings.

02 June 16
Business Intelligence Consultant at a tech services company with 51-200 employeesConsultantTOP 10

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

29 March 16
Apps Developer at a printing company with 501-1,000 employeesUser

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.

13 November 15
Product Line Manager at a tech company with 201-500 employeesVendor

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.

03 November 15
Software Consultant at a tech vendor with 10,001+ employeesVendor

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

03 November 15
Find out what your peers are saying about MySQL vs. PostgreSQL and other solutions. Updated: July 2019.
354,290 professionals have used our research since 2012.
Sign Up with Email