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.

You can download Base 1.3.3 from it’s product page or view a full list of changes.

Edit 2009-10-08: There was a bug causing a crash which slipped through my testing. This crash would occur when you tried to alter any table. I have updated the download of Base, but not changed the version number as it was a very minor fix. If you are affected by this problem, you can download the fixed version by checking for updates within the app. I apologise for the annoyance this has caused.

Base 1.3.2 has just been released. This is only a small bugfix update, so no new features. The changes are as follows:

• Fixed escaping of identifiers in the ALTER TABLE sheet
• Fixed display of edited data in the data browser
• Better notification of broken triggers after altering tables & views
• Slightly better handling of SQLite internal tables. There will be more improvements to come on this.

Base 1.3 has just been released. You can download it from it’s product page or view the release notes.

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.

Looking to the future, most feature requests centre around improving the import/export abilities of the app and improving BLOB viewing and editing. I’d be very interested to hear what current and potential users think are the most needed improvements. If you’ve got something to add, please leave a comment or email.

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.

The wonderful graphics and smooth animations in this game were created by Kevin Andersson of IconDesign.

You can read more about Jezz at it’s product page, or purchase it from the iTunes App Store.

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. 17^th 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.