> > That works but what do you sort by to get the entries in order? > > You can either just use a simple sequence and then delete where sequence > mod <number of records to keep> = 0 (hrm... does sqlite support > functional indexes?), or just add a timestamp to the table.
most people that implement a ring buffer are wanting a fixed sized log file to record activity. I understand that the delete by modulus does that. Now you have a log of entries. The next step is to read them out, in date order, so you can review the log. Timestamping the table doesn't help, you need to timestamp the rows.
