fastcat

create table x (
    p int4 not null,
    i int4 not null,
    f int4 null,
    primary key (p, i),
    foreign key (p, f) references x (p, i)
)
partition by list (p);
create table x1 partition of x for values in (0);

fastcat

#!/bin/bash

dev=/dev/serial/by-id/usb-239a_Adafruit_Industries-if00
# prefix byte for all commands
pfx='\xfe'
# named commands, associative array, start as just the hex chars
declare -A cmd=(
	[on]=42\\xff # macro for below
	[on2]=42 # +1 # arg ignored
	[off]=46