Usage

Val Town SQLite has two methods: execute ↗ and batch ↗. Below are examples of how to use them in Val Town.

Simple query

import { sqlite } from "https://esm.town/v/std/sqlite";

const data = await sqlite.execute("SELECT datetime();");
console.log(data.rows[0]);

Run in Val Town

Create a table

import { sqlite } from "https://esm.town/v/std/sqlite";

sqlite.execute(`create table if not exists kv(
  key text unique,
  value text
)`);

Run in Val Town

Get data

import { sqlite } from "https://esm.town/v/std/sqlite";

console.log(await sqlite.execute(`select key, value from kv`));

Run in Val Town

Insert data

import { sqlite } from "https://esm.town/v/std/sqlite";

sqlite.execute({
  sql: `insert into kv(key, value) values (:key, :value)`,
  args: { key: "specialkey", value: "specialvalue" },
});

Run in Val Town

Delete data

import { sqlite } from "https://esm.town/v/std/sqlite";

sqlite.execute({
  sql: `delete from kv where key = :key`,
  args: { key: "specialkey" },
});

Run in Val Town

Batch queries

import { sqlite } from "https://esm.town/v/std/sqlite";

const charge = 10;

export const batchSqlite = await sqlite.batch([
  `create table if not exists accounts(person_id text unique, balance integer)`,
  {
    sql: `update accounts set balance = balance - :charge where person_id = 'Bob'`,
    args: { charge },
  },
  {
    sql: `update accounts set balance = balance + :charge where person_id = 'Alice'`,
    args: { charge },
  },
]);

Run in Val Town