Base 1.3.3 has been released today. Among it’s changes are two highly requested features: Inclusion of full-text searching (the FTS3 module) and improved handling of SQLite internal tables (those with a name starting “sqlite_”). You can now enable/disable visibility of internal tables in the app preferences.
FTS3 does come with a minor caveat. It seems that there is not a reliable way to identify tables that are part of an FTS3 index. Because of this, I have disabled the modification of virtual tables from the user interface. You (the user) will be responsible for not modifying or dropping the *_content, *_segdir and *_segments tables generated by the FTS module. I do hope to improve this in the future.
The main focus of this release is table schema editing. As SQLite does not natively have the ability to alter table schemas, it is a multi-step process (create new table, copy old data across, delete the old table) and I’m very pleased to finally have such an important feature in the app.
I’m very happy to announce that our first foray into iPhone development has been released. Jezz is a game for the iPhone and iPod Touch, closely based on the old game of Jezzball. To complete each level, you must claim 70% of the playing field by building walls. If a wall in progress is hit by a ball, the wall is destroyed and you lose a life. Each level becomes more difficult through adding more and destructive balls.
I’m pleased to announce that the first public application from Menial has been released. Base is an SQLite 3 database reader/editor for Mac OS X and more details can be found at it’s product page.
17th November, 2008:
Unfortunately there was a problem that slipped through testing before release. When a license file was opened, the app would not register that license. To fix this, just re-download the app from this page and double-click your license file again.