Posts Tagged ‘sqlite’

Squirrel SQL Client and SQLite Databases

Dienstag, Dezember 31st, 2013

Working with RubyOnRails i use sqlite in development.

In my dev-environment (windows) i used to use SQLiteBrowser to look into the DB. But the usability was not what i was used to.

So i tried to get Squirrel SQL Client to work with SQLite and had my problems integrating the two together.


Because i googled and googled and did not find a working answer.

In the end it was easy.

  1. Download Squirrel SQL Client
  2. Get this jdbc-Adapter for SQLite:
  3. Throw the lib in the lib-Directory of SQuirrel
  4. Startup Squirrel
  5. Create new Driver
    1. Name: SQLite
    2. Example-Url: jdbc:sqlite:<PATH>/mydatabase.db
    3. Website-Url:
    4. Class-Name: org.sqlite.JDBC
  6. Add Alises for your DB and connect to them