I’m using PHP/MySQL as my back-end, but only because it’s what my hosting company supports.
I’m also developing a multi-player game that needs to sync everything down to exact seconds between all the players. I do that by setting all times to the server’s time, then subtracting that time from each device’s local time to get an offset. So if I need to do something a minute from now (according to the server), but one of the players has their clock set 10 seconds too fast, I have to ADD 10 seconds to that player’s wait time.
ALL the data in my app is sent as JSON packets. The JSON library that comes with the “Facebook Connect” sample code that ships with Corona works very well for me. It’s fast, is easy to use and just works!
I make HTTP requests to .php pages on the server (ex: http://myserver.com/game/addplayer.php?gameid=1&username=joeyjesusballs). The pages read the querystring variables, run the necessary SQL command(s) for that action, and return data as a json packet (ex: {“status”:“success”, “message”:“joeyjesusballs has been successfully added to the game!”}). The JSON parser on the device gets that response back and handles it appropriately (maybe doing a native pop-up to relay the information back to the user).
This has worked-out very well for me, your mileage may vary.
Personally, I’m a .NET developer by day, I’d LOVE to use ASP.NET MVC and LINQ to SQL for the back-end (I’m really not too fond of PHP/MySQL), but it’s all I’ve got to work with…
And one thing that I’d really love to see in Corona is the ability to do asynchronous HTTP calls. Right now, my UI freezes for a second while requests are being made. It’s not too noticeable, it doesn’t take away from the game, but being able to continue with the game loop and wait for a response at the same time would be SLAWSOME!
-Mike [import]uid: 7340 topic_id: 1704 reply_id: 5006[/import]