How do I create a SQLite database resource when SQLite does not connect through a IP address or port number?
Unlike typical server/client databases, SQLite directly reads and writes its data to a single, ordinary disk file. In order to make a "connection" to a SQLite database, download the JDBC driver. I chose to use the one found on BitBucket (https://bitbucket.org/xerial/sqlite-jdbc
In the JDBC driver section of the Database resource, please input org.sqlite.JDBC
Due to the fact SQLite is a ordinary file, the JDBC URL points to the database file location. The database URL will always take on the following format jdbc:sqlite:database_file_location
. On Windows, the default location of the database file is not in the SQLite install directory, but instead the user's AppData directory.
You will not need to input a User and Password.
See the screen shot below of a working SQLite resource.
From here, you can use your SQLite database resource in a project and query the SQLite Database just as you could any normal database.