Skip to content
View Ashilman25's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report Ashilman25

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Ashilman25/README.md

Andrew Shilman: fullstack / systems / AI / databases

terminal: whoami and what I'm working on neural network learning to classify two spirals
a small neural net learning to untangle two spirals, trained from scratch in numpy (pure SVG + CSS, no JS)

Featured work

  • ShilmanDB: a relational database engine in C++ built from scratch (SQL parser, B+ tree index, Volcano-style executor, buffer pool). Its learned join-order optimizer hits 94.1% exact-match accuracy, and a learned eviction policy beats LRU by 3.64% hit rate.
  • text2sql-router small LLMs are cheap but often write wrong SQL. A 7B model answers every question first, its SQL is run, and a classifier trained on what happened (did it execute, what came back, token confidence, agreement across retries) decides which questions to escalate to a 32B. It matches the 32B's accuracy while paying for it on only 30% of questions (29% of the API cost), and on 68 databases it never trained on, it scores 2.4 points above the 32B while escalating just 20%.
  • NN-Steiner reproduction: reproduced an AAAI 2024 paper where a neural network guides rectilinear Steiner tree construction for chip wire routing. Found the commented-out step that kept the authors' own model from matching their paper, then trained our own model that ties theirs (2.73% vs 2.65% above optimal) using about 1/36 of the paper's training. Solving each problem in its 8 rotations and mirror images and keeping the shortest tree cuts our error to 1.76% with no retraining (theirs: 1.87%).
  • LLM agents in production: agent pipelines processing 20k+ signals a week, every prompt change gated by an eval harness (golden-file regression tests plus an LLM-as-judge at 92% agreement), with 66% lower cost per run from prompt caching and token budgets.

Pinned Loading

  1. ShilmanDB ShilmanDB Public

    A relational database engine built from scratch in C++, featuring two learned ML components: a neural network join order optimizer and a learned buffer pool eviction policy.

    C++ 1

  2. nn-steiner-rsmt nn-steiner-rsmt Public

    Reproducing NN-Steiner (AAAI 2024) for rectilinear Steiner trees: found a switched-off step in the authors' code, trained our own model that ties theirs (2.73% vs 2.65% above optimal), and cut it t…

    Jupyter Notebook 1

  3. text2sql-router text2sql-router Public

    Execution-based routing between a small and a large LLM for text-to-SQL. A 7B answers first, a classifier on its executed SQL decides when to escalate to a 32B. Matches the 32B on BIRD Mini-Dev at …

    Python 1

  4. SchemaSense SchemaSense Public

    Full stack database design and querying platform that enables visual schema modeling, NL-to-SQL generation, and real time PostgreSQL management.

    Python 1

  5. CSE498/Spring2026-CompanyC CSE498/Spring2026-CompanyC Public

    Course repository for Spring 2026 session of CSE 498, Section 2 (Company C - Social)

    C++ 2 5

  6. MedAI MedAI Public

    Built a full-stack AI medical RAG pipeline that ingests domain literature and performs vector retrieval to generate grounded, citation-aware clinical answers.

    JavaScript 1