Connecting database with application

[Markovic]

Im making application which will show restaurants, hotels, caffes, clubs,... etc in my city. Which is the best and simplest solutions for my libary. I thought of putting my libary on internet and change it once a week adding new events for that weekend without need to update app from store. I have absolutely no experience with databases so im asking what is the best way of doing this?

 

[NicoVermeir]

the way I see it, you have 2 possibilities:

- add SQLite to your application and have all data locally, meaning that you'll probably need to do an app update everytime you add something to the DB, unless you build in some sort of DB update mechanism

- Create a REST API (have a look at ASP.net WebAPI if you have no REST experience) and consume that API from your app. When going this route you can choose how you want to save your data, JSON, XML, MySQL, SQL server, NoSQL, ...

 

[Markovic]

Thanks, I'll try with REST API and will post here if it worked.

 

[eshy]

You can also use Azure Mobile Services or Parse instead of building your own API.

​
Another option is to have a json file on a server and just download once a day/week to get the latest data