Django/SQL: keeping track of who who read what in a forum
You're much better off storing the "read" bit, not the "unread" bit.  And you can store them not as relational data, but in a giant bit-blob.  Then you don't have to modify the read data at all when new posts are added, only when a user reads posts.
I'm working on a not-so-big project in django that will among other things incorporate a forum system.
I have most of the system at a more or less functioning state, but I'm still missing a feature to mark unread threads for the users when there are new posts.
The thing is I can't really think of a way to properly store that information. My first idea was to create another model that will store a list of threads with changes in them for each user. Something with one ForeignKey(User) and one ForeignKey(Thread) and just keep adding new entries each time a thread is posted or a post is added to a thread.
But then, I'm not sure how well that would scale with say several hundred threads after a while and maybe 50-200 users. So add 200 rows for each new post for the users who aren't logged on? Sounds like a lot.
How do other forum systems do it anyway? And how can I implement a system to work these things out in Django.
Thanks!