With over one trillion active databases worldwide, SQLite is ubiquitous. With a file format that boasts a 25-year backward compatibility promise and an endorsement by the American Library of Congress, it is also a solid foundation for durable 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, inspecting Unix ELF symbols, collaborating and syncing devices, and generating json data. Finally, we’ll conclude this tour by looking at the open source community around SQLite.