HackerTrans
TopNewTrendsCommentsPastAskShowJobs

Xyra

155 karmajoined letztes Jahr
plane jane epistemic infrastructure

[email protected]

Submissions

Show HN: Use Claude Code to Query 600 GB Indexes over Hacker News, ArXiv, etc.

exopriors.com
397 points·by Xyra·vor 6 Monaten·142 comments

Show HN: Explore ArXiv/HN/LessWrong with SQL and Vector Algebra

exopriors.com
3 points·by Xyra·vor 7 Monaten·0 comments

Alignment Scry – LessWrong

lesswrong.com
1 points·by Xyra·vor 7 Monaten·1 comments

comments

Xyra
·vor 5 Stunden·discuss
making the internet sql queryable, crawling, cleaning, indexing, embedding many sources into source-aware schemas, solving contention problem with free-floating pricing.

Currently crawling over 1M records/sec. software is still in alpha.

scry.io.

goal is a 10PB NVMe cluster online by November (need funding champions) as a public benefit project, so prosocial researchers and builders and their agents can have low-friction access to running analytical queries over the public internet.
Xyra
·vor 6 Monaten·discuss
Hetzner, Postgres, Rust, SvelteKit
Xyra
·vor 6 Monaten·discuss
What did you think?
Xyra
·vor 6 Monaten·discuss
emailed you, and it's https://venmo.com/u/XyraSinclair.
Xyra
·vor 6 Monaten·discuss
We can iterate fast with understanding useful paradigms of vector manipulation. Yesterday I added `debias_vector(axis, topic)` and l2_normalization guidance.
Xyra
·vor 6 Monaten·discuss
Thank you! I got the idea December 3, and initially released it December 19.
Xyra
·vor 6 Monaten·discuss
I'm raising at least $175k and doing a serious startup.
Xyra
·vor 6 Monaten·discuss
Thanks, that's very interesting.
Xyra
·vor 6 Monaten·discuss
~300 token chunks right now. Have other exciting embedding strategies in the works.
Xyra
·vor 6 Monaten·discuss
The scale is there. I'm scraping, cleaning, token efficientizing dozens of sources every single hour. The lack of monies for embedding everything was a temporary problem.
Xyra
·vor 6 Monaten·discuss
in the direction of "empowering the public with new capabilities they didn't have before", Scry offers, with the copy and paste of a prompt and talking with an agent:

1) Full readonly-SQL + vector manipulation in a live public database. Most vector DB products expose a much narrower search API. Basically only a few enterprise level services let you run arbitrary SQL on remote machines. Google BigQuery gives users SQL power, but it mostly doesn't have embeddings, connect public corpora, have as good of indexes, and doesn't have support an agentic research experience. Beyond object-level research, Scry a good tool for exploring and acquiring intuitions about embedding-space.

2) An agent-native text-to-SQL + lexical + semantic deep research workflow. We have a prompt that's been heavily optimized for taking full advantage of our machine and Claude Code for exploration and answering nuanced questions. Claude fires off many exploratory queries and builds towards really big queries that lean on the SQL query planner. You can interrupt at any time. You have the compute limits to do lots of exhaustive exploration--often more epistemically powerful than finding a document often, is being confident than one doesn't exist.

3) dozens of public commons in one database, with embeddings.
Xyra
·vor 6 Monaten·discuss
Thank you! I'll be getting millions more quality, embedded documents, it'll be here just getting more useful.
Xyra
·vor 6 Monaten·discuss
Thank you!
Xyra
·vor 6 Monaten·discuss
You submit a SQL query to periodically run, we run it and store the results. As we ingest more documents (dozens of sources are being ingested every day), we run it again. If there's different outputs, you get an email.
Xyra
·vor 6 Monaten·discuss
Maybe more actually, server costs and API credits for my agent-coordination research are expensive.
Xyra
·vor 6 Monaten·discuss
Exactly, people want precision and control sometimes. Also it's very hard to beat SQL query planners when you have lots of material views and indexes. Like this is a lot more powerful for most use cases for exploring these documents than if you just had all these documents as json on your local machine and could write whatever python you wanted.

Yeah I've out a lot of care into rate-limiting and security. We do AST parsing and block certain joins, and Hacker News has not bricked or overloaded my machine yet--there's actually a lot more bandwidth for people to run expensive queries.

As for getting good semantic queries for different domains, one thing Claude can do besides use our embed endpoint to embed arbitrary text as a search vector, is use compositions of centroids (averages) of vectors in our database, as search vectors. Like it can effortlessly average every lesswrong chunk embedding over text mentioning "optimization" and search with that. You can actually ask Claude to run an experiment averaging the "optimization" vectors from different sources, and see what kind of different queries you get when using them on different sources. Then the fun challenge would be figuring out legible vectors that bridge the gap between these different platform's vectors. Maybe there's half the cosine distance when you average the lesswrong "optimization" vector with embed("convex/nonconvex optimization, SGD, loss landscapes, constrained optimization.")
Xyra
·vor 6 Monaten·discuss
Thank you, I've started ingestion operations of pubmed.
Xyra
·vor 6 Monaten·discuss
What is hyperbole? We are collectively experiencing a software intelligence explosion (people are shipping good software at prolific rates now due to Opus 4.5 and GPT-5.2-Codex-xhigh). With Scry, you can run arbitrary SELECT SQL statements over a large corpus and have an easier time composing embedding vectors in whatever mathematical ways you want, than any other tool I've seen.
Xyra
·vor 6 Monaten·discuss
I've since improved it, and also discovered a new method of vector composition I have added as a first-class primitive:

debias_vector(axis, topic) removes the projection of axis onto topic: axis − topic * (dot(axis, topic) / dot(topic, topic))

That preserves the signal in axis while subtracting only the overlap with topic (not the whole topic). It’s strictly better than naive subtraction for “about X but not Y.”
Xyra
·vor 6 Monaten·discuss
Yes, thanks for explaining it.