Date: 06/29/06 (Web Development)    Keywords: blogging, rss, software, database, web

I’m looking into how one would set up an RSS feed a smallish website for fun/learning. I think my preferred method is to have a function that is called when the journal is updated that generates a static RSS page, rather than have the RSS feed query the database itself.

I like this method because an RSS feed isn’t really what I think of when I think dynamic content – it’s the same for every visitor. If you have 50-100 visitors between updates, you just saved yourself 49-99 database calls. It also feels more secure. If you’re querying a database, there is potential to fall victim to a injection attack. Well, the point where one updated the journal is still vulnerable, but that’s true in either method.

I was looking at how some of the blogging software generates RSS, but they all query the database directly from the feed. Is there something I’m missing? Why is this method so overwhelmingly preferred?

Source: http://community.livejournal.com/webdev/331678.html