Looks like my faith in oracle and mysql are founded somewhere in fact.
I trust oracle because its usally run by an expert somewhere and I don't have to worry about it. Every time I have worked with oracle it has been transparent enough to hardly affect my work.
I really like MySQL because so far it has met my needs, and been really easy to use and excellently documented.
eWeek did some comparisons here and surprise - they come out tops.
cool
-Dom
Re:No Postgres
TeeJay on 2003-02-11T17:47:44
yeah, I was dissapointed by that - if we had the example site we could test it against sqlite as well.maybe we should contact them.
Re:No Postgres
johanvdb on 2003-02-11T21:45:53
Probably they saw postgresql was first in all tests, even before Oracle, and that hurts;-)
I really like postgresql as it has almost all the features of Oracle except for the license cost...
Re:JDBC
TeeJay on 2003-02-11T22:13:58
Very True!It seems that SQL Server JDBC and even ODBC drivers leave something to be desired.
I don't think any serious java project should consider SQL Server at the back end for that reason - as well as it not offering much value and not integrating as well in to vertical Java solutions by the likes of IBM.
This does show that MySQL would not be part of the system that would slow down any application though.
If it can manage the same throughput as oracle and others then it clearly scales adequately that the middleware becomes a weaker link (at least in the case of SQL Server and others).
Of course this didn't cover hairy transactions, or require clustering or high availability - but 90% of solutions don't require that. Even those that do can usually work fine with Master/Slave load balancing which is practical and proven with MySQL.
I should mention that I really like the 'feel' of mysql in many ways - the full text searching is rather good and it is easy to tweak and secure.
Re:JDBC
lachoy on 2003-02-12T02:11:31
Well, they do say this:Out of all the drivers we used, Microsoft's new JDBC driver had the most problems. It's still a beta driver in the form distributed on Microsoft's Web site, but it's not a new product per se, because it's based on code licensed from DataDirect Technologies Inc., which has had the leading third-party SQL Server JDBC driver for some years now.Fortunately there are other drivers on the market -- I've used ones from i-net with good results. The only time I tried to use the MS JDBC driver it barfed on some fairly common metadata commands. (Besides, I trust MS to produce a decent JDBC driver as much as I trust RMS to push proprietary software
;-)
