First, I am very much a novice when it comes to databases so I may be using incorrect terminology or have other embarrassing misunderstandings.
I have a racing game with an option to create private races. A player can create a private race and get a secret entry code to send to his friends. The secret code will allow them to join the private race. So, I have created a table in BigDB called "PrivateRaces" which holds the necessary info to generate each private race: number of racers, number of laps, track number, etc.
But I would like these private races to only be available for 48 hours. After that I would like to delete them from the database. I have used PHP + MYSQL a little bit, and I know this kind of thing can be done automatically with a "cron job". Is there anything similar available to me with BigDB? Or is there a better way to do this?
Thanks in advance,
Shawn