Databases are put together in the order they come in, right?
No, they're not. There's no guaranteed order in a relational database table, except what you impose, either with an order by clause in a query, or with a clustered index. But other than that, it's like the FAQ: "Why don't my hash elements come out in the order I inserted them?" Because it's not organized that way. Since you're using an SDBM file, you may be able to get away with it (I'm not sure), but in a RDBMS, you cannot.

What exactly is a timestamp?
In principle, a timestamp is an unambiguous, server-generated value that represents a distinct point in time. Not all database platforms support it. Furthermore, the term is frequently (ab)used to mean any column that holds the time of day.

It looks like you're on the right track, and yes, if you want to do it right, you have to remember when a message got recorded. For a working example, you can see how the Chatterbox works. Go to Everything developer site and get the Emessage 0.9.1 nodeball.

In reply to Re: Retrieve last elements of a DB by VSarkiss
in thread Retrieve last elements of a DB by sulfericacid

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.