HackerTrans
TopNewTrendsCommentsPastAskShowJobs

sfkeller

no profile record

Submissions

Does Kue bring true low-code to GIS analysis?

buntinglabs.com
3 points·by sfkeller·2 tahun yang lalu·2 comments

comments

sfkeller
·2 tahun yang lalu·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 tahun yang lalu·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 tahun yang lalu·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 tahun yang lalu·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 tahun yang lalu·discuss
See also https://news.ycombinator.com/item?id=34684593
sfkeller
·5 tahun yang lalu·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?