从iOS应用程序访问AWS EC2服务器上的SQLite数据库的最佳方法？

Question

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.

Answer 1

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