How to use Sqlite as local storage?


#1

Dear Developer,
I have developed a apps with ionic framework. I am using phoneGap Buil for building apps. I want to use sqlite for android, IOS and windows phone as a local storage. I have used plugin but there is nothing happen.But i am till struggling for creating database and table.

Github Link of my project: https://github.com/enamul95/TestSqlite

If you give an idea for that i will be grateful to you…

Please help any one…


#2

SQLite and LocalStorage are two different things. LocalStorage is simple key/value pair, while SQLite is almost identical to real SQL.
If you want you can check SQLite plugin: https://github.com/brodysoft/Cordova-SQLitePlugin
or you can maybe try WebSQL which is SQLite that is included in webview, but i don’t recommend it as it doesn’t work on some devices.


#3

I’ve not had good experiences with PhoneGap Build when it comes to plugins. You should try to build your apps on your local machine.

Regards,


#4

how to use webSQL in ionic for android, ios, widnows phone? I am using adobe phoneGap build. I am also using windows not mac. For building apps android, ios and windows i am using adobe phoneGap build . I am using Ionic framework for these three platform. I have finished all functionality that was working fine. But when i want to use local database like sqlite, it does not work.


#5

You need to provide more information, what doesn’t work, what plugin are you using…
Anyway this is the wrong place to ask such question, ask on plugin’s github page.


#6

Take look at angular localForage i worked with it and think it’s great!
Hope it helped!


#7

Hi you can check out the Quizionic App template available here: http://codecanyon.net/item/quizionic-a-quiz-app-template-for-ionic-framework-with-sqlite-database/14205904, that illustrates the way to put a pre-populated database in device.


#8

See this project: https://github.com/jdnichollsc/Ionic-Starter-Template

Regards, Nicholls