Update 2009-05-31
Thank you to everyone who has contacted me. I’ve got enough testers for now, but will post again next time more are needed.
Base 1.3 is nearing completion and is in need of testing. I’m looking for half a dozen people (or thereabouts) to try it out and give some feedback.
This release is focused on editing table schemas, so ideally testers should be willing to:
1. Try some real-world table altering tasks
2. Try to make the table editor break. Feed it malformed inputs. Make it stutter and fail non-gracefully.
3. Explain in a sensible way how it broke and/or didn’t behave as you would expect or hope.
If you would like to be involved, get in touch via the contact form on this site with your name and a few details about what you use Base for (eg. web developer, mac coder or whatever) and I’ll get back to you within a day or so with more details.
Well, Base 1.2 has been out for just over a week now, so I figured it’s time for an update.
So far, the app seems to have had a pretty good reception. Thank you to everyone who has taken the time to contact me with feedback (especially those who have sent detailed bug reports). For the most part, complaints and requests have centered around one area: the editing of existing tables.
The plan was to not add in table editing for the first couple of releases, simply because SQLite does not implement full ALTER TABLE support (see ALTER TABLE reference and SQLite omitted features). Instead, I wanted to get the app to a point where it was supporting what most people would call the ‘standard’ SQLite features, before going to work around it’s limitations.
Now that Base has reached that point, I will be working on getting the editing features into the application, and will post again when these features begin to take shape.
Now that the Christmas / new year festivities are out of the way it’s time for an update on how Base development is coming along. The next release – version 1.2 – will have some useful changes being made, though there isn’t a predicted release date yet. The three things I’d like to pick up on are:
- Saving of column widths in the data browser
- Support for SQL views and triggers
- Syntax highlighting
In the data browser, just saving column widths would be useful, but not terribly so. To use a not-too-contrived example, two columns named ‘last_updated’ would have the same width even if the data they stored was different (eg, a Unix timestamp vs. a full ISO date - 123083964 vs. 2009-01-01 19:54:01 +0000). Instead column widths will be stored on a per-table basis, so that our two columns named ‘last_updated’ can have different widths in different tables.
Support for views and triggers doesn’t really need explaining, so heres a gratuitous screenshot:
Syntax highlighting is also pretty much self explanatory. The colours for various elements of SQL (keywords, functions, comments etc) can all be set in the app preferences. Again here’s a screenshot:
As a side note, I may be going away for a few days during this week, so please don’t panic if you don’t get a response to any emails immediately.
I’m pleased to announce that the first public application from Menial has been released. Base is an SQLite 3 database reader/editor for Mac OS X and more details can be found at it’s product page.
17th November, 2008:
Unfortunately there was a problem that slipped through testing before release. When a license file was opened, the app would not register that license. To fix this, just re-download the app from this page and double-click your license file again.
