Update SQLite to version 3.49.1 (#1346) JoshuaWise and mceachen authoredMar 14, 2025 73929e8 Commits on Mar 8, 2025 Update the Ubuntu runner image in build script toubuntu-22.04(#1341) m4heshd authoredMar 8, 202
3Branches109Tags Code This branch is2 commits ahead of,19 commits behindWiseLibs/better-sqlite3:master. Folders and files Name Last commit message Last commit date Latest commit aidenlx add uri_path support Nov 19, 2024 a937d9a·Nov 19, 2024 ...
|better-sqlite3|1x|1x|1x|1x|1x| |[sqlite](https://www.npmjs.com/package/sqlite)|11.7x|2.9x|24.4x|2.8x You can verify these results byrunning the benchmark yourself. Installation ```bash npminstallbetter-sqlite3 ``` You must be using Node.js v14.21.1 or above. Prebuilt binarie...
constdb=require('better-sqlite3')('foobar.db',options);constrow=db.prepare('SELECT * FROM users WHERE id = ?').get(userId);console.log(row.firstName,row.lastName,row.email); Though not required,it is generally important to set the WAL pragma for performance reasons. ...
better-sqlite3is simpler to use, and it provides nice utilities for some operations that are very difficult or impossible innode-sqlite3. better-sqlite3is much faster thannode-sqlite3in most cases, and just as fast in all other cases. ...
added the nativeBinding option to the Database constructor changed the code property of SqliteError to be enumerable added SqliteError to the API documentation Removed tar dependency Reduced the size of installing better-sqlite3 (by using a files list in package.json)Assets...
The fastest and simplest library for SQLite3 in Node.js. - Release v7.4.2 · WiseLibs/better-sqlite3
The fastest and simplest library for SQLite3 in Node.js. - Release v11.1.0 · WiseLibs/better-sqlite3
constDatabase=require('better-sqlite3');constdb=newDatabase('foobar.db',{verbose:console.log}); .prepare(string) ->Statement Creates a new preparedStatementfrom the given SQL string. conststmt=db.prepare('SELECT name, age FROM cats'); ...
The fastest and simplest library for SQLite3 in Node.js. - Release v9.2.0 · WiseLibs/better-sqlite3