[ndxf]

I don't think any banking apps are using SQLite as their main database storage in any capacity, so the example in the article seems a tad extreme. The worst use case for SQLite that I've seen in production was a shop using it with some minimal UI on top as an order tracking system. Even in that case, the orders were accepted on paper, they just used the SQLite db as a way to track material usage so they knew what to order from the suppliers. I wonder if anyone has a more egregious or worse example of SQLite in production.

The behaviour of SQLite in not raising an error when detecting a corrupt WAL frame also seems to be on purpose.

[lxgr]

SQLite is a (maybe unexpectedly) powerful database. I would not be surprised at all if it’s used for financial data in at least some capacity.

I’m also not sure every “proper” database has application layer checksums, as that seems like a lower layer concern costing performance and possibly providing a false sense of security (it can’t help with durability at all, for example).

[twisteriffic]

> The worst use case for SQLite that I've seen in production was a shop using it with some minimal UI on top as an order tracking system. Even in that case, the orders were accepted on paper, they just used the SQLite db as a way to track material usage so they knew what to order from the suppliers.

This doesn't seem particularly egregious.

[chasil]

Well, sqlite is certified for avionics via do-178b.

What interesting things could it do in an aircraft?