Library: SQLite

Observable Framework documentation: Library: SQLite Source: https://observablehq.com/framework/lib-sqlite

SQLite is “a small, fast, self-contained, high-reliability, full-featured, SQL database engine” and “the most used database engine in the world.” Observable provides a ESM-compatible distribution of sql.js, a WASM-based distribution of SQLite. It is available by default as SQLite in Markdown, but you can import it like so:

import SQLite from "npm:@observablehq/sqlite";

If you prefer to use sql.js directly, you can import and initialize it like so:

import initSqlJs from "npm:sql.js";

const SQLite = await initSqlJs({locateFile: (name) => import.meta.resolve("npm:sql.js/dist/") + name});