RE: [cgiapp] "Best free DB for a web-based Perl app" response results...

At 2:05 PM -0500 12/1/05, Jesse Erlbaum wrote: 
I really don't think your "SQL Lite" analogy is a valid one.  Oracle,
PgSQL and MySQL are hugely popular.  SQL Lite is a skunk works with no
proven track record.

Quick Google hits check:

  2,250,000 for "Oracle" +rdbms
    756,000 for "MySQL" +rdbms
    384,000 for "PostgreSQL" +rdbms
        207 for "SQL Lite" +rdbms

A bit of a straw man, wouldn't you say? 

I just *had* to reply to this one.

You made one of the biggest argument mistakes possible, which is basing judgement on blatently incorrect data.

Namely, you spelled "SQLite" wrong, so of course Google wouldn't find it.

Given the correct spelling, you would get *101,000* hits for SQLite + rdbms. While lesser than the others, its still the same order of magnitude as MySQL or PostgreSQL.

  2,260,000 for: Oracle rdbms
    740,000 for: MySQL rdbms
    431,000 for: Postgres rdbms (which also returns 'PostgreSQL' numbers
    101,000 for: SQLite rdbms

SQLite is also far from a skunk works project and has a strong proven track record.

It has been around for a long time and being used in a huge number of applications and devices. (Most recently, its even built into Mac OS X 10.4 for its Core Data component.) Many uses aren't even advertised, since it is public domain and users don't have to say they're using it.

It also has dozens of active developers and a very busy mailing list.

Its inventer, D Richard Hipp, was also honored with a top award at OSCON this year due to SQLite being one of the strongest movers and benefits to the open source community.

So some criticism of SQLite is warranted, such a scalability with lots of writers, but not what you said.

-- Darren Duncan
.

Relevant Pages