A SQLite database is represented as a single file with the extension .db. The database file can contain any number of tables.
To connect to or to create a SQLite database
Select SQLite Persistent from the Interface drop-down list.
Enter a new or existing file name for the SQLite database in the Host Name property. A new name will automatically create a new SQLite database file with an extension .db. Do not enter the extension .db when entering the name of an existing SQLite database.
For 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.