Skip to main content

SQLite Porter

This Cordova/Phonegap plugin can be used to import/export to/from a SQLite database using either SQL or JSON.

Stuck on a Cordova issue?

Don't waste precious time on plugin issues.

If you're building a serious project, you can't afford to spend hours troubleshooting. Ionic’s experts offer premium advisory services for both community plugins and premier plugins.


$ npm install $ npm install @ionic-native/sqlite-porter $ ionic cap sync

Supported Platforms#

  • Amazon Fire OS
  • Android
  • BlackBerry 10
  • Browser
  • iOS
  • Tizen
  • Windows
  • Windows Phone



Learn more about using Ionic Native components in React


import { SQLitePorter } from '@ionic-native/sqlite-porter/ngx';

constructor(private sqlitePorter: SQLitePorter) { }
let db = window.openDatabase('Test', '1.0', 'TestDB', 1 * 1024);// or we can use SQLite plugin// we will assume that we injected SQLite into this component as sqlitethis.sqlite.create({  name: 'data.db',  location: 'default'})  .then((db: any) => {    let dbInstance = db._objectInstance;    // we can pass db._objectInstance as the database option in all SQLitePorter methods  });

let sql = 'CREATE TABLE Artist ([Id] PRIMARY KEY, [Title]);' +           'INSERT INTO Artist(Id,Title) VALUES ("1","Fred");';
this.sqlitePorter.importSqlToDb(db, sql)  .then(() => console.log('Imported'))  .catch(e => console.error(e));