HNHacker News
TopNewBestAskShowJobs

_peregrine_

175 karma · joined May 18, 2022

technical writer + editor. I generally share stuff written by my peers. Currently @ turbopuffer
submissionscomments
_peregrine_··on The Sane Asylum – A love letter to Turbopuffer
as a tpuf employee i can say we feel very well represented in this article. author did a really nice job. good read too
_peregrine_··on RIP, vector database
confirmed - we still write by hand
_peregrine_··on LLM Cliché Highlighter
instant bookmark!
_peregrine_··on ANN v3: 200ms p99 query latency over 100B vectors
this is actually not how cursor uses turbopuffer, as they index per codebase and thus need many mid-sizes indexes as opposed to one massive index as this post describes
_peregrine_··on ANN v3: 200ms p99 query latency over 100B vectors
unfortunately i'm not able to share the customer or use case :( but the metrics that you see in the first charts in the post are from a production cluster
_peregrine_··on ANN v3: 200ms p99 query latency over 100B vectors
the solution described in the blog post is currently in production at 100B vectors
_peregrine_··on ANN v3: 200ms p99 query latency over 100B vectors
seems like a good rule of thumb to me! though i would perhaps lump "cost" into the "until it breaks" equation. even with decent perf, pg_vector's economics can be much worse, especially in multi-tenant scenarios where you need many small indexes (this is true of any vector db that builds indexes primarily on RAM/SSD)
_peregrine_··on How to ingest 1B rows/s in ClickHouse
yeah I mean that's basically what Javi talks about in the post... if you can throw hardware at it you can scale it (ingestion scales linearly with shards)

but the post has some interesting thoughts on how you do the high-scale ingestion while also handling background merge processes, reads, etc.

_peregrine_··on How to ingest 1B rows/s in ClickHouse
definitely interesting and related
_peregrine_··on How to ingest 1B rows/s in ClickHouse
nice one
_peregrine_··on Qwen3-Coder: Agentic coding in the world
Pretty solid at SQL generation, too. Just tested in our generation benchmark: https://llm-benchmark.tinybird.live/

Not quite as good as Claude but by the best Qwen model so far and 2x as fast as qwen3-235b-a22b-07-25

Specific results for qwen3-coder here: https://llm-benchmark.tinybird.live/models/qwen3-coder

_peregrine_··on Claude 4
Yeah we're always looking for new models to add
_peregrine_··on Claude 4
Yeah I mean SQL is pretty nuanced - one of the things we want to improve in the benchmark is how we measure "success", in the sense that multiple correct SQL results can look structurally dissimilar while semantically answering the prompt.

There's some interesting takeaways we learned here after the first round: https://www.tinybird.co/blog-posts/we-graded-19-llms-on-sql-...

_peregrine_··on Claude 4
We need to add it
_peregrine_··on Claude 4
Actually no, we have it up to 3 attempts. In fact, Opus 4 failed on 36/50 tests on the first attempt, but it was REALLY good at nailing the second attempt after receiving error feedback.
_peregrine_··on Claude 4
We should definitely add o3 - probably will soon. Also looking at testing the Qwen models
_peregrine_··on Claude 4
Noted, also feel free to add an issue to the GitHub repo: https://github.com/tinybirdco/llm-benchmark
_peregrine_··on Claude 4
No it's definitely interesting. It suggests that Opus 4 actually failed to write proper syntax on the first attempt, but given feedback it absolutely nailed the 2nd attempt. My takeaway is that this is great for peer-coding workflows - less "FIX IT CLAUDE"
_peregrine_··on Claude 4
yeah this was a surprising result. of course, bear in mind that testing an LLM on SQL generation is pretty nuanced, so take everything with a grain of salt :)
_peregrine_··on Claude 4
yeah that surprised me too
_peregrine_··on Claude Opus 4 is the best model at SQL generation
According to our SQL Generation Benchmark (methodology linked in the results dash), Claude Opus 4 is the best of the popular models at SQL generation by a pretty decent margin.
_peregrine_··on Claude 4
Already test Opus 4 and Sonnet 4 in our SQL Generation Benchmark (https://llm-benchmark.tinybird.live/)

Opus 4 beat all other models. It's good.

_peregrine_··on Tinybird Forward Hackathon
Chance to win >$3000 in credits from devtools like Vercel, Tinybird, Dub, Resend, etc.
_peregrine_··on How to analyze MCP server usage
Since MCP Servers are installed locally, it can be a bit painful to log and analyze usage of MCP Servers you built. My coworker built a utility to capture remote logging events from our MCP Server, could be extended to any MCP Server. Free to use, easy to set up. It uses Tinybird to capture events + generate Prometheus endpoints for Grafana, Datadog, etc.
_peregrine_··on Hey Claude, help me analyze Bluesky data
This is the full, unedited transcript of our conversation with Claude, whose context-awareness is provided by a v0 Tinybird MCP Server.
_peregrine_··on A new JSON data type for ClickHouse
I think Tinybird is a nice option here. It's sort of a managed service for ClickHouse with some other nice abstractions. For your streaming case, they have an HTTP endpoint that you can stream to that accepts up to 1k EPS and you can micro-batch events if you need to send more events than that. They also have some good connectors for BigQuery, Snowflake, DynamoDB, etc.
_peregrine_··on Show HN: Arroyo – Write SQL on streaming data
I am not sure of specifics on features, but I think the fundamental difference is that Arroyo is a stream processing engine i.e., it doesn’t have a database, whereas Tinybird has the statefulness afforded by ClickHouse as its primary data store. Arroyo would be more like Flink, Tinybird would be more like ClickHouse.

Disclaimer: I work for Tinybird.

_peregrine_··on Ask HN: What do you use to track visitors on your blog?
+1 for Tinybird
_peregrine_··on Show HN: Mockingbird: Generate mock data streams for your next data project
Ahh okay, this answered my question: https://www.tinybird.co/blog-posts/mockingbird-announcement-...

It's an open source library and you can build new destination plugins. That's cool!

_peregrine_··on Show HN: Mockingbird: Generate mock data streams for your next data project
This seems pretty cool. So you can only send data to Tinybird and Upstash? Any support for other destinations?
Page 1 of 2Next →