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