Synor Database SQLite

Synor Database Engine - SQLite

Installation

# using yarn:
yarn add @synor/database-sqlite better-sqlite3

# using npm:
npm install --save @synor/database-sqlite better-sqlite3

URI

Format: sqlite://[.]/path[?param=value&...]

Params:

Name	Description	Default Value
schema	SQLite Schema name	main
synor_migration_record_table	Name for Migration Record Table	synor_migration_record
file_must_exist	Error will be thrown if the database file does not exist	false
memory	Open an in-memory database, rather than a disk-bound one	false
readonly	Open the database connection in readonly mode	false
timeout	Number of milliseconds to wait before throwing a SQLITE_BUSY error	5000

Examples:

• sqlite:///path/to/sqlite.db (Absolute path)
• sqlite://./path/to/sqlite.db (Relative path)
• sqlite://?memory=true (Open an in-memory database)

License

Licensed under the MIT License. Check the LICENSE file for details.