dystopiandev

using AutoStep.Extensions;
using Microsoft.Extensions.DependencyModel;
using NuGet.Common;
using NuGet.Configuration;
using NuGet.Frameworks;
using NuGet.Packaging;
using NuGet.Packaging.Core;
using NuGet.Packaging.Signing;
using NuGet.Protocol.Core.Types;
using NuGet.Resolver;

dystopiandev

Based on this blogpost.

Install with Homebrew:

$ brew install postgresql

Run server:

dystopiandev

import * as pulumi from "@pulumi/pulumi";
import * as hc from "@pulumi/hcloud";
import { randomUUID } from "crypto";

interface DynamicProviderOutputs {
    name: string
    configuration: {[index:string]: any};
}

class CtrlConfigurationProvider implements pulumi.dynamic.ResourceProvider {

dystopiandev

CREATE OR REPLACE FUNCTION table_update_notify() RETURNS trigger AS $$
DECLARE
  id bigint;
BEGIN
  IF TG_OP = 'INSERT' OR TG_OP = 'UPDATE' THEN
    id = NEW.id;
  ELSE
    id = OLD.id;
  END IF;
  PERFORM pg_notify('table_update', json_build_object('table', TG_TABLE_NAME, 'id', id, 'type', TG_OP)::text);