Simple "ring buffer" table. Mainly intended to be the most basic example of how logging can be implemented in SQLite

Simple "ring buffer" table

DROP TABLE IF EXISTS ring_log;
CREATE TABLE ring_log (
    timestamp INT,
    data TEXT
);

CREATE TRIGGER remove_oldest BEFORE INSERT ON ring_log
WHEN  ( SELECT COUNT(*)>5  FROM ring_log )
BEGIN
         DELETE FROM ring_log WHERE timestamp in ( SELECT timestamp FROM ring_log LIMIT 1 );
END;