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 the 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. 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.

For example, to create a new SQLite database file called mySQLite.db, or to connect to an existing mySQLite.db database file, use these parameters:

• Interface: SQLite Persistent

• Host Name: mySQLite