How to Corrupt an SQLite Database File

by jeffreyrogers • 8 years ago

104 10 8 years ago

yuchi• 8 years ago

I believe that SQLite is a continous source for awe in terms of overall quality of software. Their documentation is spot on, extremely clear and has a very low barrier for entry.

Applauds to them and the fantastic job they have been doing in the last decades.

peatmoss2• 8 years ago

Yeah, I have an incomplete, not-written-down all star list of Free/Open Source software that exhibit the following attributes:

- Level of quality that is so high that a rational commercial entity would have long ago decided that marginal gains in quality were uneconomic.

- Fills a niche that needs filling.

- Has an extended history of continual incremental improvement, most likely but not always having lived long enough to see the original creator pass the baton.

- Remains intelligible and consistent over time. If I’d been frozen a decade or two ago could I wake up today and feel familiar with the software?

SQLite is definitely on my all star list.

Simon_says• 8 years ago

What else is on your list?

angrygoat• 8 years ago

This article links this interesting fault finding report from Facebook, on file-descriptor reuse:

https://code.facebook.com/posts/313033472212144/debugging-fi...

LeonM• 8 years ago

Previous discussion (2013): https://news.ycombinator.com/item?id=6502229

joshaidan• 8 years ago

There are many fraudulent USB sticks in circulation that report to have a high capacity (ex: 8GB) but are really only capable of storing a much smaller amount (ex: 1GB)... Internet searches such as "fake capacity usb" will turn up lots of disturbing information about this problem.

This caught my attention. Never heard of this problem before, but doesn't at all surprise me.

teekert• 8 years ago

See also this story: https://news.ycombinator.com/item?id=2418837

How to Corrupt an SQLite Database File

Related Stories