agentskillexchange SQLite Analyst
Installation
Use the upstream install or setup path that matches your environment:
- npm install better-sqlite3
Requirements and caveats from upstream:
- The fastest and simplest library for SQLite in Node.js.
- Requires a currently supported Node.js version. Prebuilt binaries are available for LTS versions. If you have trouble i...
- const db = require('better-sqlite3')('foobar.db', options);
Basic usage or getting-started notes:
| |select 1 row get() |select 100 rows all() |select 100 rows iterate() 1-by-1|insert 1 row run()|insert 100 rows in a transaction|
bash
js
Extracted from upstream docs: https://raw.githubusercontent.com/WiseLibs/better-sqlite3/HEAD/README.md