Julien LEFORT wrote:
This looks like a great solution. Just another point,
what if I want to fill this "ring buffer" automatically by using triggers on
other tables, and be able to reset the counter of the ring buffer when I
arrive at the max integer value of the primary key.
--Create
This looks like a great solution. Just another point,
what if I want to fill this "ring buffer" automatically by using triggers on
other tables, and be able to reset the counter of the ring buffer when I
arrive at the max integer value of the primary key.
For example :
-- the table to be used
in <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Tuesday, December 20, 2005 11:02:39 AM
Subject: [sqlite] limiting table size?
Hi All,
I'm considering using SQLLite for an embedded project. Some of the data
I'd like to store is
timestamped sensor readings. I'd like to know if there is a
Adler, Eliedaat wrote:
Sean Wrote ===
I'm considering using SQLLite for an embedded project. Some of the
data I'd like to store is timestamped sensor readings. I'd like to know
if there is a way to >configure a table so that it acts like a fixed
length FIFO queue, e.g. stores 10,000
>Sean Wrote ===
>I'm considering using SQLLite for an embedded project. Some of the
data I'd like to store is timestamped sensor readings. I'd like to know
if there is a way to >configure a table so that it acts like a fixed
length FIFO queue, e.g. stores 10,000 records then once full drops off
Since you are using a time your could try using a trigger which deleted
the row with the oldest (lowest) time. You would need to have an index
on the timestamp. I guess something like timestamp > 0 LIMIT 1 might work.
Sean Machin wrote:
Hi All,
I'm considering using SQLLite for an embedded
Hi All,
I'm considering using SQLLite for an embedded project. Some of the data
I'd like to store is
timestamped sensor readings. I'd like to know if there is a way to
configure a table
so that it acts like a fixed length FIFO queue, e.g. stores 10,000
records then once full
drops off the
7 matches
Mail list logo