elyezer

-- Example table
CREATE TABLE ring_buffer (id INTEGER PRIMARY KEY AUTOINCREMENT, data TEXT);

-- Number 10 on where statement defines the ring buffer's size
CREATE TRIGGER delete_tail AFTER INSERT ON ring_buffer
BEGIN
    DELETE FROM ring_buffer WHERE id%10=NEW.id%10 AND id!=NEW.id;
END;