SQLite3 nodejs binding. It's simple to use and supports the both asynchronous and synchronous manners.
Prerequisites
apt install libsqlite3-dev
You may need to install cmake-js
and typescript
npm i -g cmake-js
npm i -g typescript
Install
npm i simpledbc
Example
See example/
CREATE
const Connection = ; let conn = dblet stmt = connlet query = `CREATE TABLE (idx INTEGER PRIMARY KEY AUTOINCREMENT, passwd TEXT, date DATETIME);`stmt
INSERT
let stmt = conn;let password = Math;let query = `INSERT INTO (passwd, date) VALUES(,datetime(\'now\',\'localtime\'));`;stmt
SELECT
let stmt = conn;let query =`SELECT idx, passwd, date FROM `;stmt
UPDATE
let stmt = conn;let password = 'new password';let query = `UPDATE set passwd=\'\', date=datetime(\'now\',\'localtime\') WHERE idx=1;`;stmt
DELETE
let id = 1;let stmt = conn;let query = `DELETE FROM admin WHERE idx=;`;stmt
async / await
You can use it like this as well.
{ let id = 2; let stmt = conn; let query = `DELETE FROM admin WHERE idx=;`; let res = await stmt console;}
(Optional) Native only build
cd native;mkdir build; cd buildcmake .. && make