teerasej/ionic-example-sqlite

An example Ionic Project that demonstrate how to use ngCordova's SQLite plugin

Ionic Framework SQLite Example - One Word Save

An example Ionic framework that use ngCordova's SQLite plugin.

According to my training session. I decided to provide a quick, clean example, to show how to save/load data from SQLite database in mobile application which built on Ionic framework technology.

I used Ionic CLI version 1.3.19.

Installation

After clone the project, you need to add your platform and ngCordova's SQLite plugin:

ionic state restore
cordova plugin add https://github.com/litehelpers/Cordova-sqlite-storage.git
ionic platform add android
ionic platform add ios

Then go on.

Important Note

ngCordova's SQLite plugin doesn't work on Web browser. You've to run the project in Simulator or real device.

Instruction, Explanation, and tutorial

I explain all essential part of this app in my blog: http://nextflow.in.th/en/2015/easy-way-to-work-with-sqlite-database-in-ionic-framework/

Contact me for training service

[email protected] Tel [phone]

ionic-example-sqlite's Issues

Install not working!

Hi,
I can't install this plugin via command line: cordova plugin add https://github.com/brodysoft/Cordova-SQLitePlugin.git
I'm having this error:
Fetching plugin "https://github.com/brodysoft/Cordova-SQLitePlugin.git" via git clone Repository "https://github.com/brodysoft/Cordova-SQLitePlugin.git" checked out to git ref "master". **Error: Unexpected string**

Is there any other way to install this plugin? Is there some dependencies that should be installed a priori?

there has a problem...

when i click the save or load ,thow an exception “Cannot read property 'transaction' of undefined”?thy? thanks fro your answer

Where is tutorial Link

Hi! I was just exploring your project but couldn't find the link for your blog, as mentioned in the readme. Lemme know the link of tutorial & explanation

ionic 2

Does this example work with ionic 2 ? if so how do i convert it

TypeError: Cannot read property 'openDatabase' of undefined

Hello when i clone your code i have this error occurred

TypeError: Cannot read property 'openDatabase' of undefined
    at Object.openDB (ng-cordova.min.js:9)
    at app.js:46
    at Array.<anonymous> (ionic.bundle.js:56207)
    at onPlatformReady (ionic.bundle.js:2496)
    at onWindowLoad (ionic.bundle.js:2477)

Please let me know if you have solution.

nothing happens

When I have installed this app in my android phone and run this app and try to save message in it.It didnot save my message and did not load anything .

Does not work on Android 2.3

Hello,
I tried running this app on android 2.3 but it does not work.
However, when I install same on 4.x it works.
Can you please find out the issue?

error TypeError: n.sqlitePlugin is undefined

Hello thank you for share your app, when i copied your code i have this error

TypeError: n.sqlitePlugin is undefined