Software, your way.
How To Get Good Custom Software
(Download)
(PDF)
burger menu icon
WillMaster

WillMaster > LibraryWebsite Development and Maintenance

FREE! Coding tips, tricks, and treasures.

Possibilities weekly ezine

Get the weekly email website developers read:

 

Your email address

name@example.com
YES! Send Possibilities every week!

Why Would I Want MySQL?

First, let's talk about what it is. Then, you can decide for yourself whether or not it is for you.

What is a Database?

A database is an organized collection of information (data) stored on a computer. You could think of it as a really smart filing cabinet.

The address book of your email software is a database. A to-do list is a database (when stored on a computer).

A database is often organized as records and fields. A record can be considered one complete chunk of information and fields being the different types of information in that chunk.

But it doesn't have to be records and fields. Flat-file databases are one chunk of information per line, with or without fields. The to-do list mentioned above, for example.

And there are sophisticated databases, such as ones that contain membership records or are used to generate web pages on-the-fly. MySQL is especially suited to handle those.

What is MySQL?

The "SQL" part of MySQL means "Structured Query Language" and refers to databases. SQL commands are standardized so different software can use the same databases.

MySQL is database software that uses SQL to store, retrieve, and manipulate data. MySQL could properly be referred to as a database engine.

You tell MySQL to "store this in this format" and it does it. You say "change this into this" and it takes care of it. You request certain information and it gets it for you. The back-end filing and sorting is taken care of automatically.

MySQL can handle many users and simultaneous accesses.

Many websites that require intensive data retrieval and manipulation use MySQL as the database engine. Bookstores, article directories, catalog sites, shipping information, and blogs are examples.

Popular programming languages, including Perl and PHP, can connect with MySQL and use it for data storage and retrieval. This is often more efficient than coding an independent database for each project.

When small flat files will serve well as databases, using MySQL may be overkill. For sophisticated database requirements, however, MySQL can be ideal.

How is MySQL Pronounced?

The official way to pronounce "MySQL" is "My Ess Que Ell" (according to this page at mysql.com).

It is often prounced "my sequel." At our house it is simply "my squill."

What Alternatives Are There?

Database functions are available for many popular programming languages. Some can handle sophisticated databases.

Perl, for example, has modules available for storing and manipulating data that are efficient and reliable for up to medium-size databases. These generally have one key per record. Manipulation of fields in the record needs to be programmed for separately.

Why Would I Want MySQL?

For simple or small databases, MySQL may be more than you need, an inefficient use of resources.

When you require information updated and retrieved from a sophisticated database or set of databases, MySQL is likely to be one of the best tools for the job.

Look at your database requirements. Familiarize yourself with the options. Then, you'll be in position to make an informed decision.

Will Bontrager

Was this article helpful to you?
(anonymous form)

Support This Website

Some of our support is from people like you who see the value of all that's offered for FREE at this website.

"Yes, let me contribute."

Amount (USD):

Tap to Choose
Contribution
Method

All information in WillMaster Library articles is presented AS-IS.

We only suggest and recommend what we believe is of value. As remuneration for the time and research involved to provide quality links, we generally use affiliate links when we can. Whenever we link to something not our own, you should assume they are affiliate links or that we benefit in some way.

How Can We Help You? balloons
How Can We Help You?
bullet Custom Programming
bullet Ready-Made Software
bullet Technical Support
bullet Possibilities Newsletter
bullet Website "How-To" Info
bullet Useful Information List

© 1998-2001 William and Mari Bontrager
© 2001-2011 Bontrager Connection, LLC
© 2011-2024 Will Bontrager Software LLC