Sounds like a good idea to me.
What things are you interested in searching? I'd like to clean up metadata a bit. Except for latitude and longitude, we don't have any notion of what the image metadata means. For example we could use a standard machine-readable notion of creation date, or author, or license.
Also, the current metadata scheme is just serialized PHP, so it allows for rich data structures in values. So a flat key-val store may not be able to hold everything.
On 12/1/11 9:34 AM, William Lee wrote:
I'm a developer at Wikia. We have a use case for searching through a file's metadata. This task is challenging now, because the field Image.img_metadata is a blob.
We propose expanding the metadata field into a new table. We propose the name image_metadata. It will have three columns: img_name, attribute (varchar) and value (varchar). It can be joined with Image on img_name.
On the application side, LocalFile's load* and decodeRow methods will have to be changed to support the new table.
One issue to consider is the file archive. Should we replicate the metadata table for file archive? Or serialize the data and store it in a new table (something like fa_metadata)?
Please let us know if you see any issues with this plan. We hope that this will be useful to the MediaWiki project, and a candidate to merge back.
Thanks, Will _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l