Sam Rose (@SamRose) header
Sam Rose (@SamRose) profile picture

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

Lansing, MI
Joined February 2007
Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)Photo by Sam Rose (@SamRose)
OrioleDB is now available as public beta for everyone!
OrioleDB is now in public beta, on every Supabase plan. It changes how Postgres stores your table rows, so in most cases they don’t bloat as your data changes. Learn more → supabase.com/blog/orioledb-p…
2
41
4,538
We're rdfmaxxing. semblance.dev/
2
2
4
470
Sam Rose retweeted
I will talk about Lynx, my Erlang/Elixir to Lean compiler for writing laws and proofs about your Erlang/Elixir programs today at @CodeBEAMio’s lightning talks!
8
21
242
8,692
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…
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,034
59,447
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
294
Sam Rose retweeted
me after spending 40 hours a week talking to LLMs
62
508
39
6,121
280,616
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
442
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?
55
76
16
385
54,553
Sam Rose retweeted
Build your own MCP server on Supabase! youtube.com/live/UjwECdG91Ys
12
20
6
385
28,730
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,022
Sam Rose retweeted
we're forming an alliance 🤝 @tursodatabase supabase spark is coming
2
2
41
3,747
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
17
484
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,964
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
64
9,244
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
180
1,755
245,076
Sam Rose retweeted
what it feels like to be part of database twitter
2
4
52
1,944