LiveCode Forums

I'm developing an app which will eventually record student scores (date, time, score) for a series of exercises. I know I could have Livecode store this data in a local file and then I could have my students send the files to me (I suppose that's the default), but much better would be to have students enter ids and passwords and have the app store the data for each on a file accessible to all. "Accessible to all" means, I am assuming, an online database. If this database could then be downloaded to my grading software, all the better. Apparently there are some free sites which allow one to create MySQL databases. I also know that Livecode will access, read from, and write to such databases.

My question is, is there some simpler way to do this which I am missing? I'd have (at most) 60 students / semester with at most 25 date/time/score entries each. I think that's a relatively tiny amount of data, as these things go.

Many thanks in advance...

Hi jrioux,

Instead of using MySQL, you could write a PHP script that stores the data in a file on your server. However, if 60 students try to contact the server simultatneously, you might run into trouble. A MySQL server is more reliable. If you don't have a MySQL server, I offer cheap web hosting services that include MySQL.

Kind regards,

Mark

jrioux wrote:I'd have (at most) 60 students / semester with at most 25 date/time/score entries each. I think that's a relatively tiny amount of data, as these things go.

Indeed it is. You could write a CGI with RevServer which could handle each student as a text file. Since each text file is separate the concern about record-locking becomes greatly diminished.

I confess I haven't really considered what you are looking to do in terms of understanding what you can and can't do, but maybe a Google Docs scenario is simplest here?