Performance of SQLite is definitely OK for simple queries. It does take database statistics into account, but AFAIK it doesn't do parameter sniffing. Personally I wouldn't use it for a...

Just a few small corrections: The article states that everything is stored as string. This is not correct, SQLite supports blobs / integers / floats natively. Replication can be done...

It's kind of surprising to me that Steve Jones makes the distinction based on liability and formal knowledge. That might be an US thing. As an engineer, liability is part...