Hello , sorry for the confusing title ,I do not speak english as my first language.(and also sorry if the topic does not fit here)
Problem background: I just want to create a website as a competitive program grader for my school. Like complie and run source code on the server. So below is my idea and i would like some help/suggestions before i do it,I still don't know if this will work.
Mysql usage:
The problem one is that i would use one of the table as my user-submission queue.When user submit a code, I first put it in this table(i suppose it put the new row in the bottom of the table?) .
Python program usage:
I would run a 24/7 program on my server that check every 10 second if the queue table is not empty, just run the grading process(I know how to do it) and then pop it off the queue.Then check again.
PHP usage:
When a person submit code, i will use php to put it on the queue table,but it may be the same time my python program is popping something off the queue table too. This is where I get confuse whether it will work or not.(Other usage of the php is just things about web interface which I had done before and know what to do)
So,would this idea even work? Will it break my server or something?As a competitive programmer guy I don't know much snd will greatly appreciate any help from u guys.
Thank you very much.
Problem background: I just want to create a website as a competitive program grader for my school. Like complie and run source code on the server. So below is my idea and i would like some help/suggestions before i do it,I still don't know if this will work.
Mysql usage:
The problem one is that i would use one of the table as my user-submission queue.When user submit a code, I first put it in this table(i suppose it put the new row in the bottom of the table?) .
Python program usage:
I would run a 24/7 program on my server that check every 10 second if the queue table is not empty, just run the grading process(I know how to do it) and then pop it off the queue.Then check again.
PHP usage:
When a person submit code, i will use php to put it on the queue table,but it may be the same time my python program is popping something off the queue table too. This is where I get confuse whether it will work or not.(Other usage of the php is just things about web interface which I had done before and know what to do)
So,would this idea even work? Will it break my server or something?As a competitive programmer guy I don't know much snd will greatly appreciate any help from u guys.
Thank you very much.