,
6 tweets,
2 min read
Read on Twitter
I released a fun new plugin for datasette: datasette-bplist, which adds tooling for handling values in SQLite databases that are data structures encoded using Apple’s binary plist format. github.com/simonw/dataset…
Why would you want this? Because it turns out the ~/Library/ folder on any OS X laptop is positively crammed with SQLite databases that embed binary-plist data in some of their tables.
Combine bplist_to_json() with json_extract() to pull out all kinds of interesting things...
Combine bplist_to_json() with json_extract() to pull out all kinds of interesting things...
My favourite example is the RKMaster_dataNote table tucked away in
~/Pictures/Photos\ Library.photoslibrary/database/photos.db - which contains EXIF data from every photo you've ever shared with Apple Photos. Here's a before and after shot showing what the plugin reveals
~/Pictures/Photos\ Library.photoslibrary/database/photos.db - which contains EXIF data from every photo you've ever shared with Apple Photos. Here's a before and after shot showing what the plugin reveals
And here's a SQL query which extracts the Latitude/Longitude from the most recent 1000 photos - combine with the datasette-cluster-map plugin and you get a map of your recent photo activity!
If you want to try this out on your own photo library the README has detailed instructions github.com/simonw/dataset…
Follow-up project:
