News for hackers. Stuff that matters.
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?
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.