create function mytable_changes_trigger() returns trigger as $$
begin
if (tg_op = 'insert') then
insert into mytable_changes (block, hash)
values (new.block, hash);
return new;
if (tg_op = 'delete') then
insert into mytable_changes (block, hash)
values (old.block, old.hash);
return old;
elsif (tg_op = 'update') then
insert into mytable_changes (block, hash)
values (old.block, old.hash);
return new;
end if;
end;
$$ language plpgsql;
And create this trigger: create trigger mytable_changes
after insert, update or delete on mytable
for each row
execute function mytable_changes_trigger();
What's left as an exercise is that the hash of the prev. block is being preprended.
From the homepage: Kue can be used to edit symbology, search for datasets, add base maps, and more. It sends a limited amount of QGIS project data to the cloud for LLM processing, such as layer and attribute names. It is freemium and requires a subscription of $19, with the first month free.