Michael Fairchild fairchild

PostgreSQL is Enough

Background and Cron Jobs

Purpose

Bootstrap knowledge of LLMs ASAP. With a bias/focus to GPT.

Avoid being a link dump. Try to provide only valuable well tuned information.

Prelude

Neural network links before starting with transformers.

Ruby and Postgres Regular Expression Syntaxes

Ruby's regular expressions are unusually powerful. Postgres' regular expressions are not as powerful, but they come close; close enough that it's possible to do many pattern-based queries and string transformations entirely in a query.

And sometimes, it's very useful to have a single regular expression that works

	import os

	import arel
	from fastapi import FastAPI, Request
	from fastapi.templating import Jinja2Templates

	app = FastAPI()
	templates = Jinja2Templates("templates")

	if _debug := os.getenv("DEBUG"):

	#!/usr/bin/env ruby
	# Generate a dbdiagram for dbdiagram.io from a dbt project.
	#
	# Usage:
	# 1. Run `dbt docs generate` first.
	# 2. Run `dbt_to_dbdiagram.rb`
	# 3. Paste the output in https://dbdiagram.io/

	require 'yaml'
	require 'json'

	addEventListener('fetch', event => {
	event.respondWith(handleRequest(event.request))
	})

	/**
	* Respond to the request
	* adapted from https://github.com/xiaoyang-liu-cs/workers-proxy
	* @param {Request} request
	*/
	async function handleRequest(request) {

	#!/usr/bin/env python
	import json
	import copy
	import sys
	import argparse
	from datetime import datetime, timedelta
	from subprocess import Popen, PIPE


	# dictionary of partiton names to variable generating functions