iphone data storage to remote SQL database server

I have a task at hand to create a iphone app which is required to do the following.

• the app should get the data 开发者_JAVA技巧entered by the user and store it into a remote server database.
• other app user can see the data in the remote database.
• store login information of the user using the app so as to keep track of what information as uploaded and by who

the thing that i would like to know.

1) What SQL server database is best to accomplish the task. 2) what format is best to retrieve the information from the database. 3) how to send the data from the iphone to the remover server database to it can store the data.

i read up on SQLite and found out that this particular database is a offline which stores the data locally so it cannot be viewed by other used. i wan to use a SQL database which can be accessed remotely.

---

1) What SQL server database is best to accomplish the task.

For implementation on server side, you can implement any server database, it does not matter. For implementation on iphone device, you have to implement SQLite database, which will provide storage locally.

2) what format is best to retrieve the information from the database.

You can retrieve data using XML or JSON format which will be parsed in device and can be stored in SQLite database, it is the easiest way to transfer data between client and server.

3) how to send the data from the iphone to the remover server database to it can store the data.

You can send data from iphone to server in XML/JSON format or by passing parameters in POST or GET request method then this format is parsed on server side and store data on server database.

For all this, you will require to implement API on server side, which will be the interface between server and device.

---

I know you mention SQL specifically, but is this a requirement or just a choice based on what most other people are doing? I ask because personally I would give serious thought to using a NoSQL database (document store) like couchdb for such a task. Deploying couch means you often don't need server side application layer at all, the way you will for a SQL based solution.

You talk to couch using HTTP which is perfectly suited to the ASIHTTPRequest library for example. Fetching data is usually a GET request and storing documents is done with PUT. All the data in or out comes back as JSON so a good JSON library will make life easier.

The combination of couchdb and the 2 libraries linked above, makes developing a data driven application really, really easy.

That's how I would do it ...

If you really need to stick with SQL, then as Jignesh says, use whatever database you like and implement a suitable API in the server side language of your choice. You can transfer the data however you like although JSON would still get my vote as a relatively light protocol that remains human readable.

---

You can use a cloud-enabled database service, like windows azure.