I'm trying to add some functionality to Gallery and am little surprised to realise that the albums and photos dont seem to be maintained within a mySql database, but instead are saved to file. Can someone confirm if this is true, and maybe suggest how best to add additional fields to photos for categorical descriptors?
Specifically, I wish to create several categories of photos and assign each photo to at least one category. This is one additional field, but I have several such kinds of fields (with values drawn from fixed value lists) and thought the best way would be to add the lists to new SQL tables, but theres no database for Gallery - unless Ive made a mistake. Help would be warmly welcomed.
Posts: 32509
yes it's true. G1 was written a long time ago and requiring no database application was and still is a plus for some very low cost environments.
however, take a look at G2 (gallery2), it's the successor of G1 and has everything you want (very modular) and stores its metadata in a database. you can migrate your G1 to G2. also take a look at the custom fields in G2. it's not quite categories, but you can do similar stuff with it.
there may be G1 modifications to add the features you requested. i know of at least one guy that modded his G1 to use mysql for most metadata. and a lot of features was added to G1 in the last versions and 1.5 should be very satisfying also (due withing weeks).