Re:PSA: SQLite WAL checksums fail silently and may lose data
by hinkley on Thursday July 24, 2025 @01:42PM
(#44673691)
We still have the elevator algorithm on NVMe?
[ Parent
| on HN ]
Re:PSA: SQLite WAL checksums fail silently and may lose data
by jrockway on Thursday July 24, 2025 @02:42PM
(#44674471)
NVMe drives do their own manipulation of the datastream. Wear leveling, GC, trying to avoid rewriting an entire block for your 1 bit change, etc. NVMe drives have CPUs and RAM for this purpose; they are full computers with a little bit of flash memory attached. And no, of course they're not open source even though they have full access to your system.
Re:PSA: SQLite WAL checksums fail silently and may lose data
by djfivyvusn on Friday July 25, 2025 @05:20AM
(#44681233)
Skynet gotta start somewhere.
Re:PSA: SQLite WAL checksums fail silently and may lose data
by bob1029 on Thursday July 24, 2025 @01:51PM
(#44673797)
Anything that uses NAND storage technology is going to be optimized in some way like this. NVMe is just the messenger.
Re:PSA: SQLite WAL checksums fail silently and may lose data
by lxgr on Thursday July 24, 2025 @01:47PM
(#44673755)
SQLite runs on anything from servers to Internet-connected lightbulbs.
Re:PSA: SQLite WAL checksums fail silently and may lose data
by jrockway on Thursday July 24, 2025 @02:42PM
(#44674477)
Which lightbulbs include SQLite? I kind of want one.
Re:PSA: SQLite WAL checksums fail silently and may lose data
by natebc on Thursday July 24, 2025 @03:48PM
(#44675194)
these guys have a Cree logo on their homepage so maybe Cree?
https://imaginovation.net/case-study/cree/
At least what I could turn up with a quick web search.