Skip to content

Experimenting with SQLite WASM running with SQLDelight

License

Notifications You must be signed in to change notification settings

dellisd/sqldelight-sqlite-wasm

Repository files navigation

sqldelight-sqlite-wasm

This is a proof-of-concept showing SQLDelight running with the SQLite project's WebAssembly build.

This project uses the Origin-Private FileSystem storage method to persist the database.

Demo

https://dellisd.github.io/sqldelight-sqlite-wasm

Build Requirements

This repository is set up to build as-is right away, however it does a couple of special things.

  1. This project currently uses SNAPSHOT builds of SQLDelight.
  2. SQLite's WebAssembly builds are not distributed through NPM, so a couple of custom tasks are set up in build.gradle.kts to download and extract the required static resources.

Using the sqlite-wasm driver

Copy the sqlite.worker.js file.

In code, load the SQLDelight worker driver with this worker script.

val worker = Worker(js("""new URL("sqlite.worker.js", import.meta.url)""").unsafeCast<String>())
val driver: SqlDriver = WebWorkerDriver(worker)

// Use your driver!
Database.Schema.awaitCreate(driver)

Make sure that you've also followed the build requirements section to ensure that the static sqlite-wasm files are also in your project's resources.

About

Experimenting with SQLite WASM running with SQLDelight

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published