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

2 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.

 
At August 27, 2008 10:26 AM, Anonymous Nate said...

This worked. The directions in the User Guide (and on the "for additional information" page) do not work!

I almost didn't buy SQLGrinder because it didn't appear to support SQLite. I only found this page using a Google search. You guys really ought to bundle the SQLite driver or update the instructions in the User Guide. The Zentus driver is BSD licensed, so there's nothing stopping you from bundling it with SQLGrinder.

 

Post a Comment

<< Home




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