frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

CRDT and SQLite: Local-First Value Synchronization

https://marcobambini.substack.com/p/the-secret-life-of-a-local-first
33•marcobambini•4d ago

Comments

briandw•1h ago
For a primer on CRDTs, Martin Kleppmann has a number of good videos: https://www.youtube.com/watch?v=x7drE24geUw
withinboredom•1h ago
This works assuming everyone has the same clock or performs changes causually distant from each other. It fails to work if, say, 1000 people all make a change around the same time. This also applies to lamport timestamps.
marcobambini•56m ago
The algorithm has a way to resolve conflicts even if, by any chance, the Lamport clock has the same value in all peers
withinboredom•53m ago
Yeah, but the fact that they didn’t even mention it in their post is why I brought it up.
philsnow•15m ago
We shouldn't be surprised because the writer works with both sqlite and AI but

> Here’s a polished section you can insert into your article (it fits naturally after the Sync Phase section):

NanoChat – The best ChatGPT that $100 can buy

https://github.com/karpathy/nanochat
503•huseyinkeles•5h ago•78 comments

First device based on 'optical thermodynamics' can route light without switches

https://phys.org/news/2025-10-device-based-optical-thermodynamics-route.html
44•rbanffy•4d ago•4 comments

Dutch government takes control of Chinese-owned chipmaker Nexperia

https://www.cnbc.com/2025/10/13/dutch-government-takes-control-of-chinese-owned-chipmaker-nexperi...
105•piskov•10h ago•43 comments

Abstraction, not syntax

https://ruudvanasseldonk.com/2025/abstraction-not-syntax
14•unripe_syntax•11h ago•0 comments

Show HN: SQLite Online – 11 years of solo development, 11K daily users

https://sqliteonline.com/
267•sqliteonline•7h ago•104 comments

Root cause analysis? You're doing it wrong

https://entropicthoughts.com/root-cause-analysis-youre-doing-it-wrong
32•davedx•2d ago•12 comments

DJI's Promo Shows Drone Footage from Prohibited National Parks and Tribal Lands

https://dronexl.co/2025/10/12/dji-mavic-4-pro-drone-footage-prohibited-national-parks/
9•josephcsible•31m ago•1 comments

JSON River – Parse JSON incrementally as it streams in

https://github.com/rictic/jsonriver
97•rickcarlino•5d ago•52 comments

Scaling request logging with ClickHouse, Kafka, and Vector

https://www.geocod.io/code-and-coordinates/2025-10-02-from-millions-to-billions/
63•mjwhansen•5d ago•8 comments

CRDT and SQLite: Local-First Value Synchronization

https://marcobambini.substack.com/p/the-secret-life-of-a-local-first
34•marcobambini•4d ago•5 comments

Android's sideloading limits are its most anti-consumer move

https://www.makeuseof.com/androids-sideloading-limits-are-anti-consumer-move-yet/
380•josephcsible•5h ago•217 comments

Software update bricks some Jeep 4xe hybrids over the weekend

https://arstechnica.com/cars/2025/10/software-update-bricks-some-jeep-4xe-hybrids-over-the-weekend/
217•gloxkiqcza•5h ago•156 comments

Optery (YC W22) – Hiring Tech Lead with Node.js Experience (U.S. & Latin America)

https://www.optery.com/careers/
1•beyondd•3h ago

Spotlight on pdfly, the Swiss Army knife for PDF files

https://chezsoi.org/lucas/blog/spotlight-on-pdfly.html
277•Lucas-C•11h ago•83 comments

Why did containers happen?

https://buttondown.com/justincormack/archive/ignore-previous-directions-8-devopsdays/
9•todsacerdoti•8h ago•7 comments

JIT: So you want to be faster than an interpreter on modern CPUs

https://www.pinaraf.info/2025/10/jit-so-you-want-to-be-faster-than-an-interpreter-on-modern-cpus/
7•pinaraf•1d ago•0 comments

More random home lab things I've recently learned

https://chollinger.com/blog/2025/10/more-homelab-things-ive-recently-learned/
162•otter-in-a-suit•1w ago•80 comments

Environment variables are a legacy mess: Let's dive deep into them

https://allvpv.org/haotic-journey-through-envvars/
169•signa11•3h ago•123 comments

American solar farms

https://tech.marksblogg.com/american-solar-farms.html
165•marklit•10h ago•199 comments

Reverse Engineering a 1979 Camera's Spec

https://blog.mano.lol/posts/film/
7•manoloesparta•1h ago•0 comments

Matrices can be your friends (2002)

https://www.sjbaker.org/steve/omniv/matrices_can_be_your_friends.html
105•todsacerdoti•10h ago•79 comments

KTX – npx for Kotlin and JVM to install jars or Kotlin scripts

https://github.com/mpetuska/ktx
3•TheWiggles•5d ago•0 comments

The Sveriges Riksbank Prize in Economic Sciences in Memory of Alfred Nobel 2025

https://www.nobelprize.org/prizes/economic-sciences/2025/summary/
103•k2enemy•9h ago•143 comments

Strudel REPL – a music live coding environment living in the browser

https://strudel.cc
6•birdculture•1h ago•1 comments

Roger Dean – His legendary artwork in gaming history (Psygnosis)

https://spillhistorie.no/2025/10/03/legends-of-the-games-industry-roger-dean/
39•thelok•5h ago•8 comments

Programming in Assembly Is Brutal, Beautiful, and Maybe Even a Path to Better AI

https://www.wired.com/story/programming-assembly-artificial-intelligence/
32•fcpguru•1h ago•5 comments

MPTCP for Linux

https://www.mptcp.dev/
93•SweetSoftPillow•11h ago•16 comments

Smartphones and being present

https://herman.bearblog.dev/being-present/
154•articsputnik•6h ago•103 comments

Ancient Patagonian hunter-gatherers took care of their injured and disabled

https://phys.org/news/2025-10-ancient-patagonian-hunter-disabled.html
50•pseudolus•6d ago•55 comments

AI and the Future of American Politics

https://www.schneier.com/blog/archives/2025/10/ai-and-the-future-of-american-politics.html
89•zdw•5h ago•36 comments