SQLiteConnectionParameters

@webda/sqlite

---

Interface: SQLiteConnectionParameters

Defined in: sqlite/src/connection.ts:29

Connection parameters shared by SQLiteStore, SQLiteQueue and SQLitePubSub

Properties

busyTimeout?

optional busyTimeout?: number

Defined in: sqlite/src/connection.ts:45

PRAGMA busy_timeout in ms

Default

5000

---

database?

optional database?: SQLDatabase

Defined in: sqlite/src/connection.ts:40

Services giving the same database name share one handle: one file, or one in-memory database inside the process (e.g. store + queue + pubsub in a test)

Default

{ name: <service name> } in memory, { name: <resolved path> } with persistence

---

persistence?

optional persistence?: SQLitePersistence

Defined in: sqlite/src/connection.ts:34

Omitted: in-memory database, lost on stop() (like MemoryStore without persistence) Set: file database, every committed write is durable

---

pragmas?

optional pragmas?: Record<string, string | number>

Defined in: sqlite/src/connection.ts:49

Extra PRAGMAs run on open, e.g. { cache_size: -64000 }