Skip to content

SqliteDbWrapper

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:33

This class is mostly adding result caching around a SqliteDb which is used to speed up SQLite queries when used through the reactivity graph.

new SqliteDbWrapper(__namedParameters): SqliteDbWrapper

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:45

SqliteDb

{ rootSpanContext: Context; tracer: Tracer; }

Context

Tracer

SqliteDbWrapper

_tag: "SqliteDb"

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:34

SqliteDb._tag


debugInfo: object

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:43

events: BoundArray<readonly [string, any]>

queryFrameCount: number

queryFrameDuration: number

slowQueries: BoundArray<{ bindValues: any; durationMs: number; queriedTables: ReadonlySet<string>; queryStr: string; rowsCount: undefined | number; startTimePerfNow: number; }>


execute: {(queryStr, bindValues?, options?): void; (queryBuilder, options?): void; }

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:227

(queryStr, bindValues?, options?): void

string

PreparedBindValues

(rowsChanged) => void

void

(queryBuilder, options?): void

Any

(rowsChanged) => void

void

SqliteDb.execute


select: {<T>(queryStr, bindValues?): readonly T[]; <T>(queryBuilder): T; }

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:229

<T>(queryStr, bindValues?): readonly T[]

T

string

PreparedBindValues

readonly T[]

<T>(queryBuilder): T

T

QueryBuilder<T, any, any>

T

SqliteDb.select

get debug(): SqliteDebugInfo

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:67

Debug information (currently not persisted and only available at runtime)

SqliteDebugInfo

Debug information (currently not persisted and only available at runtime)

SqliteDb.debug


get metadata(): any

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:70

any

SqliteDb.metadata

cachedExecute(queryStr, bindValues?, options?): object

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:162

string

PreparedBindValues

boolean

(rowsChanged) => void

Context

ReadonlySet<string>

object

durationMs: number


cachedSelect<T>(queryStr, bindValues?, options?): readonly T[]

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:231

T = any

string

PreparedBindValues

Context

ReadonlySet<string>

boolean

readonly T[]


close(): void

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:79

void

SqliteDb.close


destroy(): void

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:82

void

SqliteDb.destroy


export(): Uint8Array<ArrayBufferLike>

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:302

Uint8Array<ArrayBufferLike>

SqliteDb.export


getTablesUsed(query): Set<string>

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:134

string

Set<string>


import(data): void

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:76

Uint8Array<ArrayBufferLike> | SqliteDb<any, any>

void

SqliteDb.import


makeChangeset(data): SqliteDbChangeset

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:88

Uint8Array

SqliteDbChangeset

SqliteDb.makeChangeset


prepare(queryStr): PreparedStatement

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:73

string

PreparedStatement

SqliteDb.prepare


rollback(changeset): void

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:129

Uint8Array

void


session(): SqliteDbSession

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:85

SqliteDbSession

SqliteDb.session


txn<TRes>(callback): TRes

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:92

TRes

() => TRes

TRes


withChangeset<TRes>(callback): object

Defined in: packages/@livestore/livestore/src/SqliteDbWrapper.ts:113

TRes

() => TRes

object

changeset: { _tag: "sessionChangeset"; data: Uint8Array; debug: any; } | { _tag: "no-op"; }

result: TRes