SQLGrinder and SQLite
(I posted this in the past to Musings, but now that SQLGrinder actually has a blog, I'm reposting it here for posterity.)
I just downloaded the latest version of the Zentus SQLite JDBC driver
, and I can say that once again, SQLGrinder has a good driver that can be used for your SQLite work.
Earlier versions of this driver allowed the use of the SQL editor, but now the schema browser works well too.
To use this driver, you just need to download the Mac OS X version, extract the archive, put the files sqlitejdbc-native.jar and libsqlitejdbc.jnilib in Library/Java/Extensions, and start up SQLGrinder. Finally, you just need to set the compatibility setting to JDBC 1 in Connection > Settings and set Autocommit to true. That should be it. Many thanks to David Crawshaw for his work on this.
For additional information, see this post as well: Using SQLite with SQLGrinder 2
SQLGrinder Updated to 2.0.5
Included in this maintenance release is a slight "refresh" of the UI, bringing it more inline with your typical "Tiger" application these days. The splitters in the editor, browser library and log windows have all been changed to the latest style, and grab handles have been added where appropriate.
Some of the fixes include the display of a class of error message that was only getting written to the Mac OS X console, instead of also being displayed in the application, better error display in general, and improved SQL syntax processing while editing and when first opening a file. For a full list of changes please see the release notes
Improve SQLGrinder Using Growl
Just a tip that can make SQLGrinder somewhat easier to use: because of SQLGrinder's Growl
support, it will display messages both when a query succeeds and when it fails. I've got my Growl settings configured so that query/update result information (SQL Info Messages) are displayed using Smoke, with a default priority. I display error messages (SQL Error Messages) using the Bubbles display style, and a high priority. I've changed Bubbles so that high priority messages are displayed with a red background. This gives me some heads up info when my issued SQL statements both succeed and when they fail.
Check out Growl