Re:Show HN: SummitDB – In-Memory NoSQL DB
by qwertyuiop924 on Wednesday October 12, 2016 @06:58PM
(#12697041)
Bizarre. SQLite is known for being hard to corrupt. How did it happen?
Re:Show HN: SummitDB – In-Memory NoSQL DB
by erichocean on Wednesday October 12, 2016 @07:09PM
(#12697091)
No idea, but with about 50,000 regular users hitting the local SQLite DB on their mobile devices hard, I'd get a corrupted DB report a few times a week.
It's possible my SQLite configuration wasn't as crash-proof as the default install. I moved onto another project before I could investigate further.
Re:Show HN: SummitDB – In-Memory NoSQL DB
by not_kurt_godel on Thursday October 13, 2016 @02:21AM
(#12698896)
Seems possible you were just seeing the rate at which people's storage hardware gets corrupted rather than an issue with SQLite.
That's LMDB, as others have noted. I have used it in production for years, never once lost data. Insanely fast, low footprint, crash-proof.
(P.s. I have seen SQLite get corrupted regularly on mobile devices, which is why I no longer use it there.)