Paul Harter
@paulharter.com
Immersive spatial audio for web - https://panaudia.com/ - https://electric-sql.com
Pinned
Paul Harter
@paulharter.com
· Jan 27
Panaudia
Spatial audio for big shared spaces.
panaudia.com
I have spent the past year creating a new ambisonic mixing server called Panaudia.
You can read more about how it works and try the live demo servers here: panaudia.com
It's in beta at the moment, if you would like to try it out or have any questions please get in touch.
You can read more about how it works and try the live demo servers here: panaudia.com
It's in beta at the moment, if you would like to try it out or have any questions please get in touch.
Reposted by Paul Harter
You didn’t think we weren’t going to drop something big today for @syncconf.bsky.social did you?
Query-driven sync. In @tanstack.com DB. No re-write needed. Let’s do this 🔥
Query-driven sync. In @tanstack.com DB. No re-write needed. Let’s do this 🔥
🚀 TanStack DB 0.5 is here with Query-Driven Sync
Your component's query IS the API call. No custom endpoints. No GraphQL resolvers. Just write your query and DB figures out exactly what to fetch.
Details 🧵👇
Your component's query IS the API call. No custom endpoints. No GraphQL resolvers. Just write your query and DB figures out exactly what to fetch.
Details 🧵👇
November 12, 2025 at 10:13 PM
You didn’t think we weren’t going to drop something big today for @syncconf.bsky.social did you?
Query-driven sync. In @tanstack.com DB. No re-write needed. Let’s do this 🔥
Query-driven sync. In @tanstack.com DB. No re-write needed. Let’s do this 🔥
Just vibe coding the DNS config for Dynamo…
October 20, 2025 at 10:59 AM
Just vibe coding the DNS config for Dynamo…
Reposted by Paul Harter
On the morning of Keir Starmer's conference speech here's a new post on an odd psychopathology in British politics - our main parties don't like the people who vote for them - the dreaded Professional Managerial Class. And so they are acting out like a divorced dad seeking cooler voters. 1/n
British Politics' Midlife Crisis
Why British Parties Can't Make Peace with Their Actual Voters
benansell.substack.com
September 30, 2025 at 6:40 AM
On the morning of Keir Starmer's conference speech here's a new post on an odd psychopathology in British politics - our main parties don't like the people who vote for them - the dreaded Professional Managerial Class. And so they are acting out like a divorced dad seeking cooler voters. 1/n
Reposted by Paul Harter
❗ Newham Independents GAIN from Labour
Yesterday's Plaistow South (Newham) council by-election result:
NIN: 44.7% (+44.7)
LAB: 21.4% (-34.0)
REF: 16.1% (+16.1)
GRN: 7.4% (-8.4)
CON: 6.0% (-11.5)
LDEM: 4.4% (-6.9)
+/- 2022
Estimated turnout: ~25% (-5)
andrewteale.me.uk/previews
Yesterday's Plaistow South (Newham) council by-election result:
NIN: 44.7% (+44.7)
LAB: 21.4% (-34.0)
REF: 16.1% (+16.1)
GRN: 7.4% (-8.4)
CON: 6.0% (-11.5)
LDEM: 4.4% (-6.9)
+/- 2022
Estimated turnout: ~25% (-5)
andrewteale.me.uk/previews
Andrew’s Previews | Andrew Teale | Substack
"All the right votes, but not necessarily in the right order". Click to read Andrew’s Previews, by Andrew Teale, a Substack publication with thousands of subscribers.
andrewteale.me.uk
September 19, 2025 at 1:48 PM
❗ Newham Independents GAIN from Labour
Yesterday's Plaistow South (Newham) council by-election result:
NIN: 44.7% (+44.7)
LAB: 21.4% (-34.0)
REF: 16.1% (+16.1)
GRN: 7.4% (-8.4)
CON: 6.0% (-11.5)
LDEM: 4.4% (-6.9)
+/- 2022
Estimated turnout: ~25% (-5)
andrewteale.me.uk/previews
Yesterday's Plaistow South (Newham) council by-election result:
NIN: 44.7% (+44.7)
LAB: 21.4% (-34.0)
REF: 16.1% (+16.1)
GRN: 7.4% (-8.4)
CON: 6.0% (-11.5)
LDEM: 4.4% (-6.9)
+/- 2022
Estimated turnout: ~25% (-5)
andrewteale.me.uk/previews
Reposted by Paul Harter
Announcing Sync Conf 2025. Join us in SF on Nov 12th.
August 19, 2025 at 3:06 PM
Announcing Sync Conf 2025. Join us in SF on Nov 12th.
Reposted by Paul Harter
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.
August 14, 2025 at 3:40 PM
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.
Reposted by Paul Harter
Adam Rutkowski, Jake Harter, Jason Parisi: Scalable Chrysopoeia via $(n, 2n)$ Reactions Driven by Deuterium-Tritium Fusion Neutrons https://arxiv.org/abs/2507.13461 https://arxiv.org/pdf/2507.13461 https://arxiv.org/html/2507.13461
July 21, 2025 at 6:49 AM
Adam Rutkowski, Jake Harter, Jason Parisi: Scalable Chrysopoeia via $(n, 2n)$ Reactions Driven by Deuterium-Tritium Fusion Neutrons https://arxiv.org/abs/2507.13461 https://arxiv.org/pdf/2507.13461 https://arxiv.org/html/2507.13461
Reposted by Paul Harter
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!
Absolutely incredible to see how people have embraced what we have built.
Awesome work by the team!
July 14, 2025 at 3:28 PM
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!
Absolutely incredible to see how people have embraced what we have built.
Awesome work by the team!
Reposted by Paul Harter
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?...
youtu.be/ia9FpY_Sw_4?...
James Arthur - Introducing TanStack DB
YouTube video by Local-First Conf
youtu.be
June 5, 2025 at 5:05 PM
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?...
youtu.be/ia9FpY_Sw_4?...
Off to Berlin for @localfirstconf.com next week - super excited for unconf day on Monday as so many cool people there
May 23, 2025 at 10:56 AM
Off to Berlin for @localfirstconf.com next week - super excited for unconf day on Monday as so many cool people there
Rogue One stole that opening shot and music from the clangers
May 19, 2025 at 9:30 PM
Rogue One stole that opening shot and music from the clangers
Reposted by Paul Harter
🚨 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.
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.
May 13, 2025 at 4:21 PM
🚨 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.
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.
Reposted by Paul Harter
AI apps are inherently collaborative between users and agents. You can't just have the agent state in the cloud. You need to keep the users in the loop.
That means you need to build them on sync.
electric-sql.com/blog/2025/04...
That means you need to build them on sync.
electric-sql.com/blog/2025/04...
Building AI apps? You need sync | ElectricSQL
AI apps are collaborative. Building them requires solving resumeability, interruptability, multi‑tab, multi‑device and multi‑user.
electric-sql.com
April 9, 2025 at 5:39 PM
AI apps are inherently collaborative between users and agents. You can't just have the agent state in the cloud. You need to keep the users in the loop.
That means you need to build them on sync.
electric-sql.com/blog/2025/04...
That means you need to build them on sync.
electric-sql.com/blog/2025/04...
Reposted by Paul Harter
hello real-time hugely scalable sync straight outta postgres
📣 Electric Cloud is in public BETA!
It takes just 30 seconds to add your Postgres db and start syncing to millions.
Head over to dashboard.electric-sql.cloud to start syncing.
It takes just 30 seconds to add your Postgres db and start syncing to millions.
Head over to dashboard.electric-sql.cloud to start syncing.
ElectricSQL Cloud Dashboard
dashboard.electric-sql.cloud
April 7, 2025 at 6:25 PM
hello real-time hugely scalable sync straight outta postgres
Reposted by Paul Harter
📣 Electric Cloud is in public BETA!
It takes just 30 seconds to add your Postgres db and start syncing to millions.
Head over to dashboard.electric-sql.cloud to start syncing.
It takes just 30 seconds to add your Postgres db and start syncing to millions.
Head over to dashboard.electric-sql.cloud to start syncing.
ElectricSQL Cloud Dashboard
dashboard.electric-sql.cloud
April 7, 2025 at 6:15 PM
📣 Electric Cloud is in public BETA!
It takes just 30 seconds to add your Postgres db and start syncing to millions.
Head over to dashboard.electric-sql.cloud to start syncing.
It takes just 30 seconds to add your Postgres db and start syncing to millions.
Head over to dashboard.electric-sql.cloud to start syncing.
Reposted by Paul Harter
New single alert! 'Switch' is out on 2nd April, can't wait to share it. Worked with some amazing people on the track and video shoot. Here's the link for release day song.link/KatFiveSwitch
Mixed by ace Rookes, mastered by @izzymcphee.bsky.social at Weird Jungle. DOP Finn Green, MUA Amber Sherlock.
Mixed by ace Rookes, mastered by @izzymcphee.bsky.social at Weird Jungle. DOP Finn Green, MUA Amber Sherlock.
March 26, 2025 at 6:45 PM
New single alert! 'Switch' is out on 2nd April, can't wait to share it. Worked with some amazing people on the track and video shoot. Here's the link for release day song.link/KatFiveSwitch
Mixed by ace Rookes, mastered by @izzymcphee.bsky.social at Weird Jungle. DOP Finn Green, MUA Amber Sherlock.
Mixed by ace Rookes, mastered by @izzymcphee.bsky.social at Weird Jungle. DOP Finn Green, MUA Amber Sherlock.
Proud and excited! Tomorrow, for those of you into Open Source neutronic modelling, Jake will be presenting his poster at a conference at MIT ossfe.github.io/OSSFE_2025/j...
A Complete Open Source Workflow for CAD Based Reactor Neutronics with Unstructured Mesh Tallying - OSSFE conference 2025 - March 18th
ossfe.github.io
March 17, 2025 at 11:51 PM
Proud and excited! Tomorrow, for those of you into Open Source neutronic modelling, Jake will be presenting his poster at a conference at MIT ossfe.github.io/OSSFE_2025/j...
Reposted by Paul Harter
Electric is now in GA! 🚀
Check out the 1.0 release post here: electric-sql.com/blog/2025/03...
The APIs are stable and we're is ready for mission critical, production apps. Super excited to see what you build with Electric now it's hit 1.0!
Check out the 1.0 release post here: electric-sql.com/blog/2025/03...
The APIs are stable and we're is ready for mission critical, production apps. Super excited to see what you build with Electric now it's hit 1.0!
Electric 1.0 released | ElectricSQL
With version 1.0 Electric is now in GA. The APIs are stable and the sync engine is ready for mission critical, production apps.
electric-sql.com
March 17, 2025 at 8:14 PM
Electric is now in GA! 🚀
Check out the 1.0 release post here: electric-sql.com/blog/2025/03...
The APIs are stable and we're is ready for mission critical, production apps. Super excited to see what you build with Electric now it's hit 1.0!
Check out the 1.0 release post here: electric-sql.com/blog/2025/03...
The APIs are stable and we're is ready for mission critical, production apps. Super excited to see what you build with Electric now it's hit 1.0!
I've added SwiftData persistence to my Swift client library for @electric-sql.com . You can choose between ephemeral shapes that are just in memory view models for live queries, or persistent ones that keep state in SwiftData for offline and resuming. github.com/paulharter/E...
GitHub - paulharter/ElectricSync: Swift client for ElectricSQL
Swift client for ElectricSQL. Contribute to paulharter/ElectricSync development by creating an account on GitHub.
github.com
March 11, 2025 at 12:50 PM
I've added SwiftData persistence to my Swift client library for @electric-sql.com . You can choose between ephemeral shapes that are just in memory view models for live queries, or persistent ones that keep state in SwiftData for offline and resuming. github.com/paulharter/E...
Reposted by Paul Harter
Released a new Phoenix library for real-time sync hexdocs.pm/phoenix_sync at @codebeam.bsky.social yesterday.
Check it out if you’re interested in building modern, real-time apps on local-first / sync in Elixir.
#myelixirstatus
Check it out if you’re interested in building modern, real-time apps on local-first / sync in Elixir.
#myelixirstatus
March 7, 2025 at 10:39 PM
Released a new Phoenix library for real-time sync hexdocs.pm/phoenix_sync at @codebeam.bsky.social yesterday.
Check it out if you’re interested in building modern, real-time apps on local-first / sync in Elixir.
#myelixirstatus
Check it out if you’re interested in building modern, real-time apps on local-first / sync in Elixir.
#myelixirstatus
Reposted by Paul Harter
Incremental view maintenance is seen as a black art. The tools available, such as differential dataflow, are complex, with a steep learning curve.
I want to change that with D2TS!
It has a simple pipeline api, with full type inference at every step 🚀
I want to change that with D2TS!
It has a simple pipeline api, with full type inference at every step 🚀
![const graph = new D2({ initialFrontier: 0 });
const issuesInput = graph.newInput<[string, Issue]>();
const usersInput = graph.newInput<[string, User]>();
const commentsInput = graph.newInput<[string, Comment]>();
const commentCounts = commentsInput.pipe(
map(([_key, comment]) => [comment.issue_id, 1]),
concat(issuesInput.pipe(map(([_key, issue]) => [issue.id, 0]))),
reduce((values) => {
let count = 0;
for (const [num, diff] of values) {
count += num * diff;
}
return [[count, 1]];
})
);
issuesInput.pipe(
map(([_key, issue]) => [issue.user_id, issue]),
join(usersInput.pipe(map(([_key, user]) => [user.id, user]))),
join(commentCounts),
map(([_key, [[issue, user], commentCount]]) => [
issue.id,
{
...issue,
user_id: user.id,
username: user.username,
user_email: user.email,
user_full_name: user.full_name,
comment_count: commentCount || 0,
},
]),
consolidate(),
output((msgs) => {
console.log(msgs);
})
);](https://cdn.bsky.app/img/feed_thumbnail/plain/did:plc:7zsebsiw55hprbjz6prpsbem/bafkreidmctemtym2lbzvsrx47fkyaaz7gqlwwaduxobwdphffri6dbz7a4@jpeg)
March 3, 2025 at 9:28 AM
Incremental view maintenance is seen as a black art. The tools available, such as differential dataflow, are complex, with a steep learning curve.
I want to change that with D2TS!
It has a simple pipeline api, with full type inference at every step 🚀
I want to change that with D2TS!
It has a simple pipeline api, with full type inference at every step 🚀
Reposted by Paul Harter
Go to european-alternatives.eu to find European Alternatives for all your critical online services including server hosting.
Nothing hosted by the US is now reliable.
If it is critical, move it or mirror it.
If it is critical, move it or mirror it.
Pubmed.gov is down. There are many outrages. This one is senseless, foolish, and a sign of a new dark age. A biostats friend wrote "This is akin to burning the libraries at Alexandria and Ninevah."
March 2, 2025 at 9:50 AM
Go to european-alternatives.eu to find European Alternatives for all your critical online services including server hosting.
Reposted by Paul Harter
Introducing D2TS - a TypeScript implementation of Differential Dataflow I've been building 🚀
Enabling incremental computation on change streams and streaming joins, both on the server and client.
Perfect for use with the @electric-sql.com sync engine! 🧵
Enabling incremental computation on change streams and streaming joins, both on the server and client.
Perfect for use with the @electric-sql.com sync engine! 🧵
February 28, 2025 at 12:59 PM
Introducing D2TS - a TypeScript implementation of Differential Dataflow I've been building 🚀
Enabling incremental computation on change streams and streaming joins, both on the server and client.
Perfect for use with the @electric-sql.com sync engine! 🧵
Enabling incremental computation on change streams and streaming joins, both on the server and client.
Perfect for use with the @electric-sql.com sync engine! 🧵
Stockhausen Syndrome is the creeping love you build for a programming language through mastery of its shitty anti-patterns
February 27, 2025 at 11:08 AM
Stockhausen Syndrome is the creeping love you build for a programming language through mastery of its shitty anti-patterns