Filed under:
Base
Releases

Base 2.4.4 is now available to download for both web and App Store users. The changes in this version are small, but significant:

  • Sandboxing is now re-enabled for App Store customers. See this blog post for more details
  • A crash-on-launch bug has been fixed
  • An interface glitch where the SQL error notice could not be dismissed has been fixed.
  • Base now requires Mac OS 10.8 or newer to run

Base 2.4.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.

Filed under:
Base
Releases

Base 2.4.3 is now available to download. This is a very important update if you are running Mac OS 10.7 and purchased Base from the Mac App Store.

This version will only be available for a short time (at the latest, 19th May 2013) and will be the last version to support Mac OS 10.7.


That sounded a bit serious, right? Here’s why:

When Base 2.4 was released, the App Store version enabled sandboxing - a security system required to be used by all updated apps on the Store. Among other things, sandboxing places very strict limits on which files an app can open. Typically this is only files which have been specifically selected by the user. However, Base needs more than that. As well as the selected database file, Base needs access to journal files. These are short-lived files which are temporarily created then deleted when making changes to the original database.

A method of getting access to these related files was added in Mac OS 10.8, so Base makes use of it and everything works smoothly. Except that due to a mistake in my testing, I didn’t realise that this method does not exist on 10.7. This means that people running Base on 10.7 could not make changes to their databases as the journal files were prevented from being created by the sandbox.

So that’s the problem in a nutshell. A mistake on my part results in Base coming up against a strict security system. The obvious answer would be to not use that system, but it’s not that simple. The app sandbox is required by Apple for all (non-bug-fix) updates to apps in the Store. Once you’ve enabled it, you are prevented from releasing an update which does not have the sandbox turned on. The system behind the Store flat-out refuses to allow it.

With slight trepidation, I contacted the App Review team at Apple with a request to temporarily opt out of the sandbox. After explaining the problem to a very helpful person, they have agreed to the following:

  • An update to Base can be released with sandboxing disabled
  • Another update must be submitted to the Store with sandboxing re-enabled by May 19th 2013

To achieve this, Base will need to remove support for Mac OS 10.7. This would have happened soon in any case, it is just unfortunate that it is occurring in this way.

Although it seems fashionable at the moment to openly criticise the app sandbox and app review systems, I do not wish to do so. The engineer at DTS who helped me add sandboxing to Base was most helpful and the person I spoke to in App Review took the time to fully understand what had happened and how I proposed to fix it. While the technology may not be perfect, the people making it appear to be working hard to get there.

Finally, though most importantly, I would like to apologize for the hassle this has caused people affected by the bug. If you have any further questions, please do get in touch.

Filed under:
Base
Releases

Unfortunately, in my haste to release a fix for the crashes in Base 2.4, version 2.4.1 did not completely address the root of the problem. In order to limit the number of people downloading a broken release, I reverted back to 2.3.1 on this website and temporarily removed Base from sale on the Mac App Store.

Now, Base 2.4.2 is available for download from this website, and has been submitted to the Mac App Store for review. Once it has been reviewed, I will re-enable it for download. Once again, I apologise for the annoyance this has caused.

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

Filed under:
Base
Releases

The previous update to Base had a bug which caused a crash on launch for users running Mac OS 10.7. It did not affect users on 10.8 or newer.

Version 2.4.1 of Base fixes this bug and is available immediately for download from this site. People who have purchased Base via the Mac App Store will have to wait a little longer as the update must be approved by Apple. I have requested an expedited review, so hopefully this will not take long.

I apologize for the trouble this has caused all those affected, and encourage anyone with questions to get in touch.

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

Filed under:
Base
Releases

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.

Filed under:
Base
Releases

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.

Filed under:
Base
Releases

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.

Filed under:
Base
Releases

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.

Filed under:
Base
Releases

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.

Filed under:
Base
Releases

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.