This can be done in a number of ways. If you feel like writing your own scripts, you are basically free to choose what db and scripting language you use.
If it is a general news site such as slashdot.org - you could use the slashcode or phpnuke.
Personally, I would use PHP, Apache and MySQL...