SQuirreL

Info

• cross-platform universal sql client

Pointers

• http://squirrel-sql.sourceforge.net/
• DataBase
• UnixGeekTools - other great tools for unix geeks

Installing

Uses izpack Java installer.

    java -jar squirrel-sql-<version>-install.jar

Add SQLite support

• SQLite
• add driver

          name: SQLite.JDBCDriver
          example url: jdbc:sqlite://dirA/dirB/dbfile
          class name: SQLite.JDBCDriver

Add MySQL support

• MySQL
• download from http://www.mysql.com/downloads/api-jdbc-stable.html
• tunnel connection over ssh: ssh -L3306:localhost:3306 -N bebop

        class name: org.gjt.mm.mysql.Driver
        example url: jdbc:mysql:<//host>:<port>/<database>