frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Popping the GPU Bubble

https://moondream.ai/blog/popping-the-gpu-bubble
16•radq•35m ago•0 comments

Qwen 3.6 27B is the sweet spot for local development

https://quesma.com/blog/qwen-36-is-awesome/
772•stared•12h ago•561 comments

.self: A new top-level domain designed to support self-hosting

https://hccf.onmy.cloud/2026/06/21/reclaiming-our-digital-selves-hccfs-vision-for-a-human-centere...
412•HumanCCF•10h ago•243 comments

Free the Icons

https://weblog.rogueamoeba.com/2026/06/26/free-the-icons/
347•zdw•2d ago•93 comments

Study suggests most Americans would be healthier without daylight saving time

https://med.stanford.edu/news/all-news/2025/09/daylight-saving-time.html
24•andsoitis•2h ago•7 comments

Memory Safe Context Switching

https://fil-c.org/context_switches
81•modeless•5h ago•22 comments

Old Computer Challenge

http://occ.sdf.org/
36•wrxd•2d ago•6 comments

LongCat-2.0, a large-scale MoE model with 1.6T total and 48B Active

https://longcat.chat/blog/longcat-2.0/
78•benjiro29•5h ago•22 comments

Exploring PDP-1 Lisp (1960)

https://obsolescence.dev/pdp1-lisp-introduction.html
44•ozymandiax•4h ago•16 comments

Rocketlab acquires Iridium

https://investors.rocketlabcorp.com/news-releases/news-release-details/rocket-lab-acquire-iridium...
390•everfrustrated•15h ago•254 comments

Linux for the Sega MegaDrive

https://github.com/LinuxMD/linuxmd
55•HardwareLust•14h ago•7 comments

30-year sentence for transporting zines is a five-alarm fire for free speech

https://theintercept.com/2026/06/26/daniel-sanchez-estrada-zines-prairieland-free-speech/
482•xrd•1d ago•291 comments

Ornith-1.0: self-improving open-source models for agentic coding

https://github.com/deepreinforce-ai/Ornith-1
186•danboarder•12h ago•37 comments

How to corrupt an SQLite database file

https://www.sqlite.org/howtocorrupt.html
42•tosh•3d ago•12 comments

US Supreme Court rules geofence warrants require constitutional protections

https://www.theguardian.com/us-news/2026/jun/29/supreme-court-geofence-warrants-case-decision
502•cdrnsf•13h ago•232 comments

Zig – SPIR-V Backend Progress

https://ziglang.org/devlog/2026/#2026-06-26
38•Retro_Dev•4d ago•13 comments

One million passports leaked online

https://www.theverge.com/tech/947157/passports-data-breach-cannabis-club-systems-nefos-puffpal
202•jruohonen•1d ago•115 comments

Apple Neural Engine: Architecture, Programming, and Performance

https://arxiv.org/abs/2606.22283
147•Jimmc414•2d ago•19 comments

A native graphical shell for SSH

https://probablymarcus.com/blocks/2026/06/28/native-graphical-shell-for-SSH.html
276•mrcslws•14h ago•142 comments

Kb – Prolog Knowledge Base

https://github.com/mat-mgm/kb-prolog
60•triska•2d ago•6 comments

Philae's extraordinary comet landing relived (2024)

https://www.esa.int/Science_Exploration/Space_Science/Rosetta/Philae_s_extraordinary_comet_landin...
15•1970-01-01•5d ago•1 comments

South Korea to spend $1T on more memory chip production and humanoid robots

https://arstechnica.com/ai/2026/06/south-korea-to-spend-1t-on-more-memory-chip-production-and-hum...
190•jnord•7h ago•105 comments

WATaBoy: JIT-Ing Game Boy Instructions to WASM Beats a Native Interpreter

https://humphri.es/blog/WATaBoy/
197•energeticbark•14h ago•31 comments

Dark Sky Lighting

https://www.savingourstars.org/darkskylighting#whatisdarkskylighting
185•alexandrehtrb•4d ago•31 comments

Walter S. Arnold–Sculptor/Stone Carver

https://stonecarver.com/
7•NaOH•2d ago•1 comments

Wallace the 6 inch f/2.8 telescope, building it, and hiking with it

https://lucassifoni.info/blog/hiking-with-wallace/
127•chantepierre•3d ago•20 comments

What happens when you run a CUDA kernel?

https://fergusfinn.com/blog/what-happens-when-you-run-a-gpu-kernel/
234•mezark•16h ago•28 comments

Alan Kay on the meaning of "object-oriented programming" (2003)

https://notes.shixiangxi.com/en/docs/appendix/alan-kay-on-oop/
36•sxx0•2d ago•8 comments

Working With AI: A concrete example

https://htmx.org/essays/working-with-ai/
124•comma_at•14h ago•41 comments

A Fake Shell for Pangenomics

https://www.cs.cornell.edu/~asampson/blog/flash.html
5•matt_d•3d ago•0 comments
Open in hackernews

How to corrupt an SQLite database file

https://www.sqlite.org/howtocorrupt.html
42•tosh•3d ago

Comments

red1oon•3d ago
Article date is Jan 2022. This changes when SQLite runs as WASM in a browser — a context that only became properly viable with OPFS synchronous access handles in mid-2022.
andrewl•2d ago
The January 6, 2022 date at the bottom of the page is not the date the page was last updated. It is the date problem 8.9 (Boundary value error in the secondary journals used by nested transactions) directly above it was fixed. The date at the very bottom of the screen in the middle says the page itself was last updated on 2026-04-13.
ShinyLeftPad•7m ago
What changes?
linzhangrun•3d ago
Interesting title for official SQLite documentation :)
unfocso•2d ago
The whole sqlite documentation is full of gold gems and other curious documents mostly to appease bureocrats and big companies. It doubles as a fun read other than being incredibly useful.

See, for example: "Defense about the dark arts" (https://sqlite.org/security.Html) and "Why in C?" saying "Because C is best."

andrewl•2d ago
Your link to the security page is broken because of the capital H in your URL. It should be: https://www.sqlite.org/security.html
andrewl•2d ago
It’s impressive. To admit fallibility is to be honest. It represents confidence.
zeroimpl•54m ago
So is the official pronunciation of SQLite spelling out the letters then? I’d expect “a” not “an”…
cyberax•35m ago
I have never heard it pronounced in any other way than "s-q-lite".
dang•1h ago
Related. Others?

How to Corrupt an SQLite Database File - https://news.ycombinator.com/item?id=41846796 - Oct 2024 (1 comment)

How to Corrupt an SQLite Database File - https://news.ycombinator.com/item?id=33503555 - Nov 2022 (1 comment)

How to Corrupt an SQLite Database File - https://news.ycombinator.com/item?id=31214131 - April 2022 (139 comments)

How to Corrupt an SQLite Database File - https://news.ycombinator.com/item?id=16579986 - March 2018 (10 comments)

How to Corrupt an SQLite Database File - https://news.ycombinator.com/item?id=6502229 - Oct 2013 (63 comments)

nok22kon•26m ago
> Multiple copies of SQLite linked into the same application

I had recent SQLite corruption, and I suspect it was this - I was accessing an SQLite database from the same python process using both the builtin sqlite3 package, and also the third party apsw library

webprofusion•20m ago
Interesting that it doesn't specifically call out Anti-Virus scanning (which does occasionally result in at least one of these scenarios). I've seen many SQLite database become corrupted and the best you can do is have a backup.