Base 2.3.1

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

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.

Base 2.2.1

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

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.

Base 2.1.1

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.

Base 2.1

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.

Reading your iPhone location log

There’s a bit of fuss about iPhones tracking their owners location history.

The instructions on that page are pretty involved. Here’s a command-line-free method to get at that controversial little file:

1. Download and open iPhone Backup Extractor
2. Click "Read Backups" and select the most recent backup from the list that appears
3. A list of app identifiers will be shown. Choose the one that says "iOS Files" and click Extract
4. Choose a location for extraction and wait a minute while the app does it's thing
5. In the finder, navigate to <extracted folder location>/Library/Caches/locationd
6. Open the file "consolidated.db" in your SQLite editor of choice. I recommend the one we make

That SQLite database uses the R*Tree extension. Check out the SQLite documentation on how to efficiently query it.

Base 2.0.2

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

It’s primarily a bugfix release, ironing out some more kinks found since 2.0.1. It also enables support for the SQLite R*Tree module.

You can read the full list of fixes and improvements in the changelog.

Base 2.0.2 can be downloaded from the product page.

The Individual

Whoever you are, lone PowerPC user, I salute you.

Update 2011-03-30: And a few days later, the Mysterious Individual has gone. Update stats say that Base now has an Intel-only userbase.

Base 2.0.1

Base 2.0.1 is now available to download, for both web and App Store users. It addresses several bugs related to the display of schemas and some other minor issues. You can read the full list of fixes and improvements from the changelog.

Base 2.0.1 can be downloaded from the product page.

As always, if you’ve found a bug or have a question, please do get in touch.