Database · BUILT-IN MODULE

sqlite

SQLite CLI bridge.

Quick start

use sqlite

db = sqlite.open "app.db"
try sqlite.exec db "create table if not exists users(name text)"
rows = try sqlite.query db "select * from users"
say rows

API reference

sqlite.open path

Open a SQLite database handle.

開啟 a SQLite database handle.

sqlite.exec database sql

Execute SQL. Fallible.

執行 SQL. 此操作可能失敗。

sqlite.query database sql

Run a query and return CSV-style rows. Fallible.

執行 a query and return CSV-style rows. 此操作可能失敗。