SQLite: more powerful than you think

With over 1 trillion active databases worldwide, SQLite is ubiquitous and a solid foundation for modern systems. But did you know it can do much more than CRUD queries? In this talk, we’ll see how to use SQLite and open source extensions for vector search, spell checking, consuming pageable REST APIs and CSV files for fast prototyping, manipulating zip files, collaborating and syncing devices, and generating json data.