Deploying and using it may not be completely painless, but Drupal is a great content management system (CMS) framework that is lightweight, modular, and not too difficult to navigate. There is nothing exotic or excessively "creative" in its construction — it's just a nice sensible implementation of PHP and either PostgreSQL or MySQL on the back end. What can you do with Drupal?

For starters, see it in action at such large and demanding sites as, Kerneltrap.org, CafePress, and The Onion.

The Top Drupal Sites page demonstrates what people are doing with Drupal. In a nutshell, anything that can delivered over the Web can be managed with Drupal: standard HTML pages, RSS feeds, blogs, threaded discussion forums, polls, software distribution, image galleries, multimedia, documentation ... you name it.

Full Story.