4 ms·
P.S. just gave it a go! pipx install datasette && datasette install datasette-cluster-map ## warm up HPI (to invalidate and dump a newer sqlite cache file)
by karlicoss 6y ago
P.S. just gave it a go!
pipx install datasette && datasette install datasette-cluster-map
## warm up HPI (to invalidate and dump a newer sqlite cache file)
python3 -c 'import my.photos as P; P.print_all()'
## run Datasette
datasette /path/to/cache/photos.sqlite
tada! https://imgur.com/a/N25Zirs https://imgur.com/a/N25Zirs very nice :)
Only had to adjust the query in the last step to conform to the naming (i.e. `select _cachew_union_repr_Photo_geo_lat as latitude, _cachew_union_repr_Photo_geo_lon as longitude`)
- simonw 6y agoThat's really cool!