Postgrest JSON-LD support

artists.sql

-- Deploy miamp:artists to pg
-- requires: appschema

BEGIN;

SET client_min_messages = 'warning';

CREATE TABLE miamp.artists (
		id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    name      TEXT        NOT NULL,
    -- Musicbrainz link
    sameAs INET DEFAULT NULL,
    dateCreated TIMESTAMPTZ NOT NULL DEFAULT now(),
    dateModified TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE OR REPLACE FUNCTION iri(miamp.artists) RETURNS text AS 
$$
  declare iri text;
  begin
	perform set_config('response.headers',
      '[{"Content-Type": "application/ld+json"}]', true);
      select '/artists/' || $1.id into iri;
	return(iri);
  end
$$ LANGUAGE plpgsql; 

CREATE OR REPLACE FUNCTION context(miamp.artists) RETURNS text AS $$
    SELECT 'https://schema.org';
$$ language sql;

CREATE OR REPLACE FUNCTION type(miamp.artists) RETURNS text AS $$
    SELECT 'MusicGroup';
$$ language sql;

COMMIT;

Caddyfile

{
  debug
}

localhost

file_server

@resource path_regexp resource ^/api/([a-z_]+)/([a-z0-9-]+)$
@resources path_regexp resources ^/api/([a-z_]+)$

rewrite @resource /api/{re.resource.1}?id=eq.{re.resource.2}&select=*,"%40id":iri,"%40context":context
rewrite @resources /api/{re.resources.1}?select=*,"%40id":iri,"%40context":context,"%40type":type

handle /api/* {
  uri strip_prefix /api
  reverse_proxy postgrest:3000
}