I like SQLite. SQLite is small, fast and reliable. As mentioned in this
old blog post, I was extending the Squeaksource
SQLite FFI wrapper to support parameter binding. Since then, Torsten
Bergmann has also picked it up and now tends to it on
Taking the chance to learn NativeBoost, with hints from Masashi Umezawa's
PunQLite, I took my
SQLite FFI changes and created
small test suite runs successfully on Pharo 2.0 (OSX, Linux) and the
current Pharo 3.0 beta on OSX.
Here's a multithreading example:
To run this example, evaluate "NBSQLite3Example multithreading". The
output looks thusly:
The SQLite shared library is compiled with -DSQLITE_USE_URI=1 and -DSQLITE_THREADSAFE=2.