Query to Database MySQL iOS application

Question

I have a database mysql and it contains 1000 records of people (Name, Age, Adress, Country). I want to make an application that :

Randomly displays ONE of the records in the database.
Randomly displays ONE of the records according to a specific 'Country'.

My usual approach to this is : parse ALL data to the iphone using JSON, then manipulate the data. Because of the volume of data that the user needs to download (1000 records) and because i only need just ONE of the records to be displayed, it seems wasteful to download all 1000 records and then sort the data. What other approach can i use? (not sure but is it possible to query the database directly?)

Ahmed · Accepted Answer · 2012-01-23 23:22:41Z

2

It would be very unsafe to query the DB directly and the usual approach you mentioned would be a very bad idea. So, the general approach, safe and optimized, for this scenario is to write some web-service, can be in PHP or ASP.net or etc., end-points which can optionally take some parameters, like the specific country, as argument and return you data in JSON format and then you can display it. This is how I'd approach to such problem. Here's a tutorial on writing some basic web-services with PHP.

http://davidwalsh.name/web-service-php-mysql-xml-json

Hope that'd help.

edited Jan 23, 2012 at 23:22

answered Jan 23, 2012 at 22:53

Ahmed

7821 gold badge9 silver badges27 bronze badges

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

2 Comments

Rory Lester Over a year ago

^^ also, what you are saying is : 1. To get only one record randomised, i can simply create a php script that returns a random record, however how would this work for the second part?. If the user has a specific country he wants to search for, i need to send the data from the iphone to the php script. Problem is, assuming there are muliple users, it would cause conflict no?

Ahmed Over a year ago

Conflict? why? you'd be passing the country information as a parameter in the GET request and the result will be delivered in the same very request. There'd be no confusion. In case of simultaneous users there could be bottleneck problem but there won't be conflicts. Hope I got your query correctly.

Collectives™ on Stack Overflow

Query to Database MySQL iOS application

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related