It would be nice if sqlite stored a change count in the database that was
easily accessible.
CREATE TABLE counter_table(n INTEGER);
INSERT INTO counter_table VALUES(0);
CREATE TRIGGER counter_trigger_insert
AFTER INSERT ON yourtable
FOR EACH ROW BEGIN
UPDATE counter_table SET n = n + 1;
END;
> but it seems like only changes made through the connection I call the
> function on are counted.
This is correct.
The documentation is misleading and should mention this limitation.
> Is there any way to get the total number of
> changes made through all opened connections?
Get the numbers
2 matches
Mail list logo