Load the entire Database from the webserver to IOS native app

Question

I am developing a app where i need to keep the replica of entire database from the web server to the IOS native sq-lite database, How can i keep updated version of db or import at loading of the app in one go, What should be my approach to go with this problem, Any help would be really appreciated,

Thanks Deepesh

i would parse the server response in json , and use core data for storage. — self
– self, Commented Jun 24, 2012 at 10:21
Generally you'd use JSON. The other option is to build the entire SQLite file on the server and sent the file in binary. — Hot Licks
– Hot Licks, Commented Jun 24, 2012 at 11:45
(Note that there is no single common, freely available tool for "synchronizing" phone and server database info via incremental updates -- that you must concoct yourself.) — Hot Licks
– Hot Licks, Commented Jun 24, 2012 at 11:47

Community · Accepted Answer · 2017-05-23 12:27:50Z

0

Looks like this is a popular problem. According to this answer,

Not every DB schema can be converted. MySQL is more complex and feature-rich than SQLite. However, if your schema is simple enough, you could dump it into an SQL file and try to import it / load it into an SQLite DB.

To do this, you can either use this mysql2sqlite.sh script like so

./mysql2sqlite.sh myDbase | sqlite3 database.sqlite

or use this answer and simply do

mysqldump database > database.sql
sqlite3 database < database.sql

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Jun 24, 2012 at 13:12

gregoltsov

2,3093 gold badges23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Max Over a year ago

Can i run this script in objective C, in the app (for example in view did load ) becuase i want an update from the ios native app.

gregoltsov Over a year ago

It is possible to run similar things in Objective-C. Look in this thread for more info on importing/exporting DB using FMDB.

Collectives™ on Stack Overflow

Load the entire Database from the webserver to IOS native app

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related