{"repo":"kriasoft/node-sqlite","free":true,"listed":false,"github":"https://github.com/kriasoft/node-sqlite","clone":"git clone https://github.com/kriasoft/node-sqlite.git","description":"SQLite client wrapper around sqlite3 for Node.js applications with SQL-based migrations API written in Typescript","language":"TypeScript","stars":934,"topics":["nodejs","sql","sqlite","database","es7-async","async","migration","migrations","migrate","db"],"license":"MIT","category":"databases-storage","readme_excerpt":"SQLite Client for Node.js Apps A wrapper library written in Typescript with ZERO dependencies that adds ES6 promises and SQL-based migrations API to sqlite3 (docs). note v4 of sqlite has breaking changes compared to v3! Please see CHANGELOG.md for more details. - Installation - Install sqlite3 - Install sqlite - Usage - Opening the database - Without caching - With caching - Enable verbose / debug mode - Tracing SQL errors - With a custom driver - Opening multiple databases - open config params - Examples - Creating a table and inserting data - Getting a single row - Getting many rows - Inserting rows - Updating rows - Prepared statement - each() - Get the driver instance - Closing the database - ES6 tagged template strings - Migrations - Typescript tricks - Import interfaces from sqlite - Specify typings for a specific database driver - Use generics to get better typings on your rows - Get example - All example - API Documentation - Management Tools - Alternative SQLite libraries - References - License Installation Install sqlite3 Most people who use this library will use sqlite3 as the database driver. Any library that conforms to the sqlite3 (API) should also work. $ npm install sqlite3 --save Install sqlite Usage This module has the same API as the original sqlite3 library (docs), except that all its API methods return ES6 Promises and do not accept callback arguments (with the exception of each() ). Opening the database Without caching or or With caching If you want to e","default_branch":null,"files":null,"tree":[],"storefront":"/r/kriasoft","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kriasoft/node-sqlite/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."}