SQLite

This connector provides functionality for SQLite databases.

It is included in all distributions and does not need to be installed.

Adding a Database Instance

1. In the menu, click on Database Connections, then click the New button in the top right corner

   

2. Select the SQLite type from the database selection screen

   

3. Fill in the configuration details for your database, then click the Next button

   

4. Set the database ID and other options for your database connection, then click the Create button

   

Editing a Database Connection

To edit an existing database connection, go to the Database Connections list and click the Edit icon in the Actions column, or click on the database ID.

The edit form is divided into three sections: Connection, Configuration, Privileges

Connection

• Description - an optional description for the connection
• Type - the database vendor type
• Database Charset - the character set used for string types
• Database File Location - the file path of the database

Configuration

• Connect Automatically - automatically connect to the database whenever SlashDB starts

• Cache Schema - cache the database schema after the first connection so that subsequent connections complete faster

  Important

  Whenever your database structure changes, you will need to disable this option, disconnect/reconnect, and then enable it again. If your database structure changes frequently, you may want to disable it entirely.

• Auto Discover - automatically find all tables and views in your database whenever SlashDB connects

Privileges

• Connect / Disconnect DB - users with privileges to control the database connection
• View DB Config - users with privileges to view the database configuration
• Modify DB Config - users with privileges to edit or delete the database configuration