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.

Filed under:
Base
Releases

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:

Sample table with NULL placeholders

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.

Filed under:
Base
Releases

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.

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

Filed under:
Base
Releases

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.

Filed under:
Base
Releases

Base 2 icon

 

I'm delighted to announce that Base 2.0 is now available.


Version 2 of Base is the first major upgrade since the original application was released in November 2008. Almost every part of the app has been tweaked and improved, with several areas getting almost completely re–written. The result is an application which is just as quick and easy to use as the original, with a lot more power.

 

Major highlight of this version include:

  • A revamped schema viewing and editing system, which includes support for all column– and table–level constraints
  • Autocompletion of SQL when typing
  • A find & filter system for browsing data
  • The ability to export the results of custom queries

Remember, those are just highlights. There are more new things, a lot of improvements to existing features and some longstanding bugs have been fixed.

An overview of the application with screenshots is available on the product page and you can read the entire release notes over here.

Base 2 is priced at £19.99 for new users, £9.99 for existing users, and free for those who bought Base on or after 6th January 2011. You can buy it through this website or through the Mac App Store.

 


Quick edit: If you're still running Mac OS 10.5, or don't yet want to upgrade, you can download the most recent 1.x version from here: Base 1.4.2.

Filed under:
Base
Releases

Base 1.4 is now available for download.

The major changes in this release are CSV importing and overhauled SQL importing.

The CSV importer can either create a new table from your data or you can import directly into an existing table. For an example of CSV importing, see the following screenshot: Base import example

There’s also a whole load of minor changes to Base. Highlights include:

  • A toolbar button to vacuum the current file
  • You can now drag and drop entities from the source list into the SQL tab
  • Improvements to how numeric data is handled when edited, particularly when no column affinity is set (see the SQLite docs)

Base also now collects anonymous system data when checking for updates. If you’d rather not participate in this, you can opt-out in the app preferences.

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

Filed under:
Base
Releases

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.