Base 2.4 is now available to download, for both web and App Store users. This update includes both new features and some bug fixes.

The main points for this version are a new logging system, with fast filtering and simplified preferences and improvements to the custom SQL tab. After running your own statements, you can now get a breakdown of each statements execution time.

This update also enables sandboxing for the Mac App Store version. I have decided not to enable it for the direct-sale version of Base until I am completely happy that it does not cause any issues with the App Store version. Lastly, as of this update, Base now requires Mac OS 10.7 (Lion) or newer to run.

Base 2.4 can be downloaded from the product page or from the Mac App Store.

As always, the full list of changes can be found in the release notes and if you’ve found a bug or have a question, please do get in touch.

I am delighted to announce the release of a new app, Filler.

Filler is for making data. It began life as an internal testing tool, for creating multi-gigabyte databases and has slowly expanded with the addition of more datatypes and formats that can be created. It can generate many different data types, from the basics like random numbers and strings to names and GPS coordinates. These rows of data can be generated by the million as any one of several different file types.

Filler is iCloud-enabled, so your documents are available on all of your Macs. It looks great on Retina displays too.

Check out the full description of Filler, or purchase it on the Mac App Store.

Base 2.3.1 is now available to download, for both web and App Store users.

This is a bug fix update which improves support for the MacBook Pro with retina display and fixes a number of relatively minor problems.

Base 2.3.1 will be the last version to support 10.6 Snow Leopard. Future versions will require 10.7 Lion or higher.

Base 2.3.1 can be downloaded from the product page or from the Mac App Store.

As always, the full list of changes can be found in the release notes and if you’ve found a bug or have a question, please do get in touch.

Base 2.3 is now available to download, for both web and App Store users.

This update contains a range of changes, with highlights including a new visual pragma editor and line numbers displayed in data tables. For users outside the App Store it is also signed ready for Gatekeeper in Mountain Lion.

A full list of changes can be read in the release notes

Base 2.3 can be downloaded from the product page or from the Mac App Store.
As always, if you’ve found a bug or have a question, please do get in touch.

Base 2.2.1 is now available to download, for both web and App Store users.

This is a bug fix update, taking care of some problems with data filters, CSV importing and the table editor. A full list of changes can be read in the release notes

Base 2.2.1 can be downloaded from the product page or from the Mac App Store.
As always, if you’ve found a bug or have a question, please do get in touch.

Base 2.2 is now available to download, for both web and App Store users.

Browsing table data has been tweaked so that BLOB data fields are now displayed as a clip icon instead of garbled text. Double-clicking on a BLOB icon will show an editor sheet, pre-loaded with a viewer suitable for that data. It knows the different between text and images and will also attempt to discover the correct file extension for any other data you may throw at it.

Editing table data has also been made easier with the addition of some keyboard shortcuts. These are:

• Add row: ⌘ + (command and plus)
• Delete row: ← (backspace)
• Previous page: ⌘ ⤎ (command and left arrow)
• Next page: ⌘ ⤏ (command and right arrow)

There is also an invisible but significant change in this update. The code for parsing table schemas has been rewritten to give greatly increased speed when viewing or editing complex schemas. It also results in far fewer display errors when inspecting tables.

A full list of changes can be read in the release notes

Base 2.2 can be downloaded from the product page or from the Mac App Store.
As always, if you’ve found a bug or have a question, please do get in touch.

I'm sorry to say that from now onwards, Jezz is no more. It was a fun app to make, but it needs a lot of work to bring it up to date. iOS 4 (and soon 5) brought a lot of changes and I need to prioritise working on my other apps over Jezz.

For those of you who have purchased Jezz, you will still be able to download it from the Purchased tab of the App Store.

Base 2.1.1 is now available to download, for both web and App Store users.

This is primarily a bug fix release, with details available in the changelog. It does add support for full-screen mode on Lion, as well as explicit support for files with the extension .sqlite.

Base 2.1.1 can be downloaded from the product page or from the Mac App Store.
As always, if you’ve found a bug or have a question, please do get in touch.

Last night, Apple quietly adjusted the prices on some of the App Store storefronts. This meant that for a few hours, prices varied by a relatively small amount depending on which store and which country you purchased any of my apps from.

One of the App Storefronts which had prices raised was the UK one. Since I price Base in GBP, I have returned the UK price from the Apple-set £22.99 to £19.99. This means that many other countries have effectively had a price cut. For example, the US price before adjustments was $32.99 and is now $28.99.

To better fit the newly adjusted pricing tiers, I have decided to drop the price of Jezz to £0.69 ($0.99). The price of Statistics for WordPress will not change from the current level.

Base 2.1 is now available to download, for both web and App Store users.

The full list list of enhancements & fixes is available from the changelog, though there is one item I'd like to mention in more detail here.

Something which I have received many emails about is that NULL values in tables are hard to distinguish from any other text. Being able to set the display string goes some way to fixing this, but doesn't quite go far enough.

Base 2.1 now provides the option of displaying a placeholder graphic for cells with a NULL value. Now it's easy to skim a table and see where the NULLs are, without having to hunt through pages of homogenous text. Here's a contrived example to illustrate:

Base 2.1 can be downloaded from the product page or from the Mac App Store.
As always, if you’ve found a bug or have a question, please do get in touch.