Simple utilities for storing email data in SQLite on Val Town.

Creates a table with the following schema:

• id - INTEGER PRIMARY KEY
• timestamp - INTEGER NOT NULL (Unix timestamp)
• data - TEXT NOT NULL (JSON string)

Inserts an email object into the specified table with the current timestamp.

Create val
import { createTable, insertEmail } from "./sqlite.ts";

// Create table
await createTable("my_emails");

// Insert email data
await insertEmail("my_emails", emailObject);

• Val Town SQLite standard library
• Email objects must be JSON serializable