Skip to content

Instantly share code, notes, and snippets.

View tomchapin's full-sized avatar

Tom Chapin tomchapin

View GitHub Profile
@tomchapin
tomchapin / AGENTS.md
Created December 5, 2025 02:53 — forked from spenceriam/AGENTS.md
Xuanwo's AGENTS.md (converted to English)

0 · About the User and Your Role

  • The person you are assisting is User.
  • Assume User is an experienced senior backend/database engineer, familiar with mainstream languages and their ecosystems such as Rust, Go, and Python.
  • User values "Slow is Fast", focusing on: reasoning quality, abstraction and architecture, long-term maintainability, rather than short-term speed.
  • Your core objectives:
    • As a strong reasoning, strong planning coding assistant, provide high-quality solutions and implementations in as few interactions as possible;
    • Prioritize getting it right the first time, avoiding superficial answers and unnecessary clarifications.

Title: Senior Engineer Task Execution Rule
Applies to: All Tasks
Rule:
You are a senior engineer with deep experience building production-grade AI agents, automations, and workflow systems. Every task you execute must follow this procedure without exception:
1.Clarify Scope First
•Before writing any code, map out exactly how you will approach the task.
•Confirm your interpretation of the objective.
@tomchapin
tomchapin / main.ts
Created July 22, 2024 15:42 — forked from sadalsvvd/main.ts
autonomous LLM graph script
import dotenv from "dotenv";
import Anthropic from "@anthropic-ai/sdk";
import { setTimeout } from "timers/promises";
import * as fs from "fs/promises";
import { getSession } from "./neo4j";
// Configuration and Initialization
dotenv.config();
const anthropic = new Anthropic({
@tomchapin
tomchapin / postgres_queries_and_commands.sql
Created September 6, 2018 02:04 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

What I Wish I'd Known About Equity Before Joining A Unicorn

Disclaimer: This piece is written anonymously. The names of a few particular companies are mentioned, but as common examples only.

This is a short write-up on things that I wish I'd known and considered before joining a private company (aka startup, aka unicorn in some cases). I'm not trying to make the case that you should never join a private company, but the power imbalance between founder and employee is extreme, and that potential candidates would

Git Cheat Sheet

Commands

Getting Started

git init

or

git clone url

@tomchapin
tomchapin / mandelbrot.sql
Last active August 29, 2015 14:25 — forked from rupey/mandelbrot.sql
Mandelbrot plot in postgres
WITH RECURSIVE
x(i) AS ( VALUES (0)
UNION ALL SELECT i + 1
FROM x
WHERE i < 101),
Z(Ix, Iy, Cx, Cy, X, Y, I) AS (
SELECT
Ix,
Iy,
X :: FLOAT,
--database=postgresql
--skip-test-unit
--skip-bundle
--template=https://gist.github.com/jwaldrip/5538342/raw/rails-template.rb
@tomchapin
tomchapin / .railsrc
Last active December 17, 2015 03:09 — forked from jwaldrip/.railsrc
--database=postgresql
--skip-test-unit
--skip-bundle
--template=https://gist.github.com/tomchapin/5541218/raw/rails-template.rb