• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Preface > Database Coding and Platform Choices

Database Coding and Platform Choices

Many of the hacks in this book rely on your ability to set up a database and connect to it with code. A database table looks something like an Excel spreadsheet, with rows (records) and columns (fields). Table P-1 shows a simple products database table.

Table P-1. An extremely simple table with three fields (columns) and as many records (products) as you wish to store in it

ID

Description

Price

0001

Acme Widget

$37.94

0002

Industrial, Co. Wicket

$12.88

0003

Krusty Brand Tongue Depressor

$0.40

Here, each record corresponds to a single product. The data is divided into three fields: a unique numeric ID (ID), a product description (Description), and the unit price (Price). You’ll not only need to choose a database application with which to create your tables and manage your data, you’ll need to include code (specific to the platform you choose) to connect to your database.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint