Why not use the database instead of json and yaml?

[bestrocker221]

Hi, thanks for the amazing work.
Why not use the database instead of JSON and yaml and any other non-image-video related files?

This way it would avoid creating thousands/millions of files in the file system and rather have everything in the same database?

Are there performance implications?
The database is already in use.
Caching can also be added, either within the DB or with a redis instance.

Having a medium-large library makes up for >1.000.000 files of which ~20% are YML/JSON files

Just trying to understand

[lastzero]

You can disable JSON and YAML if you don't want them. But why store JSON in Redis when you can also store it in the file system? It just complicates things and I don't see how this is faster or uses less storage in practice.

[lastzero]

As with basically everything except the mariadb database files and the static photoprism assets, you can delete them manually.

[lastzero]

Note the JSON files are used for indexing Videos and other not directly supported metadata in files, so you will lose or break functionality. See our docs.

[lastzero]

This, by the way, is also why we have not disabled them by default.

[alexislefebvre]

Yes the docs explains this: https://docs.photoprism.app/getting-started/faq/#json

So the JSON are necessary but the YAML are not.

[lastzero]

• Albums: Pictures are suddenly all the same #3320 (comment)

👉 This user says they are a "life saver"