HackerTrans
TopNewTrendsCommentsPastAskShowJobs

sdinsn

no profile record

comments

sdinsn
·il y a 6 ans·discuss
> their experience report

It's not "their" experience report.
sdinsn
·il y a 6 ans·discuss
That doesn't answer the question. You never should have to block the UI thread. That's just poor application design, independent of the file format; you cannot blame that on SQLite.
sdinsn
·il y a 6 ans·discuss
It's funny you use that as an example, since Firefox itself uses SQLite as the application file format for history and bookmarks...
sdinsn
·il y a 6 ans·discuss
> if your program or computer dies half way, your file is hosed

Doesn't this apply to writing files in general? It's not unique to SQLite...

Edit: Nope, SQLite is designed to be protected against crashes, even OS crashes.
sdinsn
·il y a 6 ans·discuss
If you need sharding and replication, just use a different database. SQLite is not intended to solve those problems.

As for high-availability, isn't a single file on your disk the most available thing there is? :)
sdinsn
·il y a 8 ans·discuss
But does the sqlite3 module actually contain SQLite with it, or just a library to interface with it? The fix does not change any interface library code.