Monday, 12th December 2022
TIL
Show files opened by pytest tests
— My test suite for [Datasette](https://github.com/simonw/datasette) has grown so large that running the whole thing sometimes causes me to run out of file handles.
TIL
Viewing GeoPackage data with SpatiaLite and Datasette
— I managed to display polygons fom a GeoPackage database file today, using SpatiaLite and Datasette.
TIL
SQLite can use more than one index for a query
— I was trying to figure out if SQLite has the ability to use more than one index as part of executing a single query, or if it only ever picks a single index that it thinks will give the best performance.