> On top of that, it's the best NoSQL database currently available.
Surely that depends on the load? From what I understand Postgress isn't easy to set up when the data spans more than one server, which many NoSQL database do actually handle fairly well.
That's got some seriously limiting characteristics that make it unusable for anything but the simplest settings. Note that the subject here (SQLite) is mostly used in an embedded context and that's roughly what you are describing. Even though that is a very large number of applications it is not the one you are likely to encounter when doing stuff in services for multiple users.
If less frequently used parts of it don't fit, offload to disk.
Ideally, the DB should guarantee data integrity after a crash even if the DB is served from RAM.
That's the ideal scenario: You have the best of all worlds.
Coincidentally, that's exactly what Postgres does.
On top of that, it's the best NoSQL database currently available.
Of course, you can use it with SQL if you ever feel the need.