Sam Willis reposted
Sam Willis
Sam Willis
@samwillis.uk
Building sync and streams Databricks & Neon. Prev co-founder @electric.ax - acquired. Started http://PGlite.dev, co-creator of Tanstack DB @tanstack.com.
1K followers283 following146 posts
I've got my ticket! Who else is going to @syncconf.bsky.social?
Sam Willis reposted
Sam Willis reposted
We've just delivered a 100x write performance bump with our latest release of Electric. How? We threw away our storage engine and built a new one designed for sync π§΅ electric-sql.com/blog/2025/08...
Sam Willis reposted
Sam Willis reposted
Dev tools coming soon to @tanstack.com DB! The best client side state libs have brilliant dev tools, this is even more important for DB as you store so much state in it. The DB dev tools will give you full visibility of all collections and live queries. ππ
Sam Willis reposted
Very excited to have reached the Beta milestone with @tanstack.com DB ππ Itβs been a privilege to work with @tannerlinsley.com and the team on building this, absolute rock stars!
TanStack DB is now in BETA! Weβve been working on TanStack DB, an embedded, reactive client database for TanStack Query, and are proud to announce today that with the 0.1 release that it's now in BETA! tanstack.com/blog/tanstac...
Sam Willis reposted
Sam Willis reposted
Sam Willis reposted
Really looking forward to Sync London tomorrow! A bunch of exciting talks from teams building real apps on sync engines ππ₯³
Not long now! lu.ma/sync-london Talks are shaping up great and weβre well past venue capacity. @yonz.bsky.social is airborne. @samwillis.uk has sorted out the pineapple cubes and cocktail sausages. If youβre in London on Tuesday and have been lurking so far, nowβs your last chance!
Sam Willis reposted
Not long now! lu.ma/sync-london Talks are shaping up great and weβre well past venue capacity. @yonz.bsky.social is airborne. @samwillis.uk has sorted out the pineapple cubes and cocktail sausages. If youβre in London on Tuesday and have been lurking so far, nowβs your last chance!
This is an incredibly niche take, even for my corner over here. It goes further, the iterate method computing a fixed point is referenced as "Limbo" in Inception. IYKYN π
Christopher Nolan's Inception is actually an allegory for Differential Dataflow π€― - Multidimensional Versioning = Nested Dream Timelines: as you iterate / move down you make a new timeline - Frontiers = Kick Timing: a reference point across all dimensions
Sam Willis reposted
I'm speaking about syncing Postgres into the client with @electric-sql.com at the SF Bay Area Postgres users groups tomorrow (Tuesday 10th June). Online from noon local time, live stream here: www.meetup.com/postgresql-1...
Last month I spoke @pgconf.dev about @pglite.dev, how we built it and where we plan to take it π You can now watch my talk at the link below ππ
We've posted a video of Sam Willis's talk Compiling Postgres to WASM with PGlite (PGConf.dev 2025) https://youtu.be/hlW... #postgresql #PGConfdev
Sam Willis reposted
π§΅ More play less infra => vibe coding with the database inside the sandbox. Apps built with AI app builders like @bolt.new usually need to connect to a database to actually work. With @pglite.dev you can have the database inside the sandbox, so you can vibe code without even thinking about infra.
At @localfirstconf.com last week @thruflo.com introduced @tanstack.com DB and how it enables you to incrementally adopt Sync to make your apps faster and give you users a better experience.
Here's my @localfirstconf.com talk introducing @tanstack.com DB, hexdocs.pm/phoenix_sync, syncconf.dev and arguing that Sync is the key to mainstream adoption of #local-first. youtu.be/ia9FpY_Sw_4?...
Sam Willis reposted
When you're vibe-coding, you don't want to think about infra. You want to stay in the zone, iterating and expressing yourself. That means having a database inside your sandbox. No glue, no friction, no external services, no free-tier limits. Forkable, disposable, unlimited and zero cost.
π§΅ More play less infra => vibe coding with the database inside the sandbox. Apps built with AI app builders like @bolt.new usually need to connect to a database to actually work. With @pglite.dev you can have the database inside the sandbox, so you can vibe code without even thinking about infra.
PGlite can now be used with any Postgres client, and pairs perfectly with AI app builders for vibe coding. Love that with @bolt.new *everything* runs in the browser - node, the dev server, and now even PGlite ππ€― Awesome job by the team to get this out!
π§΅ More play less infra => vibe coding with the database inside the sandbox. Apps built with AI app builders like @bolt.new usually need to connect to a database to actually work. With @pglite.dev you can have the database inside the sandbox, so you can vibe code without even thinking about infra.
What to chat sync engines and how they can help you make better apps, particularly AI apps? We're hosting Sync London on July 1st, do sign up and come along. It will be a great evening! I'll be there ready to chat about @electric-sql.com, @pglite.dev and @tanstack.com DB.
Interested in building on sync? In London or SF? Come along to Sync London on July 1st lu.ma/sync-london -- we're co-organising with @anselm.io and @yonz.bsky.social, great speakers including @irltopper.bsky.social and @triggerdev.bsky.social
Sam Willis reposted
For any North American folks having FOMO about @localfirstconf.com, thereβs a new conference on sync engines as app architecture! SF in November syncconf.dev
Really looking forward to @localfirstconf.com tomorrow. The world of software has changed more than we could have imagined since the conf a year ago. I'm excited to hear how everyone is thinking about local first software in this new AI world. ππ€
GenAI enables me to try so many more of my ideas, even tools just for myself. It's also why local-first software is going to be massive - paired with AI code gen, anyone can build an app for themselves with no infra. Will be hot topic at @localfirstconf.com
Sam Willis reposted
Who's going to @localfirstconf.com next week? Super excited to be heading back to Berlin for it π©πͺ Loved the trip last year!
Who's going to @localfirstconf.com next week? Super excited to be heading back to Berlin for it π©πͺ Loved the trip last year!
Sam Willis reposted
No docker required. Postgres built into the Prisma dev environment using @pglite.dev
Working with your database locally, while you're building, needs to be simple. π Prisma 6.8.0 just landed: β Local Prisma Postgres (Early Access) β VS Code Agent mode support β Native Deno support ...& more π pris.ly/6.8-blog?ut...
Sam Willis reposted
A reactive client store built on differential dataflow. With optimistic mutators and sub-millisecond live queries. This is the missing piece of the jigsaw for modern app dev.
π¨ Big news! Weβve been collaborating with the legendary @tannerlinsley.com and the TanStack team to build something new: TanStack DB β a reactive, normalized, transactional state engine that extends TanStack Query.
Sam Willis reposted
This has been *super* fun to work on this the past few months w/ @samwillis.uk & @thruflo.com & @tannerlinsley.com It's really fun to think through from scratch a huge problem space (managing state!) and come up with a fairly novel solution.
π¨ Big news! Weβve been collaborating with the legendary @tannerlinsley.com and the TanStack team to build something new: TanStack DB β a reactive, normalized, transactional state engine that extends TanStack Query.
Announcing TanStack/DB ππ₯³ A lightweight, reactive, mini-database with IVM that is perfect for both Sync and Fetch. Itβs been a lot of fun to build this with @kyle.bricolage.io + @thruflo.com, and collaborate with @tannerlinsley.com. We are incredibly excited for where this can go!
π¨ Big news! Weβve been collaborating with the legendary @tannerlinsley.com and the TanStack team to build something new: TanStack DB β a reactive, normalized, transactional state engine that extends TanStack Query.
On my way to @pgconf.dev, and shipping code from 35k feet in the air πβοΈ Exciting things coming!
My colleague @balegas.bsky.social has created an awesome @electric-sql.com integration with the awesome Yjs CRDT toolkit. Sync your edits to a Ydoc via Electric π Perfect for integration with ProseMirror or TipTap for collaborative rich text editing!
Build collaborative applications with CRDTs straight outta Postgres using the new Yjs Electric provider. π§΅ www.npmjs.com/package/@ele...
One week till my talk @pgconf.dev! Very excited to be visiting Montreal π¨π¦ Give me a shout if you want to meet up a chat @pglite.dev, @electric-sql.com, Sync Engines or Local-first app development.
Sam Willis reposted
Just ran into a funny test bug w/ my english colleague @samwillis.uk β his test with getDate worked because he lives in GMT but broke for me. #britishTimePrivilege π
Sam Willis reposted
LLMs are generating code. That code is imperatively fetching data. That leads to a big ball of spaghetti. Here's how to untangle it: electric-sql.com/blog/2025/04...
Sam Willis reposted
Weβre excited to announce @thruflo.com co-founder of @electric-sql.com will be speaking at the local-first conf 2025.
Really awesome post by @chris.blue on incremental view maintenance. It's traditionally been thought of as something for analytics workflows, but combined with a sync engine it can bring efficient updates to your UI where standard queries were the norm!
Ok, y'all. This took me several weeks and a ton of help from @frankmcsherry.bsky.social and @lalithsuresh.bsky.social. I dug into timely dataflow, differential dataflow, and DBSP to get you up to speed on IVM engines and materialized views. Enjoy!