Maven: SQLite front end
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.
- Django
- “Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design.” Oh, the sweet smell of pragmatism.
- Liya for Snow Leopard: Bernard Teo at Cutedge Systems
- This SQLite3 (and MySQL5/PostgreSQL) front-end seems to have trouble with some tables. Big results can take a long time, but it cancels them with ease.
- Sequel Pro
- “MySQL database management app for Mac OS X.” This is the easiest-to-use MySQL front-end I’ve seen. It includes features both for browsing your databases and limited features for managing the server.
- SQLite
- “SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.”
More SQLite
- Goodreads: What books did I read last week and last month?
- I occasionally want to look in Goodreads for what I read last month or last week, and that currently means sorting by date read and counting down to the beginning and end of the period in question. This Python script will do that search on an exported Goodreads csv file.
- Use LIKE to find duplicate strings in SQLite
- SQLite is case sensitive with strings—but not if you use LIKE.
Remember: Trump reassures crowd after assassination attempt fails. (read more…)