I love ExifTool! So many options. If you want a SQLITE database I wrote a program that uses ExifTool to scan folders. ExifTool has this functionality built in to some extent but I just thought I'd mention it here in case someone wants to replicate the functionality in python for whatever purpose they want

    pip install xklb[full]
    library fsadd --image ./photos/

Actually, I'm not sure if I wrote my pyproject.toml correctly. You may need to install PyExifTool directly: https://github.com/chapmanjacobd/library/blob/f778e22bf80c58...