Accessing / Writing Remote Data Advice

[davidlewis02]

My game will need to access an external data source to

1.load users game progression

2.calculate match result between 2 users (think football manager but not as complicated)

3.leaderboards

So the game wont need to read write live it will be more batched instances at infrequent intervals.

My day job is a SQL Server Developer so out of familiarity I’m leaning towards SQL Server 2014 express hoping to avoid making a website everything will be stored in the db.

My question with the above in mind is this the correct way to go about it? Or is there a better/ simpler way of achieving what I need.

If I do go down the website/ MySQL route is there any cheap (or free :D) provider you could recommend?

[rob]

I would suggest checking out something like Parse.com or Coronium.io.   There are easy to implement data storage platforms that work well with Corona SDK.  Normally you wouldn’t want to expose a raw database to internet writes, so if you roll your own, you’re going to have to have some intermediate scripts that take web/form type input, scrubs it and managed the actual reading and writing from the database.   A MySQL/PHP environment is one of the most common, but since you’re more Microsoft based, you might find a hosting provider to build a .net platform upon.   But either of these options will be more overhead than the two offerings I suggested at the top.

Rob

[davidlewis02]

Thanks once again Rob for the advice I will look into the above. 

[davidlewis02]

Having a little trouble here with Parse. Im pretty sure its to do with a missing module or some files it requires to work correctly with corona sdk but I am unsure where to put them. On the Parse site it provides an sdk download for ios, android and windows phone so there doesn’t appear to be anything for corona sdk. I did find this not sure if its out of date but I have no idea on how to install it.

https://bitbucket.org/develephant/mod_parse/wiki/Home

I’m logged in on Parse and added rows etc that part is fine.

But when I add:

local parse = require(“parse”) to my main.lua file I get the following error:

http://i.imgur.com/e0gyptS.png

edit: have also tried:

local parse = require( “mod_parse” )

[rob]

I would search the forum for previous Parse threads.  There is a lot of help there.

Rob

[davidlewis02]

Ok for anyone who might have the same problem after a couple hours scouting around to no avail I think I have managed to stumble on a resolution - have got rid of the error message at least

From the download link I provided I dropped the parse.lua or parse_mod.lua (not at computer right now)

into my project directory with my other .lua files and when I launch the application I no longer get the error.

I swear I tried this to start!!

I take it this is a standard way to insert a module into an application. Seems obvious but this is the first time I have had to do it.

[rob]

Yes, you put the .lua module in with your main.lua and then do a:

local moduleName = require("modulename") 

where “modulename” is the filename without the .lua on the end.

Rob

[rob]

I would suggest checking out something like Parse.com or Coronium.io.   There are easy to implement data storage platforms that work well with Corona SDK.  Normally you wouldn’t want to expose a raw database to internet writes, so if you roll your own, you’re going to have to have some intermediate scripts that take web/form type input, scrubs it and managed the actual reading and writing from the database.   A MySQL/PHP environment is one of the most common, but since you’re more Microsoft based, you might find a hosting provider to build a .net platform upon.   But either of these options will be more overhead than the two offerings I suggested at the top.

Rob

[davidlewis02]

Thanks once again Rob for the advice I will look into the above. 

[davidlewis02]

Having a little trouble here with Parse. Im pretty sure its to do with a missing module or some files it requires to work correctly with corona sdk but I am unsure where to put them. On the Parse site it provides an sdk download for ios, android and windows phone so there doesn’t appear to be anything for corona sdk. I did find this not sure if its out of date but I have no idea on how to install it.

https://bitbucket.org/develephant/mod_parse/wiki/Home

I’m logged in on Parse and added rows etc that part is fine.

But when I add:

local parse = require(“parse”) to my main.lua file I get the following error:

http://i.imgur.com/e0gyptS.png

edit: have also tried:

local parse = require( “mod_parse” )

[rob]

I would search the forum for previous Parse threads.  There is a lot of help there.

Rob

[davidlewis02]

Ok for anyone who might have the same problem after a couple hours scouting around to no avail I think I have managed to stumble on a resolution - have got rid of the error message at least

From the download link I provided I dropped the parse.lua or parse_mod.lua (not at computer right now)

into my project directory with my other .lua files and when I launch the application I no longer get the error.

I swear I tried this to start!!

I take it this is a standard way to insert a module into an application. Seems obvious but this is the first time I have had to do it.

[rob]

Yes, you put the .lua module in with your main.lua and then do a:

local moduleName = require("modulename") 

where “modulename” is the filename without the .lua on the end.

Rob