Wednesday, February 9, 2011

Wandering Around SQLite Database

It may be useful (take my word for it) to be able to directly examine the contents of your SQLite database as it grows with data for our RADAR application. Further, it may be useful to be able to directly manipulate the contents of said database, for example, adding records and establishing explicit associations.

For such purposes, may I recommend SQLExplorer plug-in for Eclipse coupled with SQLite JDBC driver. The latter you can find at \\csfile\software\sqlite\sqlitejdbc-v056.jar.

Big Picture:
  1. Install SQLExplorer plug-in
  2. Drop driver jar into your Eclipse plugin directory
  3. Configure SQLExplorer to see SQLite driver

For the last step I can help if anyone is interested. I am not going to go through trouble explaining it if I have no customers.

No comments:

Post a Comment