HackerTrans
トップ新着トレンドコメント過去質問紹介求人

sdinsn

no profile record

コメント

sdinsn
·6 年前·議論
> their experience report

It's not "their" experience report.
sdinsn
·6 年前·議論
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
·6 年前·議論
It's funny you use that as an example, since Firefox itself uses SQLite as the application file format for history and bookmarks...
sdinsn
·6 年前·議論
> 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
·6 年前·議論
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
·8 年前·議論
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.