Re: [Fofredux-devel] Hold off on commits

[Katie B. <ka...@ho...>]

On Sun, Dec 11, 2005 at 04:15:55PM -0700, Kevin wrote:
> The way the image url is stored in the DB goes against standard 
> normalization practices.  The feed image URL is stored as a column in 
> the items table.  If the feed has 1000 items,  the identical image URL 
> is stored 1000 times in the db, when it really should only be stored 
> once. (in the feed table, not the items table)

I wrote to the original patch author asking why he implemented it
that way -- it seems wrong to me, too -- and I got no response.  So
I plan to change it so the image URL is stored as a column in the
feeds table instead ASAP.

> I think this change should be made before release.  It will be alot 
> harder to do afterwards.

I agree; it will be a mess if we change it on users post-release.

> 2) I have one feed where it shows the broken image icon, when the url is 
> correct. ...
> Here's the rss url that is the problem: http://www.fark.com/fark.rss

I'm seeing the same problem with that feed image, but I don't yet
know how to explain it.

-- 
Katie Bechtold         http://hoteldetective.org/