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:
You can also fetch and use the table schema with `sqlite3 exif.db .schema`
Readit Newsmiquong commented on Exploring EXIF (2023) hturan.com/writing/explor... · Posted by u/jxmorris12
miquong commented on Why you can’t grow cool-climate plants in hot climates crimepaysbutbotanydoesnt.... · Posted by u/surprisetalk
The author has a highly amusing, off-beat Instagram feed: https://www.instagram.com/crime_pays_but_botany_doesnt
miquong commented on How to Delete Your 23andMe Data eff.org/deeplinks/2025/03... · Posted by u/hn_acker
Is anyone having trouble downloading their data? Some data, such as "Raw Data", "Imputed Genotype Data R6", and "Phased Genotype Data" need to be requested, but I haven't heard back from them yet.
Would like to download everything first before requesting deletion.
I requested, but gave up and requested deletion after. I still haven’t received the requested data.
Still, I figure I have a few trillion backup copies… albeit in very raw format
Why do APIs like this even exist? There's no legitimate reason for an HTML webpage to need this, it's just creating more attack surface for bad actors.
Microsoft has an elaborate VS Code demo app that uses this API. Click "Open Folder" to see the API in action): https://vscode.dev
miquong commented on Playing guitar tablatures in Rust agourlay.github.io/ruxgui... · Posted by u/lukastyrychtr
Tabs seem like they'd be great training material for LLMs and generative music. Does anyone know of projects attempting this?
Update: looks like some papers got into it last year:
Rock Guitar Tablature Generation via Natural Language Processing: https://arxiv.org/pdf/2301.05295
GTR-CTRL: Instrument and Genre Conditioning for Guitar-Focused Music Generation with Transformers: https://arxiv.org/abs/2302.05393
miquong commented on Show HN: We relaunched the Official MTA App for NYC public transit apps.apple.com/ca/app/the... · Posted by u/jcrabb8
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.
Congrats to the team!
miquong commented on Dive: A tool for exploring a Docker image, layer contents and more github.com/wagoodman/dive... · Posted by u/tomas789
Is there any performance benefit to having fewer layers? My understanding is that there's no gain by merging layers as the size of the image remains constant.
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
miquong commented on Dive: A tool for exploring a Docker image, layer contents and more github.com/wagoodman/dive... · Posted by u/tomas789
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).
https://github.com/google/go-containerregistry/blob/main/cmd...
(updated: better link)
miquong commented on Shouldn't distant objects appear magnified? astronomy.stackexchange.c... · Posted by u/frabert
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.
Thanks for sharing!
Oops… it was WinLinux 2000[1] that came first for me and Lindows shortly after. Apparently the naming permutations worked for at least one person