louwers/crsqlite-js

Components to build apps in JavaScript atop cr-sqlite

crsqlite-js

JavaScript packages to use cr-sqlite in the browser, node, react and other JS frameworks & environments.

Quickstart

Scaffolding a new project -- https://github.com/vlcn-io/vite-starter/tree/main

Example apps:

• Vite Starter over WebSocket
• Manual REST sync Example
• https://github.com/vlcn-io/live-examples
• Observable Notebook
• WIP Local-First Presentation Editor

Video overview

Browser

import initWasm from "@vlcn.io/crsqlite-wasm";
import wasmUrl from "@vlcn.io/crsqlite-wasm/crsqlite.wasm?url";

const crsqlite = await initWasm(wasmUrl);
const db = await sqlite.open("db-name");

...

db.close();

NodeJS

import Database from "better-sqlite3";

const db = new Database(":memory:");
import { extensionPath } from "@vlcn.io/crsqlite";
db.loadExtension(extensionPath);

...

db.close();

React

function TodoList() {
  const allTodos: readonly Todo[] = useQuery<Todo>(
    ctx,
    "SELECT * FROM todo ORDER BY id DESC"
  ).data;

  return (
    <div>
      {allTodos.map((t) => (
        <Todo item={t} />
      ))}
    </div>
  );
}

Sync

See official docs or the vite-starter

Packages

Storage

• crsqlite: The cr-sqlite loadable extension for use in NodeJS/Deno/Bun. Can be used with the SQLite bindings you currently use.
• crsqlite-wasm: WASM build of CR-SQLite & SQLite for use in the browser.

Sync

• client-websocket: Websocket client to sync the browser's database to a database hosted on a websocket server.
• server-websocket: Websocket server implementation.
• Websocket Demo
• HTTP GET & Server Sent Events: https://github.com/vlcn-io/vite-starter
• p2p: A peer to peer networking implementation, based on webrtc

UI

• react: React hooks for driving UI state from database queries

Other

• xplat-api: interfaces for components that can exist in NodeJS or the Browser.
• client-core: Networking code that is common across all client implementations
• client-server-common: Networking code that is common to the client and server
• server-core: Network code that is common across all server implementations
• node-allinone: convenience package for loading and using crsqlite in nodejs
  • Can also be used as a run time loadable extension in nodejs with whatever sqlite bindings you already use. See the node-allinone readme for more details
• tsbuild-all: convenient package for building all other packages

Integration Tests

• node-tests:
• xplat-tests:
• browser-tests:

Contributing

If you want to build these projects from source and/or hack on them or contribute, you'll need to clone the workspace repository:

git clone --recurse-submodules [email protected]:vlcn-io/workspace.git

Running make in that directory will get you set up. Ensure you have the rust nightly toolchain installed and activated before running make.