{"library":"better-sqlite3-helper","type":"library","category":null,"description":"A Node.js wrapper around better-sqlite3 providing shorthand query methods, automatic migration support, and a singleton pattern for simple server apps. Version 3.x (latest 3.1.7) uses better-sqlite3 v7, drops Node <10, and requires @types/better-sqlite3 as a peer dependency for TypeScript support. It simplifies database access with methods like query(), queryFirstRow(), insert(), and update(), and includes a migration system that runs SQL files on startup. Compared to better-sqlite3 alone, it reduces boilerplate by managing a global instance and handling migrations automatically. Release cadence is irregular; last release was Sep 2023.","language":"javascript","status":"active","version":"3.1.7","tags":["javascript","sqlite3","sqlite","sql","database","save","custom","helper","better-sqlite3"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install better-sqlite3-helper","imports":["const DB = require('better-sqlite3-helper');","const DB = require('better-sqlite3-helper');\nconst db = DB({ path: './db.sqlite' });","const DB = require('better-sqlite3-helper');\nlet rows = DB().query('SELECT * FROM users');","import DB from 'better-sqlite3-helper';"]},{"cmd":"yarn add better-sqlite3-helper","imports":[]},{"cmd":"pnpm add better-sqlite3-helper","imports":[]}],"homepage":"http://intergenies.com/programs/nodejs/better-sqlite3-helper","github":"https://github.com/Kauto/better-sqlite3-helper","docs":null,"changelog":null,"pypi":null,"npm":"better-sqlite3-helper","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}