Nativescript-Better-Sqlite
A Nativescript plugin providing easy SQLite access on Android.
Installation:
tns plugin add nativescript-better-sqlite
What is working:
- Create/connect database
- In memory databases
- Readonly databases
- Prepared statements
- Get single values
- Iterator for rows
- Get last inserted row
- Pragmas
Example
The following code
; ; database.pragma'journal_mode = WAL'; database.execute `CREATE TABLE user (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, name TEXT NOT NULL);`; ; insert.run;insert.run; insert.close; ; console.lognames;
results in
this output.
TODOs:
- Transactions
- Workers / async
- Results as array
- Optimisations