sdinsn · HackerTrans

6 năm trướcdiscuss

> their experience report

It's not "their" experience report.

6 năm trướcdiscuss

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 năm trướcdiscuss

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 năm trướcdiscuss

> 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 năm trướcdiscuss

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 năm trướcdiscuss

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.

comments