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...
simplest way to record student scores
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: simplest way to record student scores
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
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
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
-
- VIP Livecode Opensource Backer
- Posts: 9852
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: simplest way to record student scores
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.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.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
Re: simplest way to record student scores
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?