Skip to content

SQLite

SQLite is a powerful, lightweight, and embedded database management system that has been around for over 20 years. It's a great choice for a wide range of applications, from mobile apps and embedded systems to desktop software and web applications.

Unlike traditional database management systems that require a separate server process, SQLite is self-contained and serverless. This means that the entire database is stored in a single file on the local file system, making it incredibly easy to set up and use.

SQLite parameters

Required parameters are in red and Optional parameters are in blue.


  • database_path, the full path to a sqlite database
    this filepath may not yet exist, but it must end in .db

  • load_strategy, how to write new data into existing tables
    default: APPEND ( allowed: APPEND, TRUNCATE, UPSERT )
How do I use the SQLite syncer in commands?

cs_tools tools searchable bi-server --syncer sqlite://database_path=data.db

- or -

cs_tools tools searchable bi-server --syncer sqlite://definition.toml

Definition TOML Example

definition.toml

[configuration]
database_path = '...'
load_strategy = 'truncate'