SQLite Notes

1. Testing the SQLite Installation

SQLite 3.1 comes pre-installed on Mac OS 10.4, but not on previous Mac OS versions. Should you choose to run Smalltalk applications on Mac OS 10.3, your clients will have to either download and install SQLite themselves or you can include libsqlite3.dylib as a resource in your Smalltalk application.

Note that there is no server component to install, applications access a database file directly.

1. Testing the SQLite Installation

Once you have installed the database, load Tests-Database.stp and evaluate:

SqliteDatabaseTest suite run.

The following test cases are expected to fail:

SqliteDatabaseTest>>#testInteger
This test fails due to an SQLite bug storing certain integer values (16r800000000000 to 16rFFFFFFFFFFFF). All other 64-bit signed integer values have no problem, as shown by the SqliteDatabaseTest>>#testIntegerWithBug test case.

Last modified May 22, 2006.