sdinsn · HackerTrans

> their experience report

It's not "their" experience report.

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 lat temudiscuss

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 lat temudiscuss

> 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 lat temudiscuss

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 lat temudiscuss

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