Which database should I use?

Now that you have decided to use a database with your website, your first question may be "Which one do I use?"  It depends on your platform, cost, and likely volume of website traffic.

Access databases were generally not supported by internet service providers but are becoming more accepted.

To begin, you can use Access to create a local version of your database and upsize it to your ISP's SQL server or Oracle database, or find an ISP that supports Access.

Sequel Server tends to be favored for medium to large-scale databases whereas Oracle is preferred for large to massive-scale databases.

Why use a database?

Databases can be used to:

• Track website visitors
• Store product and customer information
• Generate fresh content without reprogramming the website
• Dynamically display content depending on language, region, time
• Assist in complex displays of data like graphing, charts or tables

How do I incorporate one into my website?

Basically, there are database instructions called queries which can be inserted into your HTML code with some minor modifications and objects that communicate with your website via code or queries.

Your best bet is to consult a web developer or database administrator and describe your anticipated traffic volume, platform, and budget.