Bun SQLite Key Value

A super fast key-value store with SQLite that uses bun:sqlite and v8 as a fast JSON replacement.

SQLite provides a solid and well-tested foundation. SQLite reliably takes care of saving and reading data - both for short strings and for larger BLOBs. It provides a robust foundation on which to build. Even if SQLite is not fully utilized and no relations between tables are required, this is not a disadvantage.

Bun's lightning-fast SQLite implementation makes Bun-SQLite-Key-Value perfect for a fast storage and cache solution with TTL support. You need Bun to be able to use this package.

Please give this GitHub project a ⭐ if this project is useful to you. Thank you very much! And if you speak German, here is my business homepage: GP-Softwaretechnik Maybe you will find something interesting for you there. 😃

The ideas for the implementation come from bun-sqlite-cache and bun-kv. Thank you very much!

Installation

bun add bun-sqlite-key-value

Usage

Using this key value store is dead simple: simply create a new BunSqliteKeyValue instance and you're set

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

store.set("my-key", [1, 2, 3, 4])

const value = store.get("my-key")

console.log(value)  // -> [ 1, 2, 3, 4 ]

Open Database

const store = new BunSqliteKeyValue(filename?, options?)

Opens and creates the SQLite database either in memory or on the file system.

filename (optional)

The full path of the SQLite database to open. Pass an empty string ("") or ":memory:" or undefined for an in-memory database.

options (optional)

readonly?: boolean: Open the database as read-only (default: false).

create?: boolean: Allow creating a new database (default: true)

readwrite?: boolean: Open the database as read-write (default: true)

ttlMs?: boolean: Standard time period in milliseconds before an entry written to the DB becomes invalid.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

// In-memory
const store1 = new BunSqliteKeyValue()
// In-memory with 30 seconds default expiration timeout
const store2 = new BunSqliteKeyValue(undefined, {ttlMs: 30000})
// Store items in file system
const store3 = new BunSqliteKeyValue("./store3.sqlite")

Write Value

set(key: string, value: any, ttlMs?: number)

Writes a value into the database.

key

The key must be a string.

value

The value can be any object that can be serialized with v8. This means that not only simple data types (string, number) are possible, but also more complex types such as sets or maps. You can find a list of the supported data types here.

ttlMs (optional)

"Time to live" in milliseconds. After this time, the item becomes invalid and is deleted from the database the next time it is accessed or when the application is started. Set the value to 0 if you want to explicitly deactivate the process.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

// Stays in database
store.set("my-key", "my-value")

// Becomes invalid after 30 seconds
store.set("my-key-2", "item-with-ttl", 30000)

Write Multiple Items

