Hi all
I am planning for a news distribution site which may end up very large. I have decided that I need to learn XML and that this site should be build using as much as possible.
The site has the following requirements:
companies can upload/edit/delete news items with images
companies can upload media for download or streaming
news items should be easily searchable
output should be made available for Web, WAP, PDF etc.
I propose using PHP for much of the scripting, parsing, user authentication etc, but my big question is:
How should I store the news items? Flat XML files or RDBMS?
i.e.
(PHP)->RDBMS->(PHP)->XML->XSLT->HTML/WAP/PDF
or
(PHP)->XML->XSLT->HTML/WAP/PDF
Any info on comparison tests on overheads, or whether there might be flexibility/security issues if avoiding a DB. Ultimately, the info held is not likely to be edited very often after initial upload
Any advice on the best way forward is appreciated.
