HackerTrans
TopNewTrendsCommentsPastAskShowJobs

sfkeller

no profile record

Submissions

Does Kue bring true low-code to GIS analysis?

buntinglabs.com
3 points·by sfkeller·2 lata temu·2 comments

comments

sfkeller
·2 lata temu·discuss
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.
sfkeller
·3 lata temu·discuss
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
sfkeller
·3 lata temu·discuss
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.
sfkeller
·3 lata temu·discuss
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?
sfkeller
·3 lata temu·discuss
See also https://news.ycombinator.com/item?id=34684593
sfkeller
·5 lat temu·discuss
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?