frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

A zero-dependency, ultra-lightweight database time machine for SQLite

https://github.com/nsrht/time-travel-sqlite-debugger
13•thunderbong•1h ago

Comments

simonw•39m ago
https://github.com/nsrht/time-travel-sqlite-debugger/blob/ma... works by checking the mtime on the database file (and -wal file) once per second and creating a backups/unixtime_database.sqlite file if anything has changed, then keeps the last 50 copies.

So OK for smaller database files but not great if you're pushing into a GB+ of data.

I'm not convinced by the way it copies the files - I think using a "vacuum into" backup would be safer then file copies.

Litestream offers point-in-time recovery for SQLite by backing up chunks of WAL directly, which I expect is a lot more efficient than this mechanism.

dcreater•26m ago
And using php of ai languages to do this...?

How I use LLMs to learn complex topics

https://laurentiugabriel.github.io/blog/articles/how-i-use-llms-to-learn/
66•laurentiurad•48m ago•25 comments

Mea Culpa – Dark Hours

https://blog.terrygodier.com/2026/08/09/mea-culpa-dark-hours.html
450•satvikpendem•6h ago•205 comments

Ask HN: What are you working on? (August 2026)

84•david927•2h ago•305 comments

OpenChamber: An Agentic Development Environment

https://openchamber.dev/
53•hexomancer•2h ago•33 comments

Cool URIs Don't Change (1998)

https://www.w3.org/Provider/Style/URI
104•Klaster_1•5h ago•18 comments

John C. Lilly on solid state intelligence and the elimination of man (1978)

https://kibotronics.net/unlisted/lilly-machines/
94•Kiboneu•6h ago•42 comments

Crickets as Pets

https://en.wikipedia.org/wiki/Crickets_as_pets
48•Michelangelo11•4d ago•26 comments

Show HN: A Project Oberon System version running on RISC-V instead of RISC-5

https://github.com/rochus-keller/OberonSystem/tree/op2-rv32
85•Rochus•7h ago•16 comments

If experience is the goal, then you always win

https://www.startingfromnix.com/p/if-experience-is-the-goal-then-you
27•jger15•1h ago•2 comments

How Golden Is Silence, Actually?

https://www.newyorker.com/magazine/2026/08/10/silence-kate-mcloughlin-book-review
11•tintinnabula•3d ago•0 comments

Every fast write moves work somewhere else

https://www.shayon.dev/post/2026/220/every-fast-write-moves-work-somewhere-else/
44•shayonj•4h ago•14 comments

There Are Magic Hexagons of Every Order

https://gukov.dev/math/2026/08/02/new-magic-hexagons.html
168•gukoff•12h ago•24 comments

Human vs. AI – Diff-based line-level provenance for text under agentic editing

https://github.com/eighttrigrams/us-vs-them
35•eighttrigrams•4h ago•5 comments

FCC moves to ban Lidar-equipped foreign drones from US

https://www.tomshardware.com/tech-industry/drones/fcc-moves-to-ban-lidar-equipped-foreign-drones-...
86•f-serif•3h ago•46 comments

Analyzing data from Silicon Valley ventures and founders prosecuted for fraud

https://pubsonline.informs.org/doi/full/10.1287/orsc.2024.19981
160•iamnothere•4h ago•70 comments

Saying No

https://rozumem.xyz/posts/19
55•rozumem•1h ago•43 comments

Ransomware gangs skip the CEO, head straight for the 40-something IT manager

https://www.theregister.com/security/2026/08/09/ransomware-gangs-skip-the-ceo-head-straight-for-t...
12•joebuckwilliams•44m ago•0 comments

Plug-In Solar Panels Starting to Sprout in U.S. Backyards

https://www.nytimes.com/2026/07/31/business/energy-environment/plug-in-balcony-solar.html
30•bookofjoe•1h ago•13 comments

A zero-dependency, ultra-lightweight database time machine for SQLite

https://github.com/nsrht/time-travel-sqlite-debugger
13•thunderbong•1h ago•2 comments

Microsoft Word for Windows 1.1a, Native X64 Port

https://github.com/jmarshall23/msword
151•BruceEel•14h ago•62 comments

Tom Stanton's supersonic trebuchet breaks sound barrier with gravity alone

https://www.techeblog.com/tom-stanton-supersonic-trebuchet/
146•Thorondor•4h ago•44 comments

A partial digestion of the HRT counterexample

https://terrytao.wordpress.com/2026/08/06/a-partial-digestion-of-the-hrt-counterexample/
22•ijustlovemath•5h ago•2 comments

Show HN: Today's cities on a globe of Earth's tectonic past and future

https://douwe.com/projects/tectonic_globe
24•dosinga•5h ago•5 comments

Show HN: A replayable A2A jury for tracing how agents influence decisions

https://github.com/nMaroulis/protolink/tree/main/examples/ai_courtroom
7•nmaroulis21•2h ago•0 comments

UnYOLO: Agent credential broker and policy engine for your GitHub account

https://unyolo.io/
8•hosolmaz•4h ago•0 comments

Literary Sins

https://www.thedial.world/articles/news/seven-literary-sins
20•lermontov•3d ago•2 comments

The Alpha 21264 CPU: NT's Greatest RISC (1998)

https://halfhill.com/byte/1998-12_alpha.html
66•Lammy•9h ago•50 comments

Cross-compilation with Wails (2025)

https://chriswheeler.dev/posts/cross-compilation-with-wails/
4•auraham•3d ago•2 comments

Silicon Valley misreads science fiction and undermines democracy

https://techcrunch.com/2026/08/09/historian-jill-lepore-says-the-tech-industry-is-led-by-bad-read...
198•evo_9•4h ago•152 comments

The Grid That Doubles the Strength of the Ground

https://practical.engineering/blog/2026/8/4/the-grid-that-doubles-the-strength-of-the-ground
118•michaefe•4d ago•32 comments