SQLite Connection Help
RazorSQL ships with a JDBC driver that can be used to connect to SQLite. This is the recommended way to connect to SQLite. When connecting to SQLite via JDBC, RazorSQL needs to know whether to connect to an existing SQLite database file or whether the connection is for a new SQLite database. If using an existing SQLite database, the location of the SQLite database file needs set in the Database File field. If connecting to a new SQLite database, the location / name of the new database file that should be created needs entered in the Database File field.
RazorSQL provides a custom SQLite driver that can communicate with SQLite via the SQLite command line program. This connection method is no longer recommended, but is included for legacy support. RazorSQL for Windows ships with the SQLite command line program, and SQLite is included on macOS / Mac OS X in the /usr/bin directory. For Linux systems, to use the RazorSQL SQLite driver, the SQLite command line program must first be installed. See www.sqlite.org to obtain SQLite for Linux.
Connecting to SQLite with the RazorSQL SQLite Driver
To connect to SQLite using the RazorSQL SQLite driver, open the connection wizard and select SQLite as the database type and RazorSQL SQLite Driver as the connection type. For Windows and Mac machines, the path to the SQLite command line program should be automatically populated. For Linux machines, use the browse button to navigate to the SQLite command line program.
Next, choose whether to connect to an existing database file, or to have RazorSQL create a new SQLite database file. Enter the name of the existing or new file in the Database File field.
Connecting to SQLite via JDBC
RazorSQL can also connect to SQLite via JDBC. To do this, an SQLite JDBC driver needs to be downloaded. To connect, in the connection wizard, select SQLite as the database type and JDBC as the connection type. See the documentation for the JDBC driver for the Driver Class and JDBC URL.
