Does the QGIS plugin "Kue" finally enable non-technical users, including students, to learn a tool like QGIS?
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.
Here's an implementation with lines of sql and pl/pgsql:
Given a table mytable with an pk id and say the fields 'block' and 'hash', replace it with mytable_changes and add an "internal" field called created_at of type "timestamp not null default now()".
Then create this trigger function (e.g. PostgreSQL):
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.
Couldn't you implement this in "pure" SQL by using psql-http https://github.com/pramsey/pgsql-http (from Crunchy ) for the webservice calls to OpenAI API?
Promising project.
1. Is there a possibility to limit the ressources allocated to a user?
2. Is there a reason that there's no (possibly restricted) online demo of NocoDB?
Did someone say innovative database? PG-Strom with PostgreSQL under the hood (what else?) exists since over 4 years: https://github.com/heterodb/pg-strom
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.