Sun: Feb 11, 2024

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%';"     #>


Galah honeypot, an LLM (Large Language Model) powered web honeypot, currently compatible with the OpenAI API, that is able to mimic various applications and dynamically respond to arbitrary HTTP requests. So devious, I love it, waste all the script kiddy's time.     #>


MySQL Schema for Developers, really nicely done free course. I'd argue it's not just for developers, anyone who's creating databases in MySQL (or MariaDB for the better version) would benefit from this.     #>


Older Stuff