Click here to Skip to main content
15,886,873 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

There is scenario in mobile application where there needs to be database on mobile device (android and iphone) and a database on the server. So whenever these mobile devices will come in network, the sync will start between mobile device and server.

Kindly suggest which database will be best fit since the application will be published globally and will transact millions of record on per day basis.

For the application development of ios and android is it suggested to work on a common framework or should we go for there respective frameworks.

Regards
Deep
Posted

1 solution

SQLite :- Sqlite can be used in iOS/Android for handling data. Light weight and suitable for mobile development.
SQLite is a opensource SQL database that stores data to a text file on a device. It just uses the sqlite queries which make it easier for those who know sql.

iOS includes the popular SQLite library, a lightweight yet powerful relational database engine that is easily embedded into an application. Used in countless applications across many platforms, SQLite is considered a de facto industry standard for lightweight embedded SQL database programming. Unlike the object-oriented Core Data framework, SQLite uses a procedural, SQL-focused API to manipulate the data tables directly.

Android comes in with built in SQLite database implementation.

SQLite supports all the relational datbase features. In order to access this database , you don't need to establish any kind of connections for it like JDBC,ODBC e.t.c

http://developer.android.com/reference/android/database/sqlite/package-summary.html
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900