Database
A database is a structured collection of records or data.
Article

MySQL on Mac OS X

In this article I'll give you an overview of MySQL's features and drawbacks, show you how to install MySQL on Mac OS X, and introduce you to some of MySQL's notable technical aspects.
Article

How to use Access 2000 as a database front end

Microsoft Access 2000 works great as a general front end and IDE for client or server databases. You can use it to manage not just data, but also the table definitions, stored procedures, indexing,...
Article

Migrating from Microsoft Access to MySQL

The following article explores reasons to consider using MySQL instead of Access for data management, and provides guidelines for transferring information out of Access and into MySQL when you're...
Article

Secure MySQL Database Design

When it comes to installing software, secure design is often the last consideration. The first goal is usually just to get it to work. This is particularly true of databases. Databases are commonly...
Article

OpenOffice.org 1.0, ODBC, and MySQL 'How-to'

This document explains how to make this connection, and then provides a quick tour of the database tools within OpenOffice.org 1.0. Many hardened OpenOffice.org 1.0 users are completely unaware of...
Article

Open Database Connectivity in Jaguar

This article will give a brief overview of ODBC followed by a recount of my experiences trying to get ODBC working with MySQL. One of the new, albeit virtually undocumented features included in...
Article

Using MySQL from PHP, Part 1

In database-driven applications, three different players produce the final output of the web page you view with your client: the web server, the scripting language (PHP), and the database back end...
Article

Database Templates with MySQL

Many databases are very similar. When creating new databases, developers often build the same basic tables with only slightly different names and some adjustments to columns. Rather than starting...
Article

Connection pooling with MySQL Connector/J

Most of these problems can be overcome with a technique called "connection pooling." In addition to fixing the problems mentioned in the previous article, connection pooling generally leads to more...
Article

Using AUTO_INCREMENT keys with Connector/J 3.0

One of the major features available in the latest version of MySQL's JDBC Driver, Connector/J, is the implementation of version 3.0 of the JDBC API that is available with JDK-1.4.0 and later. There...
Article

Exploring MySQL in the Microsoft .NET Environment

This article aims to help MySQL users get started in the .NET environment. Here is the simple control flow when using ODBC.NET solution to access MySQL.
Article

Building a Database-Driven Web Site Using PHP and MySQL

By the end of this series, you can expect to have a grasp of what's involved in setting up and building a database-driven Web site. If you follow along with the examples, you'll also learn the basics...
Article

Getting Started with MySQL

This article is the first in an educational series offered by MySQL AB aimed towards providing the reader with valuable insight into the MySQL database server. Although future articles will delve...
Article

Accessing MySQL BLOB columns using Visual Basic 6

Mike Hillyer explains how to work with BLOB columns using the ADO 2.5 stream object. One of MySQL's strengths is it's use of Binary Large Object (BLOB) columns. These columns store unprocessed binary...
Article

Why VB/MySQL

Mike Hillyer explains why he thinks Visual Basic and MySQL are an ideal combination for application development, and the motivation for his continuing series of articles on the subject.
Article

CursorTypes, LockTypes, and CursorLocations

One of the most common sources of trouble for the beginning VB / MySQL developer seems to revolve around which cursor location to use. Related to the cursor location problem is the choice of cursor...
 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.