Database driven is a website that has most of its webpage content stored in a database. Therefore, the website content isn't actually sitting in files on the server, it is sitting in tables and columns in a database. Websites that have large number of databases will spike the CPU memory instantly. Moreover such websites will be slower in performance when compared to other due to the restriction and resource sharing.
To create database driven website, you need the following skills:
- You need to be able to write basic code using a server side scripting language such as PHP.
Database websites can provide much more functionality than static:
- Enabling users to provide content for the website. Users can publish articles on the website.
- Integration with corporate applications such as CRM systems, HR systems etc.
- You can provide advanced search functionality that enables users to filter the results based on a field.
- You can allow your users to perform tasks such as registering for a newsletter, post questions to your forums, provide comments on a blog, update their profile, etc.
Content Management Systems
Website with dynamic content usually has CMS (Content Management System) to assist the content providers in updating the website. CMS is usually provided in the form of an administration area where content providers need to log in before they can add content. Once logged in, they can create, update and delete articles. They may be able to upload files such as Word documents, PDF files etc. They might be able to upload images too.
All of this content can be stored in the database. Some may be stored on the file system too though. For example, although documents and images can be stored in the database, there are sometimes reasons to store them on the file system. Performance is often a key reason. Database size is another.
Discussion Forums and Blogs
Discussion forums and blogs have become a popular feature for many websites. Most, if not all, forums and blogs are database driven. Users can register their details, then add content. When the user clicks the "Submit" button, their details/content is inserted into the database. Then when someone decides to view this content, it is read from the database using SQL (Structured Query Language).