Sven van Caekenberghe has written a very nice tutorial implementing a Reddit clone in Pharo using Seaside, Glorp and PostgreSQL. Sven also makes available a prebuilt image containing the application.
Seeing that the image contains Glorp working with the PostgresV2 driver, I set about integrating NBSQLite3 with Glorp. After about an afternoon's work, I now have Reddit.st working with Glorp+NBSQLite3.
$ sqlite3 reddit.db SQLite version 3.8.2 2013-12-06 14:53:30 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select * from reddit_links; 1|http://www.pharo.org|Pharo Smalltalk|2014-09-22 22:46:53|1 2|http://planet.smalltalk.org|Planet Smalltalk|2014-09-22 22:47:18|1 6|http://www.world.st/|The World of Smalltalk|2014-09-22 22:58:50|0 sqlite>
There is still much to be done to get Glorp fully working with NBSQLite3: Some tests apparently expect Glorp proxies, but are getting OrderedCollections, and one particular test rendered my Linux X session non-responsive to mouse and keyboard, except for screen brightness key chords!Tags: Glorp, OODB, SQLite