how to upload Sqlite database file to server from iphone application in ios

Question

In my iphone application i used sqlite3 for creating database. Now i want to take backup of a database file on my server.

so how to upload my sqlite db file to server from my application in iphone?

Community · Accepted Answer · 2017-05-23 11:55:57Z

5

I would read the sql database into a JSON object, then upload it to a server via a URL that calls a PHP script along the lines of this stack overflow answer!

Here's an example of some mySQL data wrapped into JSON:

{database:{"col1":"56","col2":"85","col3":"some_text"},
{"col1":"57","col2":"86","col3":"next row"} }

More about JSON payloads in Apple dev docs here JSON

As of iOS5.x, Apple now includes some JSON helper classes, see NSJSONSerialization class reference along with the Twitter example app.

I have used this the SBJson framework in the past for iOS SBJson

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Nov 2, 2012 at 8:54

Nick T

9471 gold badge8 silver badges31 bronze badges

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

2 Comments

skyfall Over a year ago

hello nick thanks for your reply.Instead of read sql database into a JSON object. I want to upload whole Sqlite db file similar to the upload image on server in iphone. It is possible or not.

Nick T Over a year ago

One option is to turn on file sharing via iTunes: See stackoverflow.com/questions/10241032/…

Collectives™ on Stack Overflow

how to upload Sqlite database file to server from iphone application in ios

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