edin-m/ring_buffer.sql

## ring_buffer.sql
-- 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;
	-- 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;