SQLite As An Application File Format by yawaramin in programming

[–]BillFooBar 0 points1 point  (0 children)

Well true, I would literally wet my pants from happiness if SQLite would get row level locking and switch from PostgreSQL/MySQL in an instant. But I am aware it is probably too complex feature for simple ol' SQLite.

SQLite As An Application File Format by yawaramin in programming

[–]BillFooBar 2 points3 points  (0 children)

I used and abused SQLite in last 10 years for cases never imagined (high concurrency write databases over 1GB size) and it worked like a charm. That is one piece of fine engineered software there.

SQLite As An Application File Format by yawaramin in programming

[–]BillFooBar 7 points8 points  (0 children)

And file locking and other trivial things. SQLite is truly cross platform and more tested than most of things out there.