Database · ALIAS

sqlite3

Alias for sqlite. SQLite CLI bridge.

sqlite3 is an alias of sqlite and shares the same API.

Quick start

use sqlite3

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

API reference

sqlite3.open path

Open a SQLite database handle.

開啟 a SQLite database handle.

sqlite3.exec database sql

Execute SQL. Fallible.

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

sqlite3.query database sql

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

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