sqlite3
SQLite3 database wrapper for PascalAI via C native binding. Open databases, execute DDL and DML statements, bind parameters, and fetch rows.
Install
ppm install sqlite3
Usage Example
uses sqlite3;
// Open a database
var db := Open('myapp.sqlite3');
// Create a table
Execute(db, 'CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)');
// Insert with parameter binding
var stmt := Bind(db, 'INSERT INTO users(name) VALUES(?)', ['Alice']);
Execute(db, stmt);
// Query and fetch rows
var rows := Query(db, 'SELECT * FROM users');
while FetchRow(rows) do
WriteLn(GetCol(rows, 'name'));
Close(db);
Features
Open and close SQLite3 databases on disk or in-memory
Execute DDL (CREATE, DROP) and DML (INSERT, UPDATE, DELETE)
Parameterized queries via Bind to prevent SQL injection
Cursor-based row fetching with FetchRow
Column access by name or index
Transaction support: BeginTransaction, Commit, Rollback