Sam Willis's Avatar

Sam Willis

@samwillis.uk

Local First, TanStack DB, @pglite.dev and Sync Engines at @electric-sql.com. More at https://samwillis.uk

1,039
Followers
283
Following
146
Posts
23.10.2024
Joined
Posts Following

Latest posts by Sam Willis @samwillis.uk

My favorite type of conference β€” 1 day, single track with a ton of great folks to chat with

19.08.2025 15:24 πŸ‘ 7 πŸ” 1 πŸ’¬ 1 πŸ“Œ 0

I've got my ticket!
Who else is going to @syncconf.bsky.social?

19.08.2025 17:39 πŸ‘ 2 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

Really looking forward to Sync Conf!
We are at an epoch moment with AI, everything is changing, and the abstractions we build on are chaining to enable it.
Sync is that abstraction, and this conference is going to be one that is remembered as instrumental.

19.08.2025 16:18 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

Announcing Sync Conf 2025. Join us in SF on Nov 12th.

19.08.2025 15:06 πŸ‘ 30 πŸ” 10 πŸ’¬ 2 πŸ“Œ 13

We've talked about it, but it would likely be tied to a spesific over-the-write protocol for the change messages.
Instead we were thinking it would be the ideal one for a "custom sync collection guide", showing how the internal sync abstraction works.
Becomes copy-past for each implementation too.

16.08.2025 06:44 πŸ‘ 0 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0
Preview
Electric 1.1: new storage engine with 100x faster writes | ElectricSQL How we built a new storage engine for Electric, why we did it now, and how it delivers lower latency, higher throughput, and zero‑downtime deploys.

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...

14.08.2025 15:53 πŸ‘ 13 πŸ” 4 πŸ’¬ 1 πŸ“Œ 1
Video thumbnail

Agentic AI, beneath all the hype, is actually just normal software. You can build agentic systems with a database, standard web tooling and real-time sync.

14.08.2025 15:40 πŸ‘ 13 πŸ” 7 πŸ’¬ 2 πŸ“Œ 2

You can just write to a database

14.08.2025 16:32 πŸ‘ 6 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

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. πŸš€πŸŽ‰

15.08.2025 13:03 πŸ‘ 8 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

ElectricSQL recently completed a 120-day reliability sprint. Our one goal: make our sync engine so boring-reliable you stop thinking about it and just build.

We chased every incident, fixed every user-reported bug, and made unglamorous work our priority. 🧡

04.08.2025 16:56 πŸ‘ 33 πŸ” 6 πŸ’¬ 2 πŸ“Œ 1

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!

29.07.2025 18:05 πŸ‘ 10 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

πŸŽ‰ TanStack DB now has @solidjs.com support!

25.07.2025 21:53 πŸ‘ 55 πŸ” 9 πŸ’¬ 3 πŸ“Œ 2

πŸ’―

24.07.2025 18:22 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

I will not pretend there were no complaints!

24.07.2025 12:04 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
<script lang="ts">
import { useLiveQuery } from "@tanstack/svelte-db"
import { eq } from "@tanstack/db"
import { todoCollection } from "$lib/collections"

const todosQuery = useLiveQuery((query) =>
  query
    .from({ todos: todoCollection })
    .where(({ todos }) => eq(todos.completed, false))
)
</script>


<List items={todosQuery.data} />

<script lang="ts"> import { useLiveQuery } from "@tanstack/svelte-db" import { eq } from "@tanstack/db" import { todoCollection } from "$lib/collections" const todosQuery = useLiveQuery((query) => query .from({ todos: todoCollection }) .where(({ todos }) => eq(todos.completed, false)) ) </script> <List items={todosQuery.data} />

TanStack DB now has @svelte.dev support!

23.07.2025 19:27 πŸ‘ 63 πŸ” 10 πŸ’¬ 1 πŸ“Œ 1

French alps πŸ”οΈ
bsky.app/profile/samw...

24.07.2025 06:53 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

French alps πŸ”οΈ
bsky.app/profile/samw...

24.07.2025 06:53 πŸ‘ 1 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

French alps πŸ”οΈ
bsky.app/profile/samw...

24.07.2025 06:52 πŸ‘ 0 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

This is the French Alps - starting point Les Carroz, a beautiful chocolate box village at about 1200m. Only about a hour from Geneva.
I love the alps even move in the summer than in the winter. You'll visit once, and just keep coming back.

24.07.2025 06:51 πŸ‘ 7 πŸ” 0 πŸ’¬ 0 πŸ“Œ 3
Video thumbnail

Perfect lunch stop with the family after a 3hr hike! 😊

23.07.2025 15:31 πŸ‘ 405 πŸ” 13 πŸ’¬ 19 πŸ“Œ 0
Post image

PGlite (WASM Postgres) now gets over 1 million downloads a week! πŸ€―πŸš€
Absolutely incredible to see how people have embraced what we have built.
Awesome work by the team!

14.07.2025 15:28 πŸ‘ 63 πŸ” 11 πŸ’¬ 1 πŸ“Œ 2
Post image

PGlite (WASM Postgres) now gets over 1 million downloads a week! πŸ€―πŸš€
Absolutely incredible to see how people have embraced what we have built.
Awesome work by the team!

14.07.2025 15:28 πŸ‘ 63 πŸ” 11 πŸ’¬ 1 πŸ“Œ 2

Les Carroz in the French Alps. Love it even more in the summer than in the winter.
So many great day trips, walks and activities for the kids.

04.07.2025 20:26 πŸ‘ 3 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0
Video thumbnail

Home for the next few weeks 😁
Love the πŸ”οΈ in the summer!

04.07.2025 19:09 πŸ‘ 4 πŸ” 0 πŸ’¬ 1 πŸ“Œ 0

Really looking forward to Sync London tomorrow!
A bunch of exciting talks from teams building real apps on sync engines πŸš€πŸ₯³

30.06.2025 09:44 πŸ‘ 1 πŸ” 1 πŸ’¬ 0 πŸ“Œ 0
Preview
Sync London Β· Luma Interesting in building products on a local-first / sync engine architecture? Come along to the first Sync London, a meetup to learn and talk about better ways…

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!

29.06.2025 18:30 πŸ‘ 2 πŸ” 3 πŸ’¬ 0 πŸ“Œ 1

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 πŸ˜‚

13.06.2025 20:06 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0

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

13.06.2025 13:42 πŸ‘ 4 πŸ” 0 πŸ’¬ 0 πŸ“Œ 1
Preview
"Syncing Postgres into the Client" with James Arthur, Tue, Jun 10, 2025, 12:00 PM | Meetup Join us virtually on Tuesday, June 10th for "Syncing Postgres into the Client" with James Arthur. Postgres has binary and logical replication for syncing data between repl

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...

09.06.2025 14:54 πŸ‘ 6 πŸ” 2 πŸ’¬ 0 πŸ“Œ 0

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 πŸš€πŸ˜

09.06.2025 14:42 πŸ‘ 6 πŸ” 0 πŸ’¬ 0 πŸ“Œ 0