
Hi Roger
I've been watching this discussion for some time and am wondering about Sqlite which is used in Fedora and RubyonRails. I know it's not Mysql, but how does Sqlite rate against Mysql.
SQLite is available in many distros. It is indeed the default database for local testing stuff in RubyOnRails, which is useful. SQLite is a database library, not a database server. Comparing with MySQL is moot as they serve different needs. In terms of code quality, I have great respect for Richard Hipp who designed SQLite, he did a very good job. Obviously, since it's a much smaller code base with less complexity in terms of concurrency and other factors that MySQL has to deal with, it doesn't serve to compare there either. MySQL has had various code quality reviews in the past (by third parties, not paid by MySQL) and it came out quite well. As with all big/complex systems, there's plenty of older code that an expert (like Stewart) would do differently if it were coded from scratch now - but that's a matter of context and hindsight. Cheers, Arjen. -- Exec.Director @ Open Query (http://openquery.com) MySQL services Sane business strategy explorations at http://upstarta.com.au Personal blog at http://lentz.com.au/blog/