I'm using Apache::Session to store session state in a PostgreSQL database. If the user hits the logout button, I can call the delete() method on the tied session object, but if the user just goes away, their session data lives on forever in the database table. What method do people use for cleaning up old sessions?

I considered adding a timestamp column to the session table and defining a trigger to update this column on any insert or update. Then I could run a simple delete statement to delete rows where the timestamp value is say more than a couple of hours old. This seemed like it might be reinventing the wheel but I can't see anything in the Apache::Session docs that looks like a standard way of doing it.

Super search pulled up this node which seems to imply that simply adding a column called 'time' would cause Apache::Session::MySQL to update the timestamp on each save, but I couldn't see anything in the code to support that assertion.

In reply to Cleaning Up Apache::Session data by grantm

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.