Jay Taylor jaytaylor

Legend: [ ] Incomplete, [X] Complete

Evidence for every completed checklist item must include the exact verification command (wrapped with backticks) plus its exit code and artifacts (logs, screenshots, .scratch transcripts) directly beneath the item when the work is performed.

Sprint #047 – DTU Google OAuth Emulator (Okta-backed)

Objective

Deliver a Google-compatible OAuth 2.0 / OIDC provider surface (auth, token, userinfo, revoke, JWKS, discovery) that apps can target via GOOGLE_CLIENT_ID/SECRET/ENDPOINT, while brokering identity through Okta and offering an admin UI + YAML-driven registry for client apps. Success means drop-in behavior with google-auth SDKs, enforceable redirect/source policies, PKCE + offline refresh support, and first-class CRUD for app credentials inside DTU.

Context & Problem

AI CLI Coding Tools: A Developer's Guide

The landscape of AI-powered command-line coding assistants has exploded recently, each taking a different philosophical approach to the same fundamental problem: how do we make writing code less tedious without sacrificing control? Here's a breakdown of four notable players worth your attention.

The Contenders

*_preserving_parent_mtime.py

Python programs to remove or modify files without changing the modification time of the parent directory.

Quick Install

curl -fSLO https://gist.github.com/jaytaylor/e2e0b53baf224f4e973b252370499de7/raw/bc175ba7008626ebc3f356c16f8240ebe578c5a0/rm_preserving_parent_mtime.py
curl -fSLO https://gist.github.com/jaytaylor/e2e0b53baf224f4e973b252370499de7/raw/bc175ba7008626ebc3f356c16f8240ebe578c5a0/mv_preserving_parent_mtime.py
chmod a+x rm_preserving_parent_mtime.py mv_preserving_parent_mtime.py

HOWTO: Insert a timestamp without timezone into postgres using Python

Background

I searched the net high and low but was unable to locate a definitive working example of how to take an epoch integer timestamp and insert it as a native postgres timestamp without timezone.

CREATE TABLE IF NOT EXISTS tz_test (
 stamp TIMESTAMP NOT NULL

HOW TO: zstd

Why?

Way faster than bzip2, it's basically streaming compression with comparable compression levels.

Compress

tar -cvf - foo | zstd -f --no-progress -o foo.tar.zst

cat > /tmp/install-go.sh << 'EOF'
#!/usr/bin/env bash

set -o errexit
set -o pipefail
set -o nounset

if [ "${1:-}" = '-v' ]; then
 echo 'INFO: Verbose debug output enabled' 1&gt;&amp;2

Python programming skeleton snippets

Quick references to common and useful python3 best-practices programming snippets and boilerplate.

See also: JayTaylor's Bash boilerplate skeleton snippets

	#!/usr/bin/env python3

	"""
	JSON object merge tool.

	Based on mergedeep and Python3 JSON Stream State Machine.

	References:

	https://github.com/clarketm/mergedeep

	#!/usr/bin/env bash

	##
	# @description Golang Linux installer.
	#
	# Example usage:
	#
	# VERSION=1.17.3 sudo -E bash install-go.sh
	#
	# @date 2021-02-18

	/*
	* RichSQL.scala
	*
	* @note I originally found this at
	* http://scala.sygneca.com/code/simplifying-jdbc. Since sourcing it I have
	* made some improvements.
	* -Jay T.
	*/

	import java.sql.ResultSet