setItems(items: {key: string, value: T, ttlMs?: number}[]) {

Adds a large number of items to the database and takes only a small fraction of the time that set() would take individually.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

// Add many records
store.setItems([
    {key: "a:1", value: "test-value-1"},
    {key: "a:2", value: "test-value-2"},
])

Read Value

get(key: string): any

Reads a value from the database.

key

The key must be a string.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()
store.set("my-key", "my-value")

const value = store.get("my-key")
console.log(value)  // --> "my-value"

Read Item

Reads the key and the value from the database.

getItem(key: string): {key: string, value: any}

key

The key must be a string.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()
store.set("my-key", "my-value")

const item = store.getItem("my-key")
console.log(item)  // --> {key: "my-key", value: "my-value"}

Read Values

getValues(startsWithOrKeys: string | string[]): any[]

Reads the data from the database and returns an array with the values.

startsWithOrKeys

string: Returns all values in an array whose keys begin with the passed string. If you plan the names of the keys well, more complex data can be stored. It is advisable to divide keys into ranges using separators. For example "language:de", "language:en", "language:it". A search for "language:" would return all languages.

string[]: Array with keys. The returned array is exactly the same size as the passed array. Entries that are not found are returned as undefined. Only exact matches with the keys are returned.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

store.set("language:de", "German")
store.set("language:en", "English")
store.set("language:it", "Italian")

const values = store.getValues("language:")
console.log(values)  // --> [ "German", "English", "Italian" ]

Read Items

getItems(startsWithOrKeys: string | string[]): {key: string, value: any}[]

Reads the data from the database and returns entries in an array as key-value pairs.

startsWithOrKeys

string: Returns all items (key, value) in an array whose keys begin with the passed string. If you plan the names of the keys well, more complex data can be stored. It is advisable to divide keys into ranges using separators. For example "language:de", "language:en", "language:it". A search for "language:" would return all languages.

string[]: Array with keys. The returned array is exactly the same size as the passed array. Entries that are not found are returned as undefined. Only exact matches with the keys are returned.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

store.set("language:de", "German")
store.set("language:en", "English")
store.set("language:it", "Italian")

const items = store.getItems("language:")
console.log(items)
// --> [
//     {key: "language:de", value: "German"},
//     {key: "language:en", value: "English"},
//     {key: "language:it", value: "Italian"}
// ]

Multiple Databases

It is no problem at all to use several databases and access them at the same time.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"
import { join } from "node:path"
import { exists, mkdir } from "node:fs/promises"


const dbDir = join(__dirname, "databases")
if (!(await exists(dbDir))) {
    await mkdir(dbDir)
}

const settingsPath = join(dbDir, "settings.sqlite")
const languagesPath = join(dbDir, "languages.sqlite")

const settingsStore = new BunSqliteKeyValue(settingsPath)
const languagesStore = new BunSqliteKeyValue(languagesPath)

// Write settings
settingsStore.set("language", "de")
settingsStore.set("page-size", "A4")
settingsStore.set("screen-position", {top: 100, left: 100})

// Write languages
languagesStore.set("de", "German")
languagesStore.set("en", "English")
languagesStore.set("it", "Italian")

// Read all settings
const settingItems = settingsStore.getItems()
console.log(settingItems)
// -> [
//   {key: "language", value: "de"},
//   {key: "page-size", value: "A4"},
//   {key: "screen-position", value: {top: 100, left: 100}},
// ]

// Read all languages
const languageValues = languagesStore.getValues()
console.log(languageValues)  // -> [ "German", "English", "Italian" ]

// Read current language
const languageKey = settingsStore.get("language")
const currentLanguage = languagesStore.get(languageKey)
console.log(`Current language: "${currentLanguage}"`)  // -> Current language: "German"

// Explicitly close DBs
settingsStore.close()
languagesStore.close()

Read and Write Binary Files (Images)

SQLite has no problem with images and other binaries. The maximum size of a binary file in SQLite is 2 GB.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

// Read file from filesystem
const sourceFile = Bun.file("<Source File Path>")

// Write ArrayBuffer into database (async !!!)
store.set("my-image", await sourceFile.arrayBuffer())

// Read ArrayBuffer from database
const targetArrayBuffer = store.get("my-image")

// Write target file to filesystem (async !!!)
await Bun.write(Bun.file("<Target File Path>"), targetArrayBuffer)

Cache Values with TTL

You can specify a caching period when you open the database. This period in milliseconds is then added with each write. If you read the value within this period, the value is returned. If the value is read after this period, undefined is returned.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue(undefined, {ttlMs: 1000})

const KEY = "cache-key"
store.set(KEY, 12345)
await Bun.sleep(500)
console.log(store.get(KEY))  // --> 12345
await Bun.sleep(1000)
console.log(store.get(KEY))  // --> undefined

Has (key)

has(key: string): boolean

Checks if key exists. Returns false if the item is expired.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

store.has("my-key") --> false

Read Keys

getKeys(startsWithOrKeys: string | string[]): string[]

Reads the keys from the database and returns an array.

startsWithOrKeys

string: Returns an array with the keys that begin with the passed string. If you plan the names of the keys well, more complex data can be stored. It is advisable to divide keys into ranges using separators. For example "language:de", "language:en", "language:it". A search for "language:" would return all languages.

string[]: Array with keys. Only exact matches with the keys are returned.

Example

import { BunSqliteKeyValue } from "bun-sqlite-key-value"

const store = new BunSqliteKeyValue()

store.set("language:de", "German")
store.set("language:en", "English")
store.set("language:es", "Esperanto")

let keys

keys = store.getKeys()
console.log(keys)  // --> ["language:de", "language:en", "language:es"]

keys = store.getKeys("language:e")
console.log(keys)  // --> ["language:en", "language:es"]

keys = store.getKeys(["language:de", "language:fr"])
console.log(keys)  // --> ["language:de"]

All Methods

Database

• new BunSqliteKeyValue() --> Open database
• close() --> Close database

Set value

• set(key: string, value: any)
• setValue(key: string, value: any) --> alias for set()

Set items

• setItems({key: string, value: any}[])

Get value

• get(key: string)
• getValue(key: string) --> alias for get()

Get item

• getItem(key: string) --> Object

Get items as Array

• getItems() --> Array with all items
• getItems(startsWith: string) --> Array
• getItems(keys: string[]) --> Array
• getItemsArray() --> alias for getItems()
• getItemsArray(startsWith: string) --> alias for getItems()
• getItemsArray(keys: string[]) --> alias for getItems()

Get items as Object

• getItemsObject() --> Object with all items
• getItemsObject(startsWith: string) --> Object
• getItemsObject(keys: string[]) --> Object

Get items as Map()

• getItemsMap() --> Map with all items
• getItemsMap(startsWith: string) --> Map
• getItemsMap(keys: string[]) --> Map

Get values as Array

• getValues() --> Array with all values
• getValues(startsWith: string) --> Array
• getValues(keys: string[]) --> Array
• getValuesArray() --> alias for getValues()
• getValuesArray(startsWith: string) --> alias for getValues()
• getValuesArray(keys: string[]) --> alias for getValues()

Get values as Set()

• getValuesSet() --> Set with all values
• getValuesSet(startsWith: string) --> Set
• getValuesSet(keys: string[]) --> Set

Delete

• clear() --> Delete all items
• delete(key: string) --> Delete item
• delete(keys: string[]) --> Delete items

Count

• getCount() --> Number
• length --> alias for getCount()

Get keys

• has(key: string) --> Boolean
• getKeys() --> Array with all Keys
• getKeys(startsWith: string) --> Array
• getKeys(keys: string[]) --> Array