{"repo":"WiseLibs/better-sqlite3","free":true,"listed":false,"github":"https://github.com/WiseLibs/better-sqlite3","clone":"git clone https://github.com/WiseLibs/better-sqlite3.git","description":"The fastest and simplest library for SQLite3 in Node.js.","language":"JavaScript","stars":7441,"topics":["sql","sqlite","sqlite3","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"better-sqlite3 The fastest and simplest library for SQLite in Node.js. - Full transaction support - High performance, efficiency, and safety - Easy-to-use synchronous API (better concurrency than an asynchronous API... yes, you read that correctly) - Support for user-defined functions, aggregates, virtual tables, and extensions - 64-bit integers (invisible until you need them) - Worker thread support (for large/slow queries) Help this project stay strong! 💪 better-sqlite3 is used by thousands of developers and engineers on a daily basis. Long nights and weekends were spent keeping this project strong and dependable, with no ask for compensation or funding, until now. If your company uses better-sqlite3 , ask your manager to consider supporting the project: - Become a GitHub sponsor - Become a backer on Patreon - Make a one-time donation on PayPal How other libraries compare 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 --- --- --- --- --- --- better-sqlite3 1x 1x 1x 1x 1x sqlite and sqlite3 11.7x slower 2.9x slower 24.4x slower 2.8x slower 15.6x slower You can verify these results by running the benchmark yourself. Installation Requires a currently supported Node.js version. Prebuilt binaries are available for major platforms/architectures. If you have trouble installing, check the troubleshooting guide. Usage Though not required, it is generally imp","default_branch":null,"files":null,"tree":[],"storefront":"/r/WiseLibs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/WiseLibs/better-sqlite3/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}