# SQLite [[Databases]] The little database engine that could, the magic secret weapon, the future of data. ## Links ### [[2023-10-28]] - So many cool links about sqlite: - [Simon Willison on sqlite](https://simonwillison.net/tags/sqlite/) ## [[2024-04-13]] - [[Similarity Search]] extension for [[sqlite]] based on [[FAISS]]: [sqlite-vss/docs.md at main · asg017/sqlite-vss · GitHub](https://github.com/asg017/sqlite-vss/blob/main/docs.md) ### Old An article on how Expensify uses single metal servers running SLQite instead of sharding in AWS. 1 TB RAM, 3 TB SSD, 192 cores. That's no slouch. - [Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal) « Expensify Blog](https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-qps-on-a-single-server/) An article about the [[Write-Ahead Log]] in [[SQLite]]: - [How SQLite Scales Read Concurrency · Fly](https://fly.io/blog/sqlite-internals-wal/) An article about the workings of the [[SQLite]] virtual machine. I actually wasn't aware that [[SQLite]] was using a [[Virtual Machines]] at all. This is really pretty cool, because it shows how a plan is turned into discrete instructions that are then executed: ![[SQLite-1664630341165.jpeg]] - [How the SQLite Virtual Machine Works · Fly](https://fly.io/blog/sqlite-virtual-machine/