ডাউনলোড

`sqlite` মডিউল

এমবেডেড SQLite client। একটি ফাইল (বা টেস্টের জন্য ":memory:"), parameterized SQL, transaction, ও idempotent migration।

import "sqlite" as sqlite;

var db = sqlite.open("app.db");

db.exec("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)");
db.exec("INSERT INTO users (name) VALUES (?)", ["Alice"]);

var rows = db.query("SELECT * FROM users");
for (var row of rows) { print(row.id, row.name); }

db.close();

Module API

ফাংশন	বর্ণনা
`sqlite.open(path)` → db	Open বা create। `":memory:"` private in-memory DB।
`sqlite.version()` → string	SQLite library version।
`sqlite.transaction(db, fn)`	`fn(db)` `BEGIN`/`COMMIT`-এ; throw হলে rollback।
`sqlite.migrate(db, statements)`	Idempotent DDL statements list।
`sqlite.insert(db, table, row)` → id	`INSERT` + `last_insert_id()`।

db handle

মেথড	বর্ণনা
`db.exec(sql, params?)`	Statement চালান। `params` একটি list।
`db.query(sql, params?)` → list of maps	প্রতিটি row `{col_name: value}`।
`db.query_one(sql, params?)` → map \| null	প্রথম row বা `null`।
`db.last_insert_id()` → number
`db.changes()` → number	শেষ DML-এ touched rows।
`db.close()`	Idempotent।

আরও দেখুন

pg, mongo।