@akylas/nativescript-sqlite

SQLite for Nativescript

Usage no npm install needed!

<script type="module">
  import akylasNativescriptSqlite from 'https://cdn.skypack.dev/@akylas/nativescript-sqlite';
</script>

README

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]
        )
    );
});