News for hackers. Stuff that matters.
Re:PopSQL – Modern, collaborative SQL editor for your team by devrandomguy on Monday October 02, 2017 @04:59PM (#15387904)
Or, we could just go all meta, in a Postgres shell:

  CREATE TABLE queries IF NOT EXISTS (
    name varchar(64),
    version varchar(64),
    query text,
    description text
  );

  NOTIFY chat 'Alice: Bob, please insert that query into the new queries table, and then NOTIFY "chat" with the name and version of it';
  LISTEN chat;

  Asynchronous notification "chat" with payload "Bob: See update-rank, v. borked-1" received from server process with PID 8448.
  Asynchronous notification "chat" with payload "Bob: I have it set to update in a temp table, so we don't have to reset the real table" received from server process with PID 8448.

  SELECT queries.query FROM queries WHERE name="update-rank" AND version="borked-1"
  INTO query;

  \echo query

  -- "Looks sane, let's run it"

  DO $$ EXECUTE query INTO result $$; -- Something like that, I'm guessing.

  \echo result
PL/PgSQL's EXECUTE is not to be confused with the EXECUTE that is used with stored procedures.

Bonus points if you edit the query by shelling out to sed or butterflies.

There are no comments on this comment yet.