Sign in

Tyler Benfield

@rtbenfield.dev
192 followers 143 following 167 posts

I make databases fast and host fast databases. Platform Architect at Prisma

PostsRepliesMedia
Tyler Benfield @rtbenfield.dev · 29/09/2026
New model, new Pro 500 sub, and ultrafast mode
010
Tyler Benfield @rtbenfield.dev · 29/09/2026
dots
110
Tyler Benfield @rtbenfield.dev · 29/09/2026
This venue is legit. Love the couch areas to hang. We'll have a similar setup at Builder's Day by @prisma.io in a few weeks (builders.day)
110
Tyler Benfield @rtbenfield.dev · 29/09/2026
I'm at OpenAI DevDay! Hit me up if you're here too
110
Tyler Benfield @rtbenfield.dev · 08/09/2026
We've been building our own agents to help us operationally and they all run on open weight models, mostly GLM The newest is a code review agent that runs GLM-5.3 Flash. The Prisma team is already favoring it over the one we pay for and the core was built in a couple afternoons
111
Tyler Benfield @rtbenfield.dev · 04/09/2026
You already have tools for self improving software Set up a Claude or Codex routine to pull your errors, telemetry, or product metrics and generate a report that includes prompts or creates PRs directly to fix the biggest issues. Every day your product gets better
010
Tyler Benfield @rtbenfield.dev · 02/09/2026
Giving agents paths to access data over MCP or other tools is insanely cool I have Claude routines running daily to generate reports on our infra and look for opportunities for improvement. If something seems off I can ask it to dive deeper, look for historic patterns, or find correlating trends
131
Tyler Benfield @rtbenfield.dev · 12/08/2026
I'm putting so much love into Builder's Day. I hope you'll join us in SF on October 26 for a day celebrating how products are built now and into the future. Comment or DM me with any questions, thoughts, or ideas you'd like to see
020
Tyler Benfield @rtbenfield.dev · 10/08/2026
As models get better and we're encouraged to cut back our rules files, the most durable ones are describing intent and product direction Aligning with AI on this enables the agent to make meaningful suggestions and even push back
011
Tyler Benfield @rtbenfield.dev · 22/04/2026
let's go
Delta Airlines gate screen showing a destination of Miami
010
Tyler Benfield @rtbenfield.dev · 29/11/2025
I didn't realize the beta build was already available! Just installed it 🤩
Windows task manager snippet showing yaak-app.exe and yaaknode.exe with the Arm64 architecture.
110
Tyler Benfield @rtbenfield.dev · 12/10/2025
I'm back in Raleigh for another @allthingsopen.bsky.social and excited to give my lightning talk tomorrow ⚡ Come by to learn how to build faster apps by thinking like a database
All Things Open speaker card for Tyler Benfield, Staff Software Engineer at Prisma. The All Things Open astronaut is in the foreground next to the dates October 12-14 and the location Raleigh, NC USA.
142
Tyler Benfield @rtbenfield.dev · 04/10/2025
That was a great trip to SF filled with networking and possibly the best sandwich I've ever had. Now I'm home for a few days before heading to Toronto for Remix Jam 💿🇨🇦 and then to Raleigh for @allthingsopen.bsky.social!
Airplane view of bay area hills peaking out from a dense fog. The sunrise is peaking in from the left of the shot but not directly visible. The sky is clear and blue above the hills and fog
020
Tyler Benfield @rtbenfield.dev · 03/10/2025
Working with a view today
A laptop with create-db.prisma.io open in front of a view overlooking the San Francisco bay. The sky is partially cloudy and the water is still. Oakland is visible on the other side of the bay with ships in the port
000
Tyler Benfield @rtbenfield.dev · 12/09/2025
Let's go @ralexanderson.com! Teaching us how to build better apps by learning lessons from video games
020
Tyler Benfield @rtbenfield.dev · 12/09/2025
Landing in SLC for UtahJS tomorrow!
The great salt lake from the view of an airplane window as it is coming in to land. Mountains are visible in the background along with a cloudy sunset
120
Tyler Benfield @rtbenfield.dev · 11/06/2025
I'm thrilled to be speaking at @allthingsopen.bsky.social this year! If you've heard me talk about conferences, you've heard of ATO. I've met so many friends from attending ATO events. 2025 is going to be great and I'm excited to be part of it!
All Things Open 2025 speaker announcement. The heading says "I'm speaking at ATO 2025!" with a subtitle of "Join me & thousands of technologists for year lucky #13 of All Things Open!". Below the heading is an astronaut surrounded by symbols of luck. To the left is the All Things Open logo with the dates October 12-14, location Raleigh, NC USA, and a "Register Today" call to action.
063
Tyler Benfield @rtbenfield.dev · 03/06/2025
Garden update since it's been a while. Garlic was just harvested over the weekend. Blueberries are almost ready. Tomato plants are enjoying the cooler start this summer while the peppers are a bit behind. Okra, cucumbers, and beans are coming along too.
A home garden viewed from a corner angle. Raised garden beds growing tomato, pepper, and okra plants are in the foreground. A long, walk through trellis is in the background with beans and cucumbers beginning to climb the sides. Behind them are blueberry and blackberry bushes.
030
Tyler Benfield @rtbenfield.dev · 27/03/2025
#EpicWebConf was, in fact, epic. One of my favorite events and a 4 year reunion for me and my Remix conf gang. I can't express in one post how impactful these events have been on me... but I might pack it into a talk sometime soon. See you next time SLC👋🏻
View from the SLC airport lobby windows that stretch floor to ceiling. Chairs are lined in front of the windows. A series of Delta airplanes are visible with a mountain backdrop.
130
Tyler Benfield @rtbenfield.dev · 26/03/2025
@marktechson.com has been the hype man for speakers all day and just dropped the mic to wrap up #EpicWebConf
Mark Techson on stage at Epic Web Conf
161
Tyler Benfield @rtbenfield.dev · 26/03/2025
@devneill.com absolutely crushed it! Idea to production in less than 20 minutes. AI doing the work while Dev explained the lessons he learned along the way 🙌🏻
Devon Neil on stage at Epic Web Conf live vibe coding
030
Tyler Benfield @rtbenfield.dev · 26/03/2025
now we get to see the weird parts of the web with @ralexanderson.com
Alex Anderson on stage at Epic Web Conf with the title of his talk "The Weird Web" on the screen in the background
010
Tyler Benfield @rtbenfield.dev · 26/03/2025
@andrelandgraf.com is teaching us about image optimization. I've been friends with Andre for 4 years thanks to conferences!
Andre Landgraf on stage at Epic Web Conf
031
Tyler Benfield @rtbenfield.dev · 26/03/2025
this is 🔥
A slide from Aaron Francis's talk at Epic Web Conf with the words "it's not fair that..." struck out and replaced with "since it's true that..."
100
Tyler Benfield @rtbenfield.dev · 26/03/2025
@aaronfrancis.com is helping us plan for our future by betting on ourselves. Really glad to meet him this week at #EpicWebConf
Aaron Francis on stage at Epic Web Conf with the title of his talk "Epic Bets: Practical tips for betting on yourself" on the screen in the background
110
Tyler Benfield @rtbenfield.dev · 26/03/2025
this slide unlocked some bad memories
Browserify logo on the screen at Epic Web Conf
110
Tyler Benfield @rtbenfield.dev · 26/03/2025
@anniesexton.com is here to talk about the history of JavaScript
Annie Sexton on stage at Epic Web Conf. The screen in the background shows the title of her talk, "JavaScript: The Origin Story"
181
Tyler Benfield @rtbenfield.dev · 26/03/2025
@kentcdodds.com is on stage to talk about epic things!
Kent C. Dodds on stage at Epic Web Conf presenting "Of things Epic"
021
Tyler Benfield @rtbenfield.dev · 26/03/2025
#EpicWebConf let's go!!
Taylor Desseyn and Bree Hall on stage kicking off Epic Web Conf. Taylor is wearing a blue space themed jumpsuit and Bree is wearing a similar jumpsuit in white.
000
Tyler Benfield @rtbenfield.dev · 25/03/2025
Landed in SLC for #EpicWebConf 🏔️ Looking forward to seeing old friends, meeting new ones, and making some memories together
Selfie walking through the SLC airport. Not much of a crowd. Sun is still setting through the windows in the background.Snowcapped Utah mountains viewed through an airplane window. The sun is setting in the distance with an orange glow across the horizon.
050
Tyler Benfield @rtbenfield.dev · 04/03/2025
Rebellions are built on hope
Poe Dameron's black X-wing starfighter on display in Galaxy's Edge
030
Tyler Benfield @rtbenfield.dev · 03/02/2025
Drake meme giving the hand to "paying for 100,000 reads because you forgot an index" and a finger wave of approval to "paying a flat rate per query"
100
Tyler Benfield @rtbenfield.dev · 02/02/2025
streams 🤝 composition I added a function on the connection to send an arbitrary command and get the readable/writable back. Pipe that through a transform that understands the WAL encoding and 🚀 Even better, the WAL decoder *including the protocol* is tree-shakable if unused.
Example code snippet of experimental Postgres driver in TypeScript.

