Mimsy Were the Borogoves

Hacks: Articles about programming in Python, Perl, PHP, and whatever else I happen to feel like hacking at.

Maven: SQLite front end

Jerry Stratton, May 2, 2010

Bernard Teo at Cutedge Systems appears to be writing some nice front ends to Mac OS X’s command line services. He’s got one for Postfix, for DNS, and, something that really interested me, for SQLite3. My current go-to SQL front end, Sequel Pro, only supports MySQL. But most of my data at home is stored in SQLite using Django.

Maven is available only for Snow Leopard, and is currently free. It claims to support MySQL5, PostgreSQL, and SQLite3. I’ve only used it with SQLite3. It’s definitely a work in progress—it won’t display the columns in some tables, nor make the automatic display query, though you can edit it by hand.

One nice thing is that it can cancel long-running queries with ease, something Sequel Pro sometimes has trouble with.

It can also save changes made to rows in search results. Rather than saving changes immediately, it marks changed rows with an “M”; when you’re ready to commit your changes you can use the File:Save menu item to save them.

There’s still a lot of work to do, but if you’re looking for a relatively easy-to-use GUI for SQLite on Mac OS X, check it out.

  1. <- Inkscape getElementById
  2. Murky for Mercurial ->