support deleting old sessions

admin/delete_old_sessions. (there is also an admin/delete_old_revisions and admin/repair_references)

--Ethan McCutchen.....2013-04-09 20:52:31 +0000

What is a "session" ?

--John Abbe.....2013-04-20 20:31:47 +0000

wagn's current db structure:

mysql> show tables;
+-------------------------+
| Tables_in_en_copy       |
+-------------------------+
| card_references         |
| card_revisions          |
| cards                   |
| schema_migrations       |
| schema_migrations_cards |
| sessions                |
| users                   |
+-------------------------+
7 rows in set (0.00 sec)

The first three are core and are there to stay. The others:

schema_migrations: a rails table for tracking whether the db structure is up to date with the code
schema_migrations_cards: a Wagn clone of the above for tracking whether card data is up to date with the code
sessions: another Railsy table for handling session data. We don't store any real valuable information in a cookie; all we store is the session id, and we keep the real data in the table. See http://guides.rubyonrails.org/security.html#session-storage. The present ticket is about being able to empty out stale data from that table.
users: a Wagn table, but one that will soon be integrated into cards.

--Ethan McCutchen.....2013-04-20 21:01:38 +0000

So sessions refers to browser sessions, thx...

--John Abbe.....2013-04-20 21:41:48 +0000