In this series of articles, I'm going to show you how to create a database using only Windows notepad along with Internet Explorer. You won't believe how simple and powerful this method is. The database we design will have powerful features.
Welcome to Bucaro TecHelp!

Welcome to 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 Advertise on Bucaro TecHelp Advertise Here RSS News Feeds News Feeds

Receive notification when a new article, information, or content has been posted to this website.

Email address:


Powered by FeedBlitz


Victims of Sandy Hook

Stop the Slaughter of Innocents. Congress is bought and paid for by gun lunatics and gun promotion groups. If you want to live in a safe America, help buy Congress back for America. Send a donation to Mayors Against Illegal Guns, 909 Third Avenue, 15th Floor New York, NY 10022

HTML5 Solutions: Essential Techniques for HTML5 Developers

Essential Techniques for HTML5 Developers

HTML5 brings the biggest changes to HTML in years. Web designers now have new techniques, from displaying video and audio natively in HTML, to creating realtime graphics on a web page without a plugin.

This book provides a collection of solutions to all of the most common HTML5 problems. Every solution contains sample code that is production-ready and can be applied to any project.

Click Here

Create Your Own Database Using Only Notepad : CDV

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 series of articles, I'm going to show you how to create a database using only Windows notepad along with Internet Explorer. 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, and display the data as a table with any number of rows. 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 Internet Explorer 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 Internet Explorer to browse, search, and sort the database, you can only edit the database in Notepad. Of course, this is perfect if you want to put a read-only database on your website.

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 implementaion.

Creating the CDV Database

To create the database, we first need to determine what fields we need in each record. Below is a list of the field names and their descriptions.

ItemA unique ID number
DescA Description of the item
CostWhat you paid for the item
ShipPThe shipping charge you paid to receive the item
SaleThe sales price you received for the item
ShipRThe amount you received to ship the item
ShipCThe amount you actually paid to ship the item

RSS Feed RSS Feed





Web Design Sections

Eloquent JavaScript: A Modern Introduction to Programming

Eloquent JavaScript

Eloquent JavaScript Eloquent JavaScript goes beyond the cut-and-paste scripts of the recipe books and teaches you to write code that's elegant and effective. You'll start with the basics of programming, and learn to use variables, control structures, functions, and data structures. Then you'll dive into the real JavaScript artistry: higher-order functions, closures, and object-oriented programming.

Reader Anthony says, "This book is not your typical Javascript book. Others have a utilitarian approach. In stark contrast, Eloquent JavaScript does not merely provide you a checklist of things to learn but rather paints a panorama of the possibilities that programming provides. Javascript is merely the tool used to introduce these to the reader.

Click here for more information.

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