I have a web server set up on an EC2 instance where I have a SQLite database stored. For testing purposes, I currently have a PHP file that I can hit by sending an NSURLRequest to http://<my-instance-ip>/foo.php, where the script will access the SQLite database and return the information in JSON. Would I want to do the same thing in a live application or am I thinking of this completely the wrong way? I'm new to AWS so I'm not too sure about how these services are used.
If the database is for all your app users, you should use mysql or other full functional database, and use php to write web services.
If the database is for a single user, you can just store the sqlite data in the device, and use fmdb to access it