Introducing Databases
Part of what has unbottled community publishing is the use of databases to store and deliver content. It becomes clear to anyone working for an extended period on a website that there's a lot of repetitive work. Unless you have some way to manage your...
Planning Your Database Tables
How Relational Databases Work
As a news site, you might want to keep a database of past stories for your readers. You could keep that information in a table that looks like this:
Table name: Articles
Headline
Byline
Date
Body
Dog...
Database Applications
Open Source Options
If your site runs on open-source software, it's likely to have one of two database applications available: MySQL or PostgreSQL.
MySQL (http://www.mysql.com/ ) is the most popular open-source database application, and most open-source...
Database Workers
Who Works on Databases?
There are several people involved in getting a database-powered site up and running, especially if you are having one custom-developed for your site. They include a:
Database architect. This person looks at the type of data...