Wednesday | 28 FEB 2024
[ previous ]
[ next ]

Using SQLite in the Browser

Date: 2023-01-20
Tags:  cheatsheet

Easy peasy instructions to get sqlite working in the browser.

First step download the following 3 files, the wasm binary and the wrappers:


If you feel uncomfortable downloading random binaries from random people, then you can use the instructions below to build it yourself. The building is relatively straightforward and doesn't take long.

Now that we have the library, we can then include the sql-httpvfs.js as a module and use it with our sqlite database.

<!DOCTYPE html>
<html lang="en">
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1" />
    <script type="module">
      import { load } from "/js/sqlite/sql-httpvfs.js";

      const worker = await load("/db/example.sqlite3");

      const result = await worker.db.query(`select * from mytable`);