Welcome to Bucaro TecHelp!

Bucaro TecHelp
Maintain Your Computer and Use it More Effectively
to Design a Web Site and Make Money on the Web

About Bucaro TecHelp About BTH User Agreement User Agreement Privacy Policy Privacy Site Map Site Map Contact Bucaro TecHelp Contact RSS News Feeds News Feeds

Holiday Gift Guide
Holiday Gift Guide

Create Your Own Database Using Only Notepad : CDV

Comma Delimited Values (CDV) database

Introduction

You have probably come across many instances in which you could have used a database but didn't want to go through the trouble to setup and learn a full powered database application like Access or SQL Server. In this article, I'm going to show you how to create a database using only Windows notepad along with any web browser. You won't believe how simple and powerful this method is.

The database we design will have powerful features that let you browse, search, sort, add and delete records and save your database. You will be able to use the database on your personal computer, or place the database on your website for your visitors to use.

You can create a database to organize your DVD collection, your checkbook, personal contacts or club members, or for many other purposes. For this example, we will create a database to track your ebay auctions. If you don't have any ebay auctions, don't worry. The database can easily be customized for any type of database you have in mind.

The method I describe can be interfaced to Access, SQL Server, or MySQL if you like. But for this example, I will show you how to create a database using Windows Notepad, and how to use any web browser to browse, search, sort, and display the data as a table with any number of rows.

The database that we create using Notepad will consist of comma delimited values (CDV). In other words, we will use commas to separate the data fields in the file. The downside to using a CDV Notepad database is that, although you can use any web browser to browse, search, and sort the database, you can only edit the database in Notepad.

A Brief Introduction to Databases

There are basically two different kinds of databases; flat and relational. Flat databases consist of a table. The rows of the table are called "records". Each record contains several "fields", or to put it another way, the columns of the table are called "fields".

Each record in a database should be unique. It doesn't make any sense to have two records that are exactly the same. To make sure each record is unique, usually one field of each record is a unique ID number. That field is called the "key".

A relational database consists of several tables. One field in a record "points to" a record in another table. For example, a field named "address" in one table would point to a record in another table that actually contains the name, street, city, zip, and country fields of the address. This is called a "relation".

The value in the "address" field might, for example, be "AKNEY INDUSTRIES". Maybe AKNEY INDUSTRIES supplies you with thousands of different parts. Rather than repeating the same name, street, city, zip, and country fields in the record for each part supplied by AKNEY INDUSTRIES, the relational database has a relation to another table containing the address.

This eliminates all the repeated data sometimes found in a flat database. For example, in a flat database, if AKNEY INDUSTRIES changed their address, you would have go through the parts database and change the address in every record of every part that comes from AKNEY INDUSTRIES. Not too cool.

The database we will create for this example will be a flat database. So the purpose of this brief introduction to databases is to advise you that if you need a relational database, this will not be the optimal implementation.

RSS Feed RSS Feed

Follow Stephen Bucaro Follow @Stephen Bucaro



Fire HD
[Site User Agreement] [Privacy Policy] [Site map] [Search This Site] [Contact Form]
Copyright©2001-2017 Bucaro TecHelp 13771 N Fountain Hills Blvd Suite 114-248 Fountain Hills, AZ 85268