Search / Ask a Question:
Sat, 27 May 2017

Database Driven Websites

Large websites, or small sites that grow organically to become large, usually have logistical problems that need to be solved. Often this is done through using a database to serve content on the site dynamically, and therefore make it easy to have thousands of pages on the website, as the data for the pages is stored in the database rather than thousands of individual files.

The first choice to consider is what sort of set up to go for at the backend. For small business sites and some medium business sites, a combination of PHP and mySQL is the most popular, as these are free, well supported through excellent documentation and busy user websites and reliable - and also very widespread.

Of course there are many other options and for databases with particularly valuable data, or security considerations and so on, or for a very large company there will be serious debate needed with regard the best technology solution to go for.

One important aspect of a database driven web site is of course defining the actual structure of the tables that serve the site, and also how many tables are needed and how the site will be built to reflect these, or vice versa.

An important process to go through is normalisation, whereby you reduce the data held in each table to that which is absolutely necessary, in other words you try to eliminate any duplication. This is not as easy as it seems and can require a lot of thought.

Investing time into getting the database structure just right up front can save a lot of problems and issues down the line, so it is one of the key steps of creating any database driven website.

Clarity Media has particularly specialised in building large, dynamic sites that are database driven.

If you have any questions with regard database design or require a quote for a database driven website, please do Contact Us to discuss what you need in more detail.

More Knowledge Bank Articles:
Word Puzzles

Buy Crosswords
Children's Puzzles
Wordsearch
CodeWords
Arrow words
Kriss Kross
Word Ladder
Word Wheel

Number & Colouring Puzzles

Buy Sudoku
Children's Sudoku
Samurai Sudoku
Jigsaw Sudoku
Futoshiki
Mind Games
Killer Sudoku
Kakuro
Chess Puzzles
A - Z of Puzzles
Colour By Number
Dot To Dot
Adult Colouring

Key Links

View a single page overview
list of puzzles
with a picture of each and a link to more information.

list of kids puzzles

Contact us


Puzzle Tools

Puzzle FAQ
Codeword Solver
Rhyming Dictionary
Puzzle Solving Tools

Services

Puzzles for Apps
Article Writing
Themed Puzzle Pages
Press Ready Puzzles
Questions
Page Fillers

View all services