Table of Contents

About

This howto shows you how to add a Sqlite connection.

Attributes

An sqlite connection supports :

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"