OT: making queues in DB

[Mitja]

I just posted a more theoretical question here, and since this is of more
practical nature, I decided to make a new post. It doesn't have much to do
with Python, it's just a thing I came across when making a CGI-driven
webpage.

I have a games page, on which I would like to display a list of 10 last
downloaded games. Therefore, I'd need a kind of queue in the database. What
is the best way to go about this? Extending each game's entry with a
"timelastdownloaded"-like column is of course an option, but I don't favor
it too much.

 

[Brian Kelley]

I have a games page, on which I would like to display a list of 10 last
downloaded games. Therefore, I'd need a kind of queue in the database. What
is the best way to go about this? Extending each game's entry with a
"timelastdownloaded"-like column is of course an option, but I don't favor
it too much.

Why not? This seems to be the most reasonable solution, then your sql
statement to the database would be something like:

SELECT * from gametable
ORDER BY timelastdownloaded DESC
limit 10

The order by is a descending order from the current date to the last
date, and the limit 10 gets the last 10.

If you are worried about performance you can modify the select to return
only the games downloaded from the last month or so. Or if the table
gets too large, just delete the earliest entries.

Brian