LightNews LightNews
nunopreguica.bsky.social
@nunopreguica.bsky.social
36 followers 60 following 0 posts
Posts Replies Media Videos
Reposted
thruflo.com
Building apps on Postgres? Here how to do it using sync: youtu.be/mDzzK5-XkZ8?...
"Syncing Postgres into the Client" with James Arthur
YouTube video by San Francisco Bay Area PostgreSQL Users Group
youtu.be
July 3, 2025 at 9:51 AM
Reposted
thruflo.com
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?...
James Arthur - Introducing TanStack DB
YouTube video by Local-First Conf
youtu.be
June 5, 2025 at 5:05 PM
Reposted
electric-sql.com
🧵 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.
June 5, 2025 at 11:51 AM
Reposted
thruflo.com
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
March 7, 2025 at 10:39 PM
Reposted
samwillis.uk
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 🚀
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); }) );
March 3, 2025 at 9:28 AM
Reposted
electric-sql.com
ElectricSQL is now in BETA!

We're a Postgres sync engine. Check out our new 1 million clients benchmark and demos: electric-sql.com/blog/2024/12...

Electric is ready to sync with companies like Trigger.dev, Ottogrid.ai and Doorboost.com using us in production. Great time to take another look!
Electric BETA release | ElectricSQL
The Electric sync engine is now in BETA. If you haven't checked out Electric recently, it's a great time to take another look.
electric-sql.com
December 10, 2024 at 8:31 PM