Yes, I'll definitly keep that in mind. Currently I'm thinking that for deleted images and old versions of images I'll keep all the metadata inside img_metadata as serialized php, since most of the use cases for having metadata in a different table really only apply to the current version of images.
Cheers, bawolff On Tue, Jun 1, 2010 at 1:23 AM, Ilmari Karonen <[email protected]> wrote: > bawolff wrote: >> >> However, if I do implement a new table as part of this, it will >> probably use page_ids to identify the image - I don't see any reason >> to artificially restrict it to just the file namespace. > > Do remember that we'll also want to store metadata for old versions of > images. And yes, I'm aware that our database schema isn't likely to lend > itself to easy and elegant solutions to that. (My advice: try to go for > simplicity at the expense of elegance, as long as it doesn't end up _too_ > ugly.) > > -- > Ilmari Karonen > _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
