SQLGrinder News


SQLGrinder and Mac database news


Tuesday, April 17, 2007

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

1 Comments:

At May 16, 2007 9:28 AM, Anonymous Pedro said...

For those of you who, like me, spent an hour trying to figure out how to get this driver to work, it looks like Michael already specified some additional settings that should be adjusted. See his comment here.

 

Post a Comment

<< Home




For help or comments: sqlgrinder [at] advenio.com.