```
await using connection = await client.connect();
const { readable } = await connection.send(
  `START_REPLICATION SLOT "my_replication_slot" LOGICAL 0/0
    (proto_version '1', publication_names 'my_publication', binary)`,
);
const stream = readable.pipeThrough(
  new PgoutputDecoderStream(defaultBinaryTypeParser),
);
for await (const event of stream) {
  console.log(event);
  /**
    {
      type: 'insert',
      lsn: 51933232n,
      schema: 'public',
      relation: 'Table_ce7e1bcbcc8f40439fe454ac3a0e6d9c',
      timestamp: 2025-02-02T18:39:42.061Z,
      inserted: {
        id: '3d1a36de-d926-44e7-8d15-fc42394ea97b',
        text: '18016bab-68bd-4c20-972a-7d1b5a8a2ffa'
      }
    }
    */
}
```
031
Tyler Benfield @rtbenfield.dev · 19/01/2025
Why write a query like that instead of a JOIN? JOINs begin to explode the result set and confuse the query optimizer once you have more than one relationship branch. This approach makes a subquery that the optimizer will construct an independent subplan for.
A screenshot of the output from running EXPLAIN ANALYZE on the Postgres query from the previous post in the thread. The output is:

Index Scan using parent_pkey on parent p  (cost=0.42..28.15 rows=1 width=73)
  Index Cond: (id = 10)
  SubPlan 1
    ->  Index Scan using ix_child_parent_id on child  (cost=0.43..19.71 rows=4 width=32)
          Index Cond: (parent_id = p.id)
Planning Time: 0.140 ms
Execution Time: 0.152 ms
100
Tyler Benfield @rtbenfield.dev · 19/01/2025
It makes possible this highly optimized query using ARRAY and ROW to collapse a nested relationship. Text protocol serializes that value into a string, while binary gives you all the type details for decoding the individual values correctly. I can even tell the diff between Int16 and Int32.
A screenshot of the following Postgres query.

SELECT
  p.id,
  p.name,
  ARRAY(SELECT ROW(id, name)
    FROM child WHERE parent_id = p.id) AS children
FROM parent AS p
WHERE p.id = 10;
101
Tyler Benfield @rtbenfield.dev · 27/12/2024
It fits my 21oz Hydroflask easily. The 32oz is tight, but still doable. They are magnetic so they stay snug against the bag when unused. That also makes it a bit more difficult to use while it is on your back. A tall bottle may block the side carry handles also. That's a fair trade IMO.
Nomatic travel back holding a 21oz blue Hydroflask bottle in the side pocketNomatic travel back holding a 32oz purple Hydroflask bottle in the side pocket
100
Tyler Benfield @rtbenfield.dev · 13/12/2024
Wrightsville Beach, NC
View of a sunset peaking underneath a concrete pier and casting shadows onto the beach. Waves are crashing on the left behind the pier.
020
Tyler Benfield @rtbenfield.dev · 10/12/2024
Here's a few quick shots. Lots of interior organization. Laptop sleeve has a false bottom to protect from hard drops. Even includes a glasses case that fits in the interior side pockets. It expands from 20l to 30l, revealing a suitecase zipper and shoe pocket.
Nomatic travel pack open to laptop compartmentNomatic travel backpack open to main compartment with included protective glasses caseNomatic travel backpack open to front compartment showing mesh pockets and RFID safe pocketNomatic travel backpack expanded and open in suitcase style
100
Tyler Benfield @rtbenfield.dev · 10/12/2024
My new travel backpack arrived today and my first impressions are super positive. I was looking for very specific things and Nomatic nailed it. @henrihelvetica.bsky.social as a connoisseur of good packs I'm curious if you've checked out this one?
A Nomatic travel backpack closed and resting on the floor against a wall
410
Tyler Benfield @rtbenfield.dev · 03/12/2024
NC had a light snowfall early this year 🌨️ I, an amateur, forgot to panic buy milks, eggs, and bread.
View of the front lawn and neighborhood covered in a light snowfall with a sunrise peaking through the trees.
170
Tyler Benfield @rtbenfield.dev · 06/11/2024
I have no complaints about the views 🖼️
View from the train overlooking James River in Richmond, VA
010