Hey.
Serious request here.

Thinking about starting up my own website again, as a sorta portfolio to showcase the various things I do. Was considering setting up my own Content Management System, only with the bare essentials I'd be after. For example:

- A simple News Posting/Blog system which would allow viewers to posts comments (possible to track IP's in case of spammers?)
- Something which would enable me to Photos/Images? Ability to comment these would also be a great plus side. The ability to upload .SWF's would be good too, though that is also fine done manually if that'd be a pain.

Other than that, all the excess stuff would be simple codes such as a calender and RSS updates, etc.
I'm experienced in HTML, PHP and CSS enough to embark on something like this. If someone could perhaps sort me out with some information on what to do with my databases and possibly provide a basic frame/example for me to work with then that would be of great use. I've always used automated systems and forums in the past. My CSS is a little sketchy but once I get into it I tend to figure it out.

Thanks for your time guys. Any help is appreciated.
~

My recommendation when rolling your own CMS is to use Apache Jackrabbit with PostgreSQL. MySQL is fine but, postgres uses a more standard version of sql (useful when switching to Oracle down the road).

Jackrabbit (or any JCR implementation) with a RDBMS provides a good foundation for data storage and retrieval. You also get search capabilites.

Then you can just build the web stuff on top