Christophe Marois christophemarois

With the following generic trigger function:

CREATE OR REPLACE FUNCTION allow_updating_only()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
DECLARE
  whitelist TEXT[] := TG_ARGV::TEXT[];
  schema_table TEXT;

Use Caddy (brew install caddy) to run localhost sites with custom addresses and https certificates.

Run caddy reverse-proxy --from site.localhost --to localhost:3000
Visit https://site.localhost/

For a more stable config, create a Caddyfile

site.localhost {
 reverse_proxy localhost:3000

Remove a file from git

Accidentally committed a 4GB file and GitHub (rightly) doesn't let you push? Commited a .env with your social insurance number?

Back up the entire repo
Run bfg --delete-files [filenames...] (brew install bfg)
Follow instructions

Run a local Dockerfile with a local .env file

docker build \

Show complete log

--progress=plain \

Nested dockerfile, useful for monorepos when we want to preserve CWD

	/** Array where are elements are expected to be unique by a custom key */
	export function zUniqueArray<
	ArrSchema extends z.ZodArray<z.ZodTypeAny, 'many'>,
	UniqueVal,
	>(
	uniqueBy: (item: z.infer<ArrSchema>[number]) => UniqueVal,
	schema: ArrSchema,
	) {
	return schema.superRefine((items, ctx) => {
	const seen = new Set<UniqueVal>()

	# list changed files in a branch compared to its base branch
	# usage: git_list_branch_changes [base_branch?] \| xargs echo
	function git_list_branch_changes {
	local BASE_BRANCH="${1:-main}"
	(git diff --diff-filter=MA --name-only $BASE_BRANCH... && git status --short --porcelain \| awk '{print $2}') \| sort -u
	}

	import { parseArgs } from 'node:util'

	const args = parseArgs({
	options: { env: { type: 'string' }, dryRun: { type: 'boolean' } },
	})

	// will act --inspect-brk, but only when evaluated
	// works inside the main thread, a worker thread
	// also works with typescript sources, built-in support in tsx
	require('node:inspector').open(undefined, undefined, true)

	import wretch, { WretchResponse } from 'wretch'
	import fs from 'node:fs'

	async function streamWretchResponseToFile(
	res: WretchResponse,
	writable: fs.WriteStream,
	) {
	if (!res.body) {
	throw new Error('Response body is null')
	}

	// Type inference does not work yet
	export function zMapKeys<
	Shape extends z.ZodRawShape,
	T extends z.ZodObject<Shape>,
	Key extends keyof Shape,
	MapFn extends <T extends Key>(v: Shape[T], k: T) => PropertyKey,
	>(schema: T, renameMap: Record<Key, PropertyKey \| MapFn>) {
	const keys = Object.keys(schema.shape) as Key[]
	return schema.transform((input) => {
	let output: Record<PropertyKey, any> = {}