Base 1.3.4 released

Base 1.3.4 has been released today. It only has one change over 1.3.3 which fixes a bug causing the app to crash on quit (very annoying!).

As usual you can download the update from it’s product page or by checking for updates within the app.

Base turns one!

A year ago today, Base was introduced to the world as a shiny new 1.0.

Well, perhaps not that shiny.

A bit of a rookie error meant that anyone buying the app couldn’t actually use the license file they’d just bought until 1.0.1 a few hours later. Version 1.0.2 followed the next day after someone found noticed another bug. Both of these were things that should have been found during testing, and served to show how thoroughly you should test an app before releasing it. That mad scramble had a chastening effect and all releases since have been much more comprehensively tested!

Read More

Base 1.3.3 released

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.

Read More

Base and Snow Leopard

As I don’t have one of those (expensive) subscriptions to Apple’s Dev Centre, today has been the first chance to test Base on Snow Leopard (10.6). So far everything seems to work ok, but if anyone comes across any new oddities since upgrading, please let me know. You can either add a comment below or send an email.

Read More

Base and non-English characters

Just a quick note regarding Base and using non-English characters in SQL queries. Base defaults to using the font Courier in the custom SQL and log views. This font doesn’t seem to support a very wide range of international glyphs, so text like ‘Αθήνα’ 1 simply doesn’t appear in the text fields!

Read More

Base 1.3.2 released

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 released

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.

Read More

On PayPal and security

Update 2009-05-31 PayPal have now restored access to payment processing. All should hopefully be normal now.


As anyone who has tried to buy Base since Friday (28 May 2009) has noticed, I'm currently unable to accept payments and hence process any sales. This is because PayPal has noticed that I had not fully verified my details with their system to prove I'm not some sort of international fraudster. Which I'm not.

It’s good that they do check people out. Their system as a whole would collapse without a decent level of scrutiny. However in my case, I don’t feel they’ve applied much common sense to the matter. Example:

Read More

Base testers required

Update 2009-05-31 Thank you to everyone who has contacted me. I’ve got enough testers for now, but will post again next time more are needed.


Base 1.3 is nearing completion and is in need of testing. I'm looking for half a dozen people (or thereabouts) to try it out and give some feedback.

This release is focused on editing table schemas, so ideally testers should be willing to:

Read More

Base 1.2 and editing

Well, Base 1.2 has been out for just over a week now, so I figured it’s time for an update. 

So far, the app seems to have had a pretty good reception. Thank you to everyone who has taken the time to contact me with feedback (especially those who have sent detailed bug reports). For the most part, complaints and requests have centered around one area: the editing of existing tables. 

Read More