Hi there.
I just wonder a little bit about the different database-servers and so on. I actually use one myself for webpages and so (mysql). Why should a big firm use Oracle (or IBM DB2) instead of MySQL? The MySQL-server is almost as fast as the Oracle (or IBM DB2) system and can be read through ODBC using myODBC - So why should the big company use the expensive Oracle system instead of the free MySQL-server. What about PostgreSQL - what about that server. It's almost a standard on the most Linux-distributions - Is it better than MySQL? We never hear anything about the PostgreSQL (it's just something that always' there)
- Is there a nice GUI like Microsoft Access' in Oracle or is it just a server like the MySQL
- It's commercial - yeah, but is it better than MySQL (not thinking of the little difference when running with more than a couple of thousand users) - and better than PostgreSQL?
- I've heard that the MySQL-server shouldn't use real standardized SQL as the other SQL-servers at the market?
- Is PostgreSQL any good (and does it use the real standardized SQL-language.
- How fast is PostgreSQL (thinking of the difference to other DB-systems)?
Here's some other discussing-questions I have? (I'd like argumented answers).
- What about Interbase? It really has a nice GUI - Why doesn't anybody talk about this database-server developed by Borland (Inprise)?
- Microsoft SQL (too slow and expensive (mySQL a better choice (that's for sure or???)))
- FileMaker (It's not a server (what I know of)) - But is it any good - thinking of a competitor to MS Access which kinda stinks (my opinion)?
- FoxPro (I've only heard it by name) - Is it any good (a server or GUI-database (like Access))
The main question is: What's the difference of the DB-servers and what are the pros and cons of these?
The secondary question: Competitors to Microsoft Access? Are there any and what are the pros and cons of these?
The third question: What is PostgreSQL and what about it? Is it just always there or is it any good? Is it old-aged and ready to be pulled out the market or??? (big question-mark)
It's actually three simple questions I sometime wonder about - And the only reasonable explanation to the first main question is (that I can think of) that the commercial databases are better supported than the free ones (such as mySQL or PostgreSQL). But that's not satisfying for me - I want some facts and opionions (experiences)!
I really hope someone is qualified to answer this question?
Preben Holm (denmark)
