exif-database - photo details into sqlite. I have somewhere around 4Tb of my own digital photos that I've taken over the 22 years I've had a digital camera and while my organization is pretty good there's still times I want to do things like "show me all the photos I took October 6 2008" or some such. I pointed this at my drive and it took a bit (maybe 45 minutes?) but now I have an sqlite database that's super easy to query, for example:

sqlite3 photos.db "SELECT filename FROM exif_data WHERE json_extract(exif_json, '$.DateTimeOriginal') LIKE '2008:10:05%';"