Rowids and Primary Keys

SQLite has the concept of a rowid. A special column with a unique integer identifier for each row. It’s present in most tables, but generally hidden from view. This post gives an overview of how rowids work and their relationship with primary keys.

Base 3.1.0 Released

Base 3.1.0 is now available for download.

This update adopts the new Liquid Glass look on macOS 26 and contains a good selection of quality-of-life improvements to make using Base even nicer.

Retrospective on making Base 3

The first version of Base was released in late 2008. It grew into a v2 by early 2011 and kept going until the last feature release in 2020 (with a few bugfix releases after).

On the 4th July 2020, I started a new branch for Base v3.

Base 3.0.2 Released

Base 3.0.2 is now available for download.

This is a bug-fixing release, containing the following changes:

Base 3.0 Released

I'm incredibly happy to announce that Base 3.0 is now available for download.

The app has had a major overhaul to all areas while keeping a familiar UI.
Base 3 is faster, more capable and even nicer to use.

Base 2.5 Released

After a bit of a gap, I’m pleased to say a new update to Base is available to download.

The highlights include:

• Modernising the UI a bit to bring it more in line with recent versions of macOS. It looks familiar, but feels less old fashioned.
• Adding syntax highlighting themes. You can now have different text colours for light & dark modes which switch automatically.
• Adding support for macOS Dark Mode throughout the app. No more eye glare!
• All versions of Base now require macOS 10.14 (Mojave) and have enabled sandboxing

There’s other minor bugfixes in there too which sort out some UI glitches and misplaced buttons.

Base 2.4.11 Released

Base 2.4.11 is now available to download for direct sale, Setapp and Mac App Store users.

This update fixes a bug causing Base to sometimes crash when re-opening a database on launch. It also updates to SQLite version 3.17.0.

Base 2.4.11 can be downloaded from the product page, Setapp or the Mac App Store.

Base on Setapp

Base is now available on Setapp, a new service from MacPaw which gives you access to more than 50 great apps for $9.99 per month, with a month’s free trial to start.

When you subscribe to Setapp, you have unlimited access to a curated library of useful apps. There are no upgrade fees, no ads, and no in-app purchases. One fixed fee gets you all of it.

InkStamp - A rubber stamp sticker pack for iMessage

I’ve made something small and fun. A rubber stamp sticker pack for iOS 10!

It’s a collection of iMessage stickers in the style of rubber stamps. There are stamps for likes and dislikes, reactions, star ratings, and a bunch of other odds and ends.

Here’s a couple of images showing them in use:

Base 2.4.10 Released

Base 2.4.10 is now available to download for both direct sale and Mac App Store users. This update fixes some minor problems and updates to the latest version of SQLite.

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