I am not a fan of this buzzword (and indeed buzzwords in general, the comment above was intending to make fun of HSBC IT for even failing at the buzzword game), but the notion of NewSQL was roughly to keep the relational model and consistency guarantees of traditional SQL databases, but also have horizontal scalability in line with NoSQL databases. DBs like VoltDB and Spanner come to mind as examples -- here are two relevant blog posts from those teams:
It was intended as a joke in context, but I believe SQLite is far more capable than most will give it credit for. This is especially true for applications which you only ever intend to run on a single logical machine. But, even for those applications requiring multiple nodes, it can still be a powerful tool if you assume clustering & replication duty in your application logic.
For any use case, SQLite is one of the best ways to persist structured data to local disk.
I try to use sqlite for all projects until i cant.
Its a little scary how much it can actually handle, and how lazy and sub optimal it is to reach for a "real" sql server before you need it.
Having the database as a simple file right next to yoyr application is incredibly convenient not to mention how brain dead things like backups are to grok.
SQLite is incredible, especially for embedded applications. It's one of those perfectly-scoped tiny pieces of software that consistently makes my heart sing.
