
Scaling SQLite to 4M QPS on a single server (EC2 vs Bare Metal)
Expensify has an unusual technology stack in many ways. For example, we don't use DNS internally — just configuration-managed /etc/hosts files — and it works great. Similarly, we only make limited use of AWS — instead hosting our own hardware for the web and database layer — and it works great. But most surprising of all is that we don't use MySQL or Postgres — instead using none other than SQLite — and it works great.