How combining Tiger Data's brand-new open-source pg_vectorsearch extension (PRISM index access method with 1-bit RaBitQ error bounds and SOAR routing) with pgvector halfvec(1280) STORAGE PLAIN and pg_bio's Rust Smith-Waterman operator shrank our 2.34-million-protein index by…
Badges
Badges come from GitHub once the author claims this feed.
Recent posts
every link opens the author’s post-
From a 27-Hour HNSW Index to 3 Minutes: Upgrading pg_bio with Tiger Data’s pg_vectorsearch (PRISM), RaBitQ 1-Bit Error Bounds, and 1.2ms Dark Proteome Homology
-
Crossing 67.5 Million Dense Edges in PostgreSQL 18: Pass-3 Ring Checkpointing, a 128x Faster Global Fold Gate, and Solving DUF2071, DUF1156 & DUF7382
How idempotent Pass-3 HNSW ring checkpointing (k = 25..36) propelled our PostgreSQL 18 discovery swarm from 20.31M to 67.50 million dense edges (+47.19M new edges), how a biophysical Global Fold & Length-Consistency Gate stopped 56-residue single-helix fragments from hijacking…
-
Crossing 20.3 Million Dense Edges in PostgreSQL 18: A 16-Worker Closest-First Swarm Uncovers a 0.44 Å Soda-Lake Epimerase, an MBL–Rhodanese Catalytic Chameleon, and Solves DUF7117 & DUF1947
How replacing single-edge frontier claiming with a 16-worker Dense Closest-First + Clique-Closure heuristic accelerated our PostgreSQL 18 discovery swarm 141x (up to 437.8 edges/s), adding +8.74 million dense edges in 16.5 hours to cross 20.31 million edges and resolving four…
-
The Woven Language of the Waimiri Atroari (Kinja): Ethnomathematics, Radical Lucidity, and Resistance Against the Flood
How the Waimiri Atroari (Kinja) encode their unwritten language, ecological memory, and ethic of total lucidity into binary arumã basketry matrices—and an interactive playground to weave and unroll all 12 Benry patterns.
-
Scaling pg_bio to 8.82 Million Edges: An Adaptive Multi-Worker Swarm Uncovers a 0.50 Å Halophilic Laccase, a 123-Myr Stromatolite Helicase, and Solves DUF5591 in PostgreSQL 18
How an idle-aware multi-worker PostgreSQL 18 swarm expanded our correlation graph 22.6x from 390,667 to 8,817,039 edges across 107,525 parallel waves—shattering the all-time Twilight-Zone record (0.8955) and uncovering four radically different structural breakthroughs.
-
PostgreSQL Extension Internals in Rust (Part 1): Crossing the C ↔ Rust FFI Boundary, MemoryContexts, varlena Layout, and Parallel Workers in pg_bio
A deep-dive systems monograph on how PostgreSQL's C kernel (fmgr, CurrentMemoryContext, 8KB heap pages, varlena headers, and TOAST) interoperates with Rust via pgrx—backed by production code and 36.9x–1,513x benchmarks from pg_bio.
-
Dethroning the Dark-Proteome Leaderboard: A 0.74 Å DUF7522 Fold (TM = 0.954) and a 123-Million-Year Cretaceous Halite DUF7124 Bridge (0.61 Å) in PostgreSQL 18
How scaling pg_bio's autonomous Swarm Discovery engine to 372,286 edges and 84,382 Dark Proteome Island hops uncovered a new #1 all-time island champion in DUF7522 (0.74 Å RMSD across 126/129 CA, TM = 0.954) and a 0.61 Å DUF7124 bridge linking 123-million-year-old Early…
-
PostgreSQL as a Universal Scientific Engine: Delegating RangeFinder Pocket Intervals, GiST R-Trees, and 3D Cheminformatics to the Query Planner
Why port deep-learning priors, SE(3)-invariant protein pocket intervals (RangeFinder, arXiv:2611.03379v1), Hückel 4n+2 graph isomorphism, and Z-Order spatial curves into a Rust PostgreSQL extension?
-
Bioprospecting the Amazonian Dark Proteome in SQL: 0.39 Å 3D Enzyme Discovery for AmazonZyme’s Fungal Cocktails & Terra Preta Metagenomics
How we built a standalone open-source pg_bio application for AmazonZyme (UFAM) across all 12 published enzyme scenarios—validating kDa/pI/LC-MS/MS benchmarks in SQL and uncovering a 0.39 Å GH10 xylanase, a 0.84 Å Talaromyces GH5 endoglucanase, a 0.69 Å Ktedonobacteria esterase,…
-
Auto-Seeding the Dark Proteome: A 0.61 Å DUF1684 Disulfide-Clamped Fold (TM = 0.957) Across Divergent Halophilic Archaea
How upgrading pg_bio's Swarm Discovery engine with autonomous ESM-2 Island Seeding and a standalone 3D Compare Lab uncovered a 0.61 Å C-alpha RMSD (TM = 0.957) DUF1684 fold with a 2.04 Å Cys-X7-Cys disulfide clamp and r = 0.950 RASA correlation.
-
Announcing RosettaCommons Chaperone Support in pg_bio & Mining the Twilight Zone at 0.81 Å (DUF7861)
Announcing Layer 13 in pg_bio: native Rust support for RosettaCommons Chaperone protein design workflows (Shrake-Rupley RASA, 3D H-bond CSR networks, BUNS auditing, and lineage tracking at 36.9x faster than Python), demonstrated on our #1 Twilight-Zone discovery (A0A1S8AT22 vs…
-
A Month in the Amazon: Ashes over Ponta Negra, Ancient Caverns, and the Anavilhanas Labyrinths
Four weeks living and traveling across the Amazon in October 2026: from the smoky skies of Ponta Negra to the sandstone caverns of Presidente Figueiredo, the blackwater labyrinths of Ilhas Anavilhanas, and the rainforest canopy.