Ivor O’Connor

March 23, 2009

SQLite Humorous Cover-Ups Or?

Filed under: sqlite, Uncategorized — Tags: — ioconnor @ 8:54 pm

http://www.sqlite.org/faq.html#q17

Quality assurance in SQLite is done using full-coverage testing, not by compiler warnings or other static code analysis tools. In other words, we verify that SQLite actually gets the correct answer, not that it merely satisfies stylistic constraints…

Uh huh. They go on to say everything is rosy and no errors or warning messages are seen in their own environments. I wonder who wrote this provocative prose? And why.

http://www.sqlite.org/faq.html#q19

Transaction speed is limited by the rotational speed of your disk drive. A transaction normally requires two complete rotations of the disk platter, which on a 7200RPM disk drive limits you to about 60 transactions per second.

Is this from the same author?

Sure would be nice if there were an estimate of when foreign keys and outer joins can be expected. Surely the foreign key question must be their number one FAQ yet it’s not mentioned anywhere on their site.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: