nalgeon/sqlite-wasi — explained in plain English
Analysis updated 2026-08-10 · repo last pushed 2024-01-03
Build an online SQL tutorial that lets users practice queries entirely in the browser.
Create a data-focused web app that runs complex SQL queries on local data without a backend.
Prototype database-driven features in a static website with zero server setup.
| nalgeon/sqlite-wasi | bodmer/png_test_only | danterolle/tund | |
|---|---|---|---|
| Stars | 9 | 9 | 9 |
| Language | C | C | C |
| Last pushed | 2024-01-03 | 2024-08-19 | — |
| Maintenance | Dormant | Stale | — |
| Setup difficulty | easy | hard | moderate |
| Complexity | 2/5 | 4/5 | 3/5 |
| Audience | developer | developer | developer |
Figures from each repo's GitHub metadata at analysis time.
No file I/O means all data lives in memory for the session only, cannot persist to disk.
This repo lets you run SQLite, the popular database engine, directly inside a web browser or any JavaScript environment, no installation required. It packages SQLite as a single file you can load over the web and interact with programmatically. At a technical level, the project takes the standard SQLite shell (version 3.44) and compiles it into WebAssembly using a toolchain called WASI. WebAssembly is a format that lets code written in languages like C run efficiently in browsers and other environments. Once you load the compiled file, you can run SQLite commands and read the output through JavaScript callbacks. The README shows an example using the Runno runtime, where you start SQLite, pass it arguments like you would on a command line, and receive the results through functions you define. This would be useful for developers building interactive web pages that need a real SQL database without relying on a backend server. For example, an online SQL tutorial could let users practice queries entirely in the browser, or a data-focused web app could run complex queries on data it already has locally. It brings the full power of SQLite's query engine to environments where installing software isn't possible. The project has some limitations worth noting. There is no file I/O support, meaning SQLite cannot read from or write to files on disk, everything happens in memory within the session. A couple of internal commands that interact with the operating system, like .shell and .system, are also disabled, which makes sense given the sandboxed nature of browser environments. The project is MIT licensed, while SQLite itself is in the public domain.
A single-file WebAssembly build of SQLite that runs entirely in the browser or any JavaScript environment, letting you execute real SQL queries with no installation or backend server required.
Mainly C. The stack also includes C, WebAssembly, WASI.
Dormant — no commits in 2+ years (last push 2024-01-03).
Use freely for any purpose, including commercial use, as long as you keep the copyright notice.
Setup difficulty is rated easy, with roughly 5min to a first successful run.
Mainly developer.
This repo across BitVibe Labs
Don't trust strangers blindly. Verify against the repo.