2003-04-17 11:56:49 ET|
I was in a really, really boring meeting, so I decided to better utilize my cycles by sketching out the rudimentary framework for a BME/SK style site. I mainly concentrated on the MySQL table spaces and how they're laid out.
Bascially, I'm trying to keep it as modular and compartmentalized as possible, for two primary reasons. One, it's easier to task out various parts to other people that way, and two, keeping it compartmentalized means individual tables don't grow to enourmous sizes and hold everything up, performance wise.
Another question was how to handle thumbnail generate. PHP has GD built in and it does a great job of generating thumbs, but it won't work with GIFs, as GIF is a patented (and therefore requires a license) image format. ImageMagik might do, I think they just forgo the patent issue and work with GIFs anyway.
Image storage is an issue too.. ImageMagic would make it difficult to store images in the database, but storing them in the database might be a huge performance issue, I'll have to do some research on that.