@robinpath/database

SQLite database with query builder, transactions, bulk insert, table management, and backup

Why use this module?

The database module lets you:

• Open a SQLite database (file or in-memory)
• Close a database connection
• Run a SELECT query and return all matching rows
• Run a SELECT query and return only the first row
• Execute an INSERT, UPDATE, DELETE, or DDL statement

All functions are callable directly from RobinPath scripts with a simple, consistent API.

Installation

npm install @robinpath/database

Quick Start

No credentials needed — start using it right away:

database.close "mydb"

Available Functions

Function	Description
database.open	Open a SQLite database (file or in-memory)
database.close	Close a database connection
database.query	Run a SELECT query and return all matching rows
database.queryOne	Run a SELECT query and return only the first row
database.execute	Execute an INSERT, UPDATE, DELETE, or DDL statement
database.insert	Insert a row using an object of column-value pairs
database.insertMany	Insert multiple rows in a single transaction
database.update	Update rows matching a WHERE clause
database.remove	Delete rows matching a WHERE clause
database.createTable	Create a new table with column definitions
database.dropTable	Drop a table if it exists
database.listTables	List all tables in the database
database.tableInfo	Get column information for a table
database.count	Count rows in a table with optional WHERE conditions
database.transaction	Run multiple SQL statements in a single atomic transaction
database.backup	Backup the database to a file

Examples

Close a database connection

database.close "mydb"

Run a SELECT query and return all matching rows

database.query "mydb" "SELECT * FROM users WHERE age > ?" 18

Run a SELECT query and return only the first row

database.queryOne "mydb" "SELECT * FROM users WHERE id = ?" 1

Integration with RobinPath

import { RobinPath } from "@wiredwp/robinpath";
import Module from "@robinpath/database";

const rp = new RobinPath();
rp.registerModule(Module.name, Module.functions);
rp.registerModuleMeta(Module.name, Module.functionMetadata);

const result = await rp.executeScript(`
  database.close "mydb"
`);

Full API Reference

See MODULE.md for complete documentation including all parameters, return types, error handling, and advanced examples.

Related Modules

• @robinpath/json — JSON module for complementary functionality

License

MIT