On 12/01/2011 12:36 PM, Chad wrote: > On Thu, Dec 1, 2011 at 12:34 PM, William Lee <[email protected]> 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. >> > > That was part of bawolff's plan last summer for GSoC when he overhauled > our metadata support. He got a lot of his project done, but never quite got > to this point. Something we'd definitely like to see though! > > -Chad
William, https://www.mediawiki.org/wiki/Summer_of_Code_Past_Projects#Improve_metadata_support points me to https://www.mediawiki.org/wiki/Special:Code/MediaWiki/86169 and its followups, in case you want to take a look at that. And I am heartily in favor of merging stuff so that eventually MediaWiki trunk gets to benefit from all your improvements and you don't have to spend as much work on your own maintenance! :-) You've already seen https://www.mediawiki.org/wiki/Wikia_code right? Thanks! -- Sumana Harihareswara Volunteer Development Coordinator Wikimedia Foundation _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
