What is the best way to implement a 'last seen' function in a django web app?

Question

I have a running django/apache2 + memcached app (ubuntu) and would like to keep track of logged in users that are online.

What would be the best way to track this?

I would prefer not writing to the database each time a logged in user loads a page; but what other options are there?

Answer 1

An approach might be:

you create a middleware that does the following on process_response:

• check for a cookie called 'online', but only if the user is authenticated
• if the cookie is not there,
  • set a cookie called 'online' with value '1'
  • set the lifespan of the cookie to 10 minutes
  • update the 'last_login' field of auth.User for this user with the current datetime

now you have all currently logged in users in your auth.User table. All Users that have a last_login newer than datetime.now()-interval(15minutes) might be considered "online".

The database will be written for every logged in user about every 10 minutes. Adjust the values "10" and "15" to your needs.

The advantage here is that database writes are rare (according to your two numeric settings 10/15). And for speed optimization make sure that last_login is indexed, so a filter on this field including Count is really fast.

Hope this helps.