Skip to content

Instantly share code, notes, and snippets.

@Ciantic

Ciantic/sqlite3.html

Last active November 11, 2024 17:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Ciantic/1a94479f8974328b48ed70948abaa2df to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Ciantic/1a94479f8974328b48ed70948abaa2df to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Ciantic revised this gist Jul 1, 2023. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions sqlite3.html
    View file
    Original file line number Diff line number Diff line change
    @@ -12,6 +12,7 @@
    import sqlite3InitModule from "https://cdn.jsdelivr.net/npm/@sqlite.org/[email protected]/sqlite-wasm/jswasm/sqlite3-bundler-friendly.mjs";

    const sqlite3 = await sqlite3InitModule({
    // These three rows aren't necessary, I just wanted to try can I give URL to the wasm file, and I can
    locateFile: (file) => {
    return "https://cdn.jsdelivr.net/npm/@sqlite.org/[email protected]/sqlite-wasm/jswasm/sqlite3.wasm";
    },
  2. Ciantic created this gist Jul 1, 2023.
    48 changes: 48 additions & 0 deletions sqlite3.html
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,48 @@
    <!DOCTYPE html>
    <html lang="en">
    <head>
    <meta charset="UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Document</title>
    </head>
    <body>
    LOOK AT THE CONSOLE
    <script type="module">
    import sqlite3InitModule from "https://cdn.jsdelivr.net/npm/@sqlite.org/[email protected]/sqlite-wasm/jswasm/sqlite3-bundler-friendly.mjs";

    const sqlite3 = await sqlite3InitModule({
    locateFile: (file) => {
    return "https://cdn.jsdelivr.net/npm/@sqlite.org/[email protected]/sqlite-wasm/jswasm/sqlite3.wasm";
    },
    });

    // SQLite's C API
    const capi = sqlite3.capi;
    console.log("sqlite3 version", capi.sqlite3_libversion(), capi.sqlite3_sourceid());

    // OO API example below oo1 docs https://sqlite.org/wasm/doc/tip/api-oo1.md
    const oo = sqlite3.oo1;

    const db = new oo.DB();
    const createPersonTableSql = `
    CREATE TABLE IF NOT EXISTS person (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    age INTEGER NOT NULL
    );
    `;

    const insertPerson1Sql = `
    INSERT INTO person (name, age) VALUES ('Alice', 42);
    `;
    const insertPerson2Sql = `
    INSERT INTO person (name, age) VALUES ('Bob', 42);
    `;

    db.exec([createPersonTableSql, insertPerson1Sql, insertPerson2Sql]);
    const res = db.selectArrays("select * from person");
    console.log(db, res);
    </script>
    </body>
    </html>