Best database - How to decide

When it comes to the best Database, a lot of stuff needs to be considered

1) Size
2) Ease of use
3) Embedded Nature
4) Licensing
5) Enterprise Orientedness
6) Features

1) Size: Oracle is synonymous with databases in companies where there are a huge number of records in the database. Nothing can come close to it.

2) Ease of Use: Well, this stands for the interface. There is quite some competition here. Oracle is good. MySQL has some third party GUI and cli interfaces that can ease out the job. Sqlite3 is just too simple and easy to use

3) Embedded Nature: sqlite3 is one of the very few quality databases that can be used for embeddes stuff. The entire database comes as a simple file module in python and a small library in C.

4) Sqlite, postgreSQL are open source
MySQL is dual licensed. For non-commercial, it is GPLed
MS SQL and Oracle are proprietary

5) Enterprises: Oracle for Data Centers, MySQL/PostGres for Open Source purists

6) Features: Oracle ships with a whole bunch of tools
MySQL does too. But it is not sql99 compliant
Postgres aims for full compliance
Sqlite3 is not feature rich, but most certainly usable and more than enough for small projects that need to start quickly

---
ScriptDevil

 

 

 

Comment/Reply (w/o sign-up)

Great post, thanks. I would say you are right, I completely agree with your analysis.
However, you first added your post as a reply to http://www.astahost.com/Error-Installing-M...163#entry135163, spoiling a topic on a completely different subject (Error in Installyg MySQL server).
However, your text is still valid and still very interesting, that's why I moved it her, in it's own thread.
Please, next time, if you want to express your opinion, look it your text matches the topic subject. If not, please open your own thread.
Regards
Yordan

Comment/Reply (w/o sign-up)

I am going to expand on this a bit for you. For a real DBA the ease of use of the GUI is not a key factor in much the same way a Linux admin may well skip the GUI and go straight to the command line.

In the case of high end database engines the products extension of the SQL language and implements those extensions goes a long way to making the RDMS usable. How the RDBMS handles stored procedures and triggers and the language(s) used for those could be a consideration as well. Reporting tools, of course, greatly contribute to the ease of use for an RDBMS.

Just thought I should add those considerations. I guess you could say that what qualifies as ease of use is greatly dependent on the user in question.

Comment/Reply (w/o sign-up)

good thanks for the info

Comment/Reply (w/o sign-up)

Good info. One thing people need to remember is every situation and personal preference is different. Sometimes you get lucky and you have a situation that perfectly fits one product. Other time you have a situation that maybe two or three database systems would all work wonderously for. Then it falls on anything from personal preference to what you or your group or company are already experienced with or set up for.

Persoanlly I've used MySql, ORacle, and MSSQL and each have strong pros and strong cons Oracle is currently the one I'm using a lot but it constantly bugs me that there is no auto incrementing fields (at least in the version I'm dealing with on my current project) and must be handled differently then normal.

MSSQL sort of bugs me in some ways but when working in .Net architectures some of the tools provided make all DB interactions a breeze and simply a pleasure to work with.

And and course, MySQL is top notch stuff by any standard especially when you note it's price tag.

 

 

 

Comment/Reply (w/o sign-up)

For me, I generally stick to MySQL just because a lot of websites use it and it's the only database system that Astahost provides right now.

I've been forced to use MS Access and MSSQL, and I didn't like it one bit. Especially the forcing part lol.

xboxrulz

Comment/Reply (w/o sign-up)

thank you mush!

Comment/Reply (w/o sign-up)

This is an easy question...MySQL is simple the best database...Why do you think that almost all the servers use it? I never have had a problem with MySQL its language is easy to learn and is almost an universal language in programation...

I donīt recommend that you use a different type of database...Please donīt lose your time and your brains with others...

MySQL is simple the best...

Regards

Comment/Reply (w/o sign-up)

I recently started to learn databases. Right now I have given a try with MySQL and SQLite. SQLite seems to be the most portable in the sense you don't need a server to run the database. I can quickly backup the databse unlike going through the phpmyadmin in MySQL. Although MySQL is also easy to learn, I will stick with SQLite for some more time before moving on to MySQL.

Talking about other databases, they are all proprietary and can't be easily setup. And when MySQL is the most widely used, what is the need of thinking about other such databases? One exception is Oracle which I have heard to be the most powerful database system around.

Comment/Reply (w/o sign-up)

For personal purposes, maybe no interest. However, if IT is your job, you cannot ignore databases, at least for backup-restore purposes if you are the system administrator. And if your company chooses db2, you have to cope with it, even for personal purposes you would have chosen something else.

Comment/Reply (w/o sign-up)