Type Alias: LixKeyValue
LixKeyValue =
FromLixSchemaDefinition<typeofLixKeyValueSchema> & {value:any; }
Represents a key-value pair in Lix.
The value can be any JSON-serializable type (string, number, boolean, object, array, null).
Important SQLite Limitation with Boolean Values: SQLite does not have a native boolean type. When storing JSON values:
trueis stored as1falseis stored as0
This is a fundamental limitation of SQLite's JSON implementation. There is no way
to distinguish between a boolean true and the number 1 after retrieval.
When querying boolean values, use loose equality (==) or handle the numeric representation.
Examples
await lix.db.insertInto("key_value").values({
key: "lix_sync_enabled",
value: true // Will be stored as 1 in SQLite
}).execute();
await lix.db.insertInto("key_value").values({
key: "lix_server_url",
value: "https://api.example.com"
}).execute();const result = await lix.db
.selectFrom("key_value")
.where("key", "=", "lix_sync_enabled")
.select("value")
.executeTakeFirst();
// result.value will be 1 (not true)
const isEnabled = result?.value == true; // Use loose equality
const isEnabled = result?.value === 1; // Or compare numeric value// Common Lix system keys
// "lix_id" - Unique identifier for the Lix instance
// "lix_name" - Human-readable name for the Lix instance
// "lix_server_url" - URL of the sync server
// "lix_deterministic_mode" - Boolean flag for deterministic ID generation
// "lix_telemetry" - Telemetry setting ("on" or "off")Type Declaration
value
value:
any