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? [import]uid: 41809 topic_id: 17425 reply_id: 317425[/import]
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 [import]uid: 96411 topic_id: 17425 reply_id: 66050[/import]
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?
[import]uid: 41809 topic_id: 17425 reply_id: 66088[/import]