Archive

2026

October
De-Orphanizing Modular Secretion Machinery in the Dark Proteome: A 0.64 Å Structural Match Across Extreme Halophiles
Vector Search in the Dark Proteome: Bridging Methanogens and Extreme Halophiles
Heatmapping the Dark Proteome: Visualizing Structural Correlations
Bypassing VRAM Limits: Domain Chunking Massive Proteins in pg_bio
Unearthing Hydrogenase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Protease: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Nuclease: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Nitrogenase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Kinase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Hydrogenase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Carbonic anhydrase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Amidase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Cellulase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Nitrate reductase: Exploring the Dark Proteome of Extreme Ecosystems!
Unearthing Topoisomerase: Exploring the Dark Proteome of Extreme Ecosystems!
September
Nature's Fertilizer Factory: Deep-Sea Heat and the Secret of Nitrogen Fixation!
Breath of the Boiling Springs: Unveiling an Extremophile's Secret Carbon Capture Engine
The Boiling Bubble Breaker: A Catalase Echo in a Hot Spring Archaeon
The Salt Lake Scrubber: Finding Methane-Eating Enzymes in a Sea of Pink
The Crimson Salt-Lover: Uncovering a Mystery Amidase in the Pink Lakes
Analyzing 3D Genomic Architecture and Hi-C Contact Maps with SQL
Validating the Dark Proteome: Genomic Synteny and PyMOL Alignment in PostgreSQL
Scaling ESM-2 Protein Embeddings: Fast Cosine Similarity in PostgreSQL
From Pink Salt Lakes to Boiling Acid: Hunting the Ultimate Plastic-Eating Machine
The Archaeal Hard Drive: Uncovering a Flawless Cas1 Memory Engine in Methanosarcina mazei
The Molecular Shredders of the Deep: Unearthing Halophilic Proteases
Bone-Crushers of the Salt Lakes: A Halophilic Secret to Breaking Down Collagen
The Asgardian Carbon Trap: Deep-Sea Microbes and the Quest for the Ultimate CO2 Engine
The Slime Mold and the Salt Lake: A Lysozyme Tale
The Six-Sided Donut of Survival: Uncovering a DNA Repair Motor in the Abyss
Illuminating the Unknown: How AI Revealed a Hidden Spark in the Soda Lakes
The Methane Makers' Secret: A Deep-Sea Factory for Biodegradable Plastic
How to Store and Query 3D Protein Structures in PostgreSQL (Moving Beyond PDB Files)
Decoding AI Vector Distances: Uncovering Thiamine Binders in the Dark Proteome
Mining the Dark Proteome: Legacy Code with Missing Docs
Indexing 3D Space like a Video Game: Finding Drug Targets in SQL
Writing a Hybrid Database Operator for Biology (<~>)
Why Proteins are just High-Dimensional Vectors (And how to query them in SQL)
The 27-Hour Index: Database Optimization and Indexing the Dark Proteome
Echoes in the Twilight Zone: Uncovering a Telomerase Cousin in a Methane-Breathing Archaeon
The Millet Beer Microbe That Might Eat Our Trash
Sifting the Protein Cosmos: Uncovering Fanzors in the Folds of the Dark Proteome
TeaFlon Synthetic Biology, Part 8: 3D Genomic Architecture and Plasmid Looping
Accelerating Claude's CRISPR Discovery: Equipping AI Agents with Native Bio-Databases
Introducing pg_bio: The PostgreSQL Bioinformatics Operating System
TeaFlon Synthetic Biology, Part 7: The 419 Limit, Local Inference, and pg_bio
TeaFlon (Part 6): Upgrading to TriFusion and Quantum Validation
TeaFlon (Part 5): Turning Toxic Waste into Solid Rock
TeaFlon (Part 4): Flashing the BIOS with Plasmids and Promoters
TeaFlon (Part 3): Compiling the Code in a Physics Simulator
Learning to Let Go: Leveraging PostgreSQL's Autovacuum for IVM
TeaFlon Part 2: The Swarm Architecture and Biomineralization
TeaFlon Part 1: Designing a Synthetic Enzyme to Digest Teflon
Vibe Coding Postgres Extensions with pgrx
Spiral: An Experiment in Geometry-Aware Storage for PostgreSQL
April
MCP and Fast: Grepping SQL Code Like a Boss Part 2
Where is your mind?
No Excuses
March
Saving LLM Tokens with Fast: AST Folding & Dependency Free
Ethics & Environment in Computing
The Math Behind the Yoga SVG
The Validation Model
Learning to Breathe
The Proxy Life Trap
Per-Plan Retention with TimescaleDB Dimensions
Git Worktrees: What They Actually Are and Why They Beat Stashing
My First Time with Claude Worktrees
First week at Hubstaff

2018

Retrospective 2018