Martin Kraft mkraft

Update a PDF custom property named "signature":

exiftool -config exiftool_config -signatures='[{"page":1,"x":342,"y":646}]' -form_data='[{"name":"POS-010[0].Page2[0].Sign[0].SigDate[0]","value":"[date]"}]' my.pdf

Verify the values:

exiftool  -config exiftool_config -signatures -form_data my.pdf

Get the oldest review date of an Udemy course, since they hide the course creation date.

Requires htmlq and jq.

Example usage:

$ ./udemy-oldest-review.sh graphql-with-react-course
2017-02-15T08:53:45-08:00

foreign data wrappers POC

local test setup

docker run \
    --name pg-playground \
    -p 5432:5432 \
    -e POSTGRES_DB=manifest \
    -e POSTGRES_USER=mmuser \

startup:

docker-compose up

psql in each a node, if desired (nodes are pg-source, pg-replica1, and pg-replica2):

docker exec -it pg-source bash -c 'PGPASSWORD=my_password psql -U my_user -d my_database -P pager=off -P expanded=auto'

read replication log sequence number (LSN) position:

	model
	schema 1.1

	type user

	type document
	relations
	define reader: [user] or writer
	define writer: [user] or owner
	define owner: [user]

	package main

	import (
	"encoding/base64"
	"fmt"
	"iter"
	"strconv"
	"time"
	)