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.
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 via Included JDBC Driver
To connect to SQLite using the included JDBC driver, the following information
is required:
Connection Profile Name: This is the name of the connection
and will be displayed in the connection wizard screen.
Database File: If connecting to an existing SQLite database,
click the Browse button to select the database file. If creating a new
SQLite database, click the "Create New Database" radio button and browse
to select a new file for the database.
Connecting to SQLite using a non-included JDBC driver
To connect to SQLite manually using a JDBC driver, the JDBC driver class name,
the JDBC driver jar file location, and the JDBC URL are needed. The following is example values if using
the Xerial SQLite JDBC driver:
Driver Class: org.sqlite.JDBC
Driver Location: C:\Users\files\sqlite-jdbc.jar
JDBC URL: jdbc:sqlite:C:\Users\files\test.db
Connecting to SQLite with the Legacy RazorSQL SQLite Driver
This is a legacy connection option and is not recommended. 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.
