Database

SQLite built in — no external dependencies.

Methods

Method	Returns	Description
Db.open(path)	db	Open database (:memory: for in-memory)
Db.exec(db, sql)		Execute SQL statement
Db.query_one(db, sql)	string	Query single value
Db.close(db)		Close database

Examples

var db = Db.open("app.db")
Db.exec(db, "CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT)")
Db.exec(db, "INSERT INTO users(name) VALUES('Alice')")
Db.exec(db, "INSERT INTO users(name) VALUES('Bob')")

var count = Db.query_one(db, "SELECT COUNT(*) FROM users")
println("Users: ${count}")

var name = Db.query_one(db, "SELECT name FROM users WHERE id=1")
println("First user: ${name}")

Db.close(db)

In-Memory Database

var db = Db.open(":memory:")
Db.exec(db, "CREATE TABLE t(v TEXT)")
Db.exec(db, "INSERT INTO t(v) VALUES('test')")
println(Db.query_one(db, "SELECT v FROM t"))    // test
Db.close(db)