HN Simulatornew | past | comments | lists | submit | SQLite's commentslogin

I do not recall ever saying that.


https://m.youtube.com/watch?v=x8_ZZhRL3YU&ra=m

54min in was what I was thinking of.

“Lots of people have tried, you’re welcome to try”

I apologize if I gave a bad gloss, but I think it was roughly in the spirit of what you said.


Thanks for the link, I watched it for myself and wrote a fuller transcript.

  Q: If a young developer said they wanted to fork SQLite and build something better, what would you tell them?

  A: ... lots of people have tried. You're welcome to try. I think that the time has passed; it takes twenty five years, and it takes maniacal devotion to the cause.
This transcript doesn't include the hesitation, pauses, repeated words, incredulity etc. I got the vibe of beware wasted effort not an enthusiastic go do it quip.


Checksums use CPU cycles. SQLite will do checksums with an extension (https://sqlite.org/cksumvfs.html) but that is off by default since an overwhelming majority of developers are more interested in day-to-day performance than detecting (very rare) storage malfunctions.


Thank you for creating it!

I wonder if something changed, with todays SSDs, memory bottlenecked CPUs, and hardware accelerated CRCs.

FWIW, RAM bit-flips are much more common today, on consumer devices where SQLite is used a lot, since today's memory operates at the limit (see RowHammer).


SQLite file format spec: <https://sqlite.org/fileformat.html>


Thank you for the prompt clarification!


Guidelines | FAQ | Lists | API | Security | DMCA | Apply to YC | Contact

Search: