Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-05 Thread Brion Vibber
On Thu, Dec 1, 2011 at 3:36 PM, Daniel Friesen li...@nadir-seen-fire.comwrote: Why isn't our image table primary key an integer anyways? In part, legacy foolishness. :) Also, the physical storage of images is still tied to the title, so anything that renames already has to run around renaming

Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-05 Thread Lars Aronsson
On 12/05/2011 08:07 PM, Brion Vibber wrote: If extracted page text is stored in a better key-value store, we should make sure it doesn't get pulled in to backwards-compatible metadata blobs (if we keep em around as they are now) -- but they should be accessible through some API. One thing to

Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-05 Thread Krinkle
On Thu, Dec 1, 2011 at 6:34 PM, William Lee w...@wikia-inc.com wrote: 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. Per

Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-01 Thread Chad
On Thu, Dec 1, 2011 at 12:34 PM, William Lee w...@wikia-inc.com 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.

Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-01 Thread Sumana Harihareswara
On 12/01/2011 12:36 PM, Chad wrote: On Thu, Dec 1, 2011 at 12:34 PM, William Lee w...@wikia-inc.com 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

Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-01 Thread Daniel Friesen
On Thu, 01 Dec 2011 09:34:03 -0800, William Lee w...@wikia-inc.com 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

Re: [Wikitech-l] Proposal for new table image_metadata

2011-12-01 Thread bawolff
Message: 7 Date: Thu, 1 Dec 2011 12:36:02 -0500 From: Chad innocentkil...@gmail.com Subject: Re: [Wikitech-l] Proposal for new table image_metadata To: Wikimedia developers wikitech-l@lists.wikimedia.org Message-ID:       cadn73rnusx8regdubcesyg8mz1qg5sa49vamb5ed_y-vb-l...@mail.gmail.com