If you're following along and can't/don't want to remember the SQL syntax, use the examples from the post for LLM text-to-SQL context:
Q: Which photo has the highest number of faces?
A: SELECT SourceFile
FROM photos
WHERE RegionType IS NOT ''
ORDER BY length(RegionType) DESC
LIMIT 1;
Q: ...
You can also fetch and use the table schema with `sqlite3 exif.db .schema`
Just want to send my thanks. I’ve been a regular user since the early testflights and it’s been great seeing the iterations and improvements, particularly for me the scheduled-but-no-show ghost buses.
Eventually, once zstd support gets fully supported, and tiny gzip compression windows are not a limitation, then compressing a full layer would almost certainly have a better ratio over several smaller layers
For image and layer manipulation, crane is awesome - as is the underlying go-containerregistry library.
It lets you add new layers, or edit any metadata (env vars, labels, entrypoint, etc) in existing images. You can also "flatten" an image with multiple layers into a single layer. Additionally you can "rebase" an image (re-apply your changes onto a new/updated base image). It does all this directly in the registry, so no docker needed (though it's still useful for creating the original image).
Lindows was my first Linux distro c. 1999. It was my first year at college, majoring in Business Administration, living on campus with internet speeds above 56kbps for the first time. Trawling through the internet at that time, I stumbled on a (likely bootleg) Lindows installer somewhere and fell down the rabbit hole.
Looking back, I realize now I’d been a self-denying computer geek before then but for whatever reason Lindows, it’s wacky installer, dual boot support, and fortunate hardware compatibility gave me the right nudge at the right time to send me on a lifetime of hacking.
Almost 25 years later, most as a professional software engineer, I have a completely biased affection for this strange OS.
Exactly 6 months from today is last day of US Memorial Day holiday weekend. Lots of camping areas in the US require reservations within 6 months, making the today and the next few months the best days to get a reservation for popular summer US camping areas. Also note, recreation.gov is only for US Federal parks, many state and local parks will their own websites, apps or other systems for making reservations.
(year fixed below)