@akylas/nativescript-sqlite
by akylas | v3.3.12
SQLite for Nativescript
npm i --save @akylas/nativescript-sqlite
  • Version: 3.3.12
  • GitHub:
  • Downloads:
    • Last Day:   14
    • Last Week:  42
    • Last Month: 122

Nativescript: Akylas Sqlite

Build Status npm version

Installation

tns plugin add nativescript-akylas-sqlite

Usage

You should take care of wrapping sqlite calls to your preferred async option (promises, observables, async/await). And catch any exceptions thrown.

import { openOrCreate, deleteDatabase } from "nativescript-akylas-sqlite";

const sqlite = openOrCreate("path/to/db");
sqlite.execute("CREATE TABLE names (id INT, name TEXT)");
sqlite.transaction(cancelTransaction => {
// Calling cancelTransaction will rollback all changes made to db
names.forEach((name, id) =>
sqlite.execute(
"INSERT INTO names (id, name) VALUES (?, ?)",
[id, name]
)
);
});