How to create a SQLite connection?

About

This howto shows you how to add a Sqlite connection.

Attributes

An sqlite connection supports :

all common connection attributes
- Uri,
- user,
- password
- …
and all relational connection attributes
- Driver (Jdbc Class)
- …

Note on file system

When creating a connection, you need to give the path to your Sqlite database file system in your URI. If you switch between file system in your execution environment, you can use a Operating system variable

Example

Here are the attributes of the howto connection

comment: The sqlite default connection
driver: org.sqlite.JDBC
uri: jdbc:sqlite:////home/tabulify/.tabul/sqlite.sqlite3

How to add

You can create a Sqlite connection,

directly in the configuration vault
or via the tabul command

Configuration Vault

In a Configuration Vault, to define a sqlite connection with the name mySqlite, you would write:

On Linux

connections:
  mySqlite:
    uri: jdbc\:sqlite\:////home/leo/work/mydatabase.db
    driver: org.sqlite.JDBC

On Windows

connections:
  mySqlite:
    url: jdbc\:sqlite\:///C\:/Users/user/AppData/Local/tabulify/sqlite.db
    driver: org.sqlite.JDBC

Tabul

With the tabul add command of the connection module, adding a Sqlite connection with the name sqliteConnectionName:

On Windows

tabul connection add "sqliteConnectionName" "jdbc:sqlite:C:/work/mydatabase.db"

On Linux

tabul connection add "sqliteConnectionName" "jdbc:sqlite:/home/leo/work/mydatabase.db"