I am developing a Cross Platform Mobile Application (Currently targeting Android and iOS) using Microsoft Visual Studio 2012 as the IDE.
In this App, I require an Offline Relational Database which will store data related to the App.
Currently, I think the only appropriate solution is SQLite.
Can you provide me with a Simple Demo of SQLite with CRUD operations.
You can use Web SQL Database. Safari and Opera’s local databases are based on SQLite. You can use the following resources to get started:
Getting Started with HTML5 Local Databases - This blog provides examples demonstrating how to setup the database, build the table, select the data, make updates, drop the table. Take a special note of the pros and cons provided at the end of the blog.
HTML5 - Web SQL Database - This article provides examples demonstrating how to open the database and execute insert and read operations.
A Simple TODO list using HTML5 WebDatabases - The subject heading of this article is self-descriptive
Please note that at present, the Web SQL Database specification is no longer in active maintenance and the Web Application Working Group does not intend to maintain it further. You can find more details in the Web SQL Database Specification.
If the application will be distributed as a native package using PhoneGap framework, you can utilize the corresponding plugin: SQLitePlugin. The plugin documentation describes how to use it: Cordova/PhoneGap SQLitePlugin - a reference implementation. If you want to build packages using DevExtreme tools for Visual Studio, read these Knowledge Base articles:
How to add PhoneGap plug-in for Android to a DevExtreme project
How to add PhoneGap plug-in for iOS to a DevExtreme project