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.