db
Embedded SQL database (SQLite-style) for persistent local storage.
Import
import dbFunctions
db.open(path: str) -> connection
Open a database file at the given path, creating it if it doesn't exist.
db.exec(sql: str)
Execute a SQL statement that doesn't return rows (CREATE, INSERT, UPDATE, DELETE).
db.query(sql: str) -> [[any]]
Execute a SELECT query and return rows as an array of arrays.
db.close()
Close the database connection.
Examples
import db
let conn = db.open("app.db")
conn.exec("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)")
conn.exec("INSERT INTO users (name) VALUES ('Alice')")
conn.exec("INSERT INTO users (name) VALUES ('Bob')")
let rows = conn.query("SELECT id, name FROM users")
for row in rows {
println("{row[0]}: {row[1]}")
}
-- 1: Alice
-- 2: Bob
conn.close()