{"library":"better-sqlite3","type":"library","category":null,"description":"The fastest and simplest SQLite library for Node.js, with a synchronous API that outperforms alternatives like sqlite3 by 2-24x in common operations. Version 12.10.0 requires Node.js 20+ and includes prebuilt binaries for LTS. Key differentiators: full transaction support, user-defined functions/aggregates/virtual tables, 64-bit integer support, and worker thread compatibility. The synchronous API is designed to be safer and more efficient than async equivalents for SQLite's inherently single-threaded nature.","language":"javascript","status":"active","version":"12.10.0","tags":["javascript","sql","sqlite","sqlite3","transactions","user-defined functions","aggregate functions","window functions","database"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install better-sqlite3","imports":["import Database from 'better-sqlite3';","const Database = require('better-sqlite3');","import type Database from 'better-sqlite3';","import type { Statement } from 'better-sqlite3';"]},{"cmd":"yarn add better-sqlite3","imports":[]},{"cmd":"pnpm add better-sqlite3","imports":[]}],"homepage":"http://github.com/WiseLibs/better-sqlite3","github":"git://github.com/WiseLibs/better-sqlite3","docs":null,"changelog":null,"pypi":null,"npm":"better-sqlite3","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}