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)
UNunknown2 小时前
[deleted]
WEwebprofusion2 小时前
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.
WOwolfi11 小时前
if processes lock the file shouldn't AV refrain from reading or even writing it?
NOnok22kon3 小时前
> 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
REred1oon3 天前
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.
ANandrewl2 天前
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.
SHShinyLeftPad2 小时前
What changes?
LIlinzhangrun3 天前
Interesting title for official SQLite documentation :)
UNunfocso2 天前
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."
ANandrewl2 天前
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
ZEzeroimpl3 小时前
So is the official pronunciation of SQLite spelling out the letters then? I’d expect “a” not “an”…
CYcyberax3 小时前
I have never heard it pronounced in any other way than "s-q-lite".
S_s_ting7651 小时前
It's "SQL-Lite". From the horse's mouth. https://youtu.be/5zQdYx-fqJg?si=uFa7y5i-AXI1_Nl4&t=17
ANandrewl2 天前
It’s impressive. To admit fallibility is to be honest. It represents confidence.
评论
6 条顶层评论请先登录 h4cker 账号，然后连接 Hacker News 后发表评论。
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)
[deleted]
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.
if processes lock the file shouldn't AV refrain from reading or even writing it?
> 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
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.
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.
What changes?
Interesting title for official SQLite documentation :)
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."
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
So is the official pronunciation of SQLite spelling out the letters then? I’d expect “a” not “an”…
I have never heard it pronounced in any other way than "s-q-lite".
It's "SQL-Lite". From the horse's mouth. https://youtu.be/5zQdYx-fqJg?si=uFa7y5i-AXI1_Nl4&t=17
It’s impressive. To admit fallibility is to be honest. It represents confidence.
Also represents good test coverage