News for hackers. Stuff that matters.
Re:Exploring EXIF by miquong on Saturday August 23, 2025 @09:28PM (#45000501)
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`

There are no comments on this comment yet.