Storing and Retrieving stack data?

John Patten johnpatten at mac.com
Tue Jun 3 18:48:19 EDT 2008


Hello All!

I would like to save some user (student) input out of one rev project and have it accessible to another rev project (teacher) to generate reports. The users of the project could be on a school network (LAN/WAN) or at home on the Internet. What is the best way to save the data?  What is the most common practice for saving the data for this type of project? 

Possible ideas...

FTP user data as individual files to a ftp server? (Run through a process of reading back all the files in the directory to create report.)

Send user data directly to mySQL database? (Require the mySQL database to be open to outside connections - direct connect to mySQL?)

Send user data as a post process, using a CGI script to send data to mySQL database on server?


The first idea seems the easiest, but I'm afraid could get to be pretty slow with a couple hundred files in the ftp directory. I could modify an existing file on the ftp server, however I run the risk of some data not being written to the file if simultaneous connections occur...?

I have not done any work with Rev and mySQL, so if I could get away from the sql commands, all the better :-)  But, if it would be the best way to go, I'm willing to focus on that area. 

Any ideas?

Thank you!

John Patten




More information about the use-livecode mailing list