Connecting to a SQLite database

A SQLite database is represented as a single file with the .db extension. The database file can contain any number of tables.

1. In the Properties window, select SQLite Persistent from the Interface menu.

2. Provide the host name for the SQLite database file.

   • To create a new SQLite database file, provide a name in the Host Name field; do not include the .db extension. A new SQLite database file with an extension .db, is automatically created in the default location, which is the database directory under the installation folder.

     To create the SQLite database file in a directory other than the default, specify the complete path, including the .db extension, in the Host Name field.

   • If you are connecting to an existing SQLite database file in the default directory, select the file name from the Host Name menu. Do not enter the .db extension. If you want to connect to a SQLite database file in a directory other than the default, specify the complete path, including the .db extension, in the Host Name field.

Example – to create a new SQLite database file mySQLite.db or to connect to an existing mySQLite.db database file:

• Interface: SQLite Persistent

• Host Name: mySQLite

The database file created is named mySQLite.db.