sfkeller

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.

Try Photon as better front end to OSM.

And at least from now on, also OSM Nominatim now will "Wilsons Prom" afer I added this obvious local name: https://www.openstreetmap.org/relation/2693245

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?

See also https://news.ycombinator.com/item?id=34684593

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