I need to create an app for the iPhone where users can both read and write to a shared database (SQLite). Can I do this with Corona? Would it be possible to use a shared database on DropBox or will I have to front a database with web services?

On device iOS apps are sand boxed, so only the specific app has access to the mySQL DB. You could have multi-user log on for your app and profile the DB by user.

Save DB data to a multi-tennant cloud solution is a different animal all together with many technical and possible legal complications. It is doable though to save data to a cloud DB or replicate a local DB data set to a cloud server DB when the user is connected to the net.

The cloud solution is highly dependent on security requirements and the cloud service you create or subscribe too.

-David

It will definately be a multi-user login situation (not dropbox). Does Corona have any code to support that? Do I have to front the database with web services and have the app call those web services or can I create a sql connection and issue commands directly?