Saturday, February 25, 2012

Content Management System where everything is read from a database

Most content management systems I've seen have data from a database, and fixed template and background information held in ASP and XML files. Surely it would be easier and more centralised to have everything stored in a database?

I've created a simple content management system that does this using SQL Server 2003, and it does work, albeit a little slowly.

My intention is to develop this into a "proper" content management system that I could sell.

My question is is this a sensible idea to persue, from a technical perspective? Does SQL Server have the capability of supplying large amounts of data to web browser clients? Are there any other issues?

I've also just noticed that Microsoft appear to have added something similar to this type of functionality in the latest version of SQL: SQL 2005. Maybe I'm too late?

More details on my fledgling system are on:

http://dohat.com/dohatcms

Which itself is hosted on it.

Cheers.

Hi Neil
There are several content management systems commercially available. I believe some of them serve everything off a database. SQL Server 2005 has capability to provide results to requests via SOAP and also contains Reporting Services. I'm not sure if these are the capabilities you refer to.

- Christian Kleinerman
Program Manager
SQL Engine

No comments:

Post a Comment