Network game using mysql

[João Abrantes]

Good evening,

I am making an online game that stores its data in a mysql database. The thing is that I can't allow the players to interact directly with the important tables of database (they could cheat if I give them access) so I only allow them to write on a table named commands and then a python program running on the server will interpreter that command and update the important tables. For example, a user that wants to build an house writes on the commands table 'build house', and then my python program takes the resources of the user and gives him an house.  The thing is that I need to have a program reading the command list in a infinite while loop and I don't know if there is a better way to do this, I am afraid that if the command list gets to crowed my python program may not handle all the commands in time. And if I put two programs reading the same command list sometimes they handle the command twice..

Hope you can help me,
Thanks.  

_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20090414/bc0d494d/attachment.html>