Postgres Manager @ Supabase, Complex systems science, Foresight practice, Research, Nix/Nixos, Elixir/BEAM, Julia, Clojure, Go, Postgresql, PostgREST, Scala

Lansing, MI
Joined February 2007
Sam Rose retweeted
So I was trying to understand why pull requests speeding up the Elixir version were being denied by the clankers while they were being accepted to Go/Express/Rust. It turns out that, not only each project had a different starting point and a different prompt, but also each project also has a different set of verifications that they are required to pass! For example, Elixir is the only guided to "preserve the pinned Rails reference behaviour", the only with a explicit verification that we are using Redis and draining its queue (so we cannot remove it while others can), and the only one actively enforcing it. So it turns out that the people telling you to not read the code cannot even use AI to set up fair benchmarks (probably because they would have to read the code in order to do that). You don't have to believe me, you can do your own research or ask your agent to do it for you. E.g. here is what Claude Code came back with: gist.github.com/josevalim/ae…
DHH
@dhhOct 8
Replying to @dhh
Also extracted a separate verification project that's responsible for the benchmarking and checking of new implementations and improvements to the existing ones. The full report from the latest runs is there too. github.com/basecamp/once-cam…
68
106
16
1,036
58,951
Replying to @ProgrammerDude
Yeah, it's worth a try, I think it could save quite a bit of IO on large files and folders. For remote builders, switching to gRPC with builtin compression helps also quite a bit github.com/Mic92/nix-grpc-st… . And then on the other side, nixpkgs's dependency tree could be shrunk.
1
1
7
288
Sam Rose retweeted
me after spending 40 hours a week talking to LLMs
64
508
39
6,152
279,803
Chock now has a comparison with Claude Code and Codex. chock.ws/comparison/
Feedback from our security team: you should put up a comparison in terms of security compared to the alleged sandbox capabilities of Claude-code and Codex
1
6
427
Sam Rose retweeted
If coding agents will write most of our code, what happens with our communities and sense of ergonomics? How does it impact our compilers and tools?
56
76
16
385
54,262
Sam Rose retweeted
Build your own MCP server on Supabase! youtube.com/live/UjwECdG91Ys
12
20
6
387
28,592
Added: - Nix flake for macOS and Linux: `nix run github:earendil-works/pi/stable` runs the latest release; `nix profile add github:earendil-works/pi/stable` installs it. Project MCP overrides: a `.pi/mcp.json` entry without command or url sets only enabled, exposure, and toolExposure of the user-level server. `oauth.clientRegistration: "cimd"` identifies pi by its Client ID Metadata Document URL instead of dynamic registration. - `pi.registerToolRenderer()` draws calls to any tool not yet registered, fixing MCP tool calls in resumed sessions and HTML exports that rendered fully expanded until their server connected. Cloudflare Clef (`@cf/cloudflare/clef`) and Clef Flash (`@cf/cloudflare/clef-flash`) are now usable from codemode scripts and extensions.
1
1
4
1,007
Sam Rose retweeted
we're forming an alliance 🤝 @tursodatabase supabase spark is coming
2
2
40
3,611
This is massive, gotta try it
Replying to @supabase
OrioleDB is now in public beta on Supabase! • No table bloat • No VACUUM • 64-bit transaction IDs • Better performance under high concurrency • Up to 1.8x higher throughput in Supabase benchmarks Available when creating a new project.
2
18
474
Sam Rose retweeted
I worked on these btw
Replying to @supabase
Observability and Monitoring improvements!! 🔭 • Raw log querying via MCP • New health advisor checks • Database connection visibility + controls • Notebooks for saved queries and investigations • Updated agent skills • Enterprise-managed MCP auth • Supabase Pipelines for analytics replication
9
2
1
78
2,961
Sam Rose retweeted
More stuff → Supa Compute • Run long-lived services and agents in any language • Full Linux environment with configurable CPU & memory • Public HTTP services or private background workers • Deploy via CLI/API and manage config in code • Built-in logs, metrics, scaling, and agent skills
5
7
4
62
7,240
Sam Rose retweeted
Turso is joining @supabase. Together, we're building the database platform for the agentic era: everything agents need, from lightweight databases to Postgres at petabyte scale. More details in thread. 👇
135
180
179
1,759
242,976
Sam Rose retweeted
what it feels like to be part of database twitter
2
4
52
1,933
a weekend project can legitimately change the world. what's next 👀
A painful part of working with your data has always been that your live data and historical data are stuck in separate systems: the order a customer just placed lives in your database, while their last five years of orders sit in a data lake in S3. And answering a real question usually needs both at once (is this a normal purchase for them, or should we flag it?), and to do that you had to move the data together first, copying history out of the data lake into your database (or the other way around), because the database couldn’t read it where it lived. That meant guessing ahead of time which data you’d want, keeping a second copy of it all, building pipelines to move it, and constantly syncing so the two didn’t drift apart. A lot of plumbing, and slow going, all before you could answer one question. And even then, the answers were only as fresh as your last sync. That now changes with Aurora PostgreSQL, which can call your live data and historical data in S3 together, in a single query. No copying, no pipelines to keep in sync. And it’s fast, because we’ve built in DuckDB, a popular open source engine that’s really good at reading and analyzing data right where it’s stored. DuckDB reads the open formats like Parquet and Iceberg already sitting in your data lake, so there’s nothing to convert or move. As folks build AI agents into their apps, the data their agent needs will depend on the task in front of it. Being able to query that specific data live, instead of copying it over just in case, is gonna be a big help for builders. aws.amazon.com/blogs/aws/ama…
2
2
2
14
1,099
Nothing feels as good as optimizing whole CI pipeline performance 🤌 Down to ~3min from sporadic 12-15min with flaky runs on top. Over 4-5x improvement over 2k runs every week adds up quickly, but most of all, the amount of frustration and context-switching decreases 😌
5
4
19
509
AI coding agents are only as good as their memory of how to use your tools – and in long sessions, that memory tends to fade. In our latest blog post, Victor Nascimento Bakke introduces tricorder-mcp, an MCP server for Tricorder, Tweag's Haskell dev tool. He explains why an MCP server holds up where a skill file struggles, and walks through a real feature built with Claude Code. Read more: tweag.io/blog/2026-09-24-tri… #Haskell #AI #MCP #DevTools
4
3
15
583