SQLite

Improve this doc

Access SQLite databases on the device.

Repo: https://github.com/litehelpers/Cordova-sqlite-storage

Installation

1. Install the Cordova and Ionic Native plugins:
   

   $ ionic cordova plugin add cordova-sqlite-storage
   $ npm install --save @ionic-native/sqlite@4
   

2. Add this plugin to your app's module

Supported platforms

• Android
• iOS
• macOS
• Windows

Usage

import { SQLite, SQLiteObject } from '@ionic-native/sqlite';

constructor(private sqlite: SQLite) { }

...

this.sqlite.create({
  name: 'data.db',
  location: 'default'
})
  .then((db: SQLiteObject) => {


    db.executeSql('create table danceMoves(name VARCHAR(32))', [])
      .then(() => console.log('Executed SQL'))
      .catch(e => console.log(e));


  })
  .catch(e => console.log(e));

Instance Members

create(config)

Open or create a SQLite database file.

See the plugin docs for an explanation of all options: https://github.com/litehelpers/Cordova-sqlite-storage#opening-a-database

echoTest()

Verify that both the Javascript and native part of this plugin are installed in your application

selfTest()

Automatically verify basic database access operations including opening a database

deleteDatabase(config)

Deletes a database

SQLiteObject

Instance Members

databaseFeatures()

openDBs()

addTransaction()

transaction(fn)

readTransaction(fn)

startNextTransaction()

open()

close()

executeSql()

Execute SQL on the opened database. Note, you must call create first, and ensure it resolved and successfully opened the database.

sqlBatch(sqlStatements)

abortallPendingTransactions()

SQLiteDatabaseConfig

SQLiteTransaction