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 data, typically files, that can be retrieved and manipulated like the other common datatypes.
Choosing the Right MySQL Version and Reporting Bugs
People often ask me about which MySQL version they should use, whether they should consider upgrading, what to do when they find a bug, and so on. Though these things are covered in the MySQL Reference Manual and other places, this article aims to cover all the essentials in the one place.
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 predictable resource usage under load, and allows deployment of applications on smaller or less-powerful hardware than would be normally required.
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 from scratch when putting together a new database, developers will sometimes copy tables from an existing database, give them new names, and then make modifications. This can be a big timesaver.
Dispelling the Myths
As anyone will tell you, competition is a good thing because it gives you a choice. Acquiring current and accurate information about your options enables you to spend your time and money in the most efficient way and is certainly time well spent.
Embedding the MySQL Server Library
By embedding the MySQL server library in MySQL applications, MySQL doesn't have to be installed on the end user's computer. It's particularly useful with small devices and public kiosks. The embedded MySQL server also has the advantage of running faster with MySQL applications since there isn't a network connection or any passing of data between the application and MySQL. It's able to avoid these factors because the server library is embedded in the compiled program. Best of all, the embedded server library is part of the MySQL distribution.
Evaluating MySQL 5.0 Key Features
MySQL 5.0 is currently in its beta phase. It may appear obvious, but software does not magically become stable (production quality) just by waiting a while! Our chief QA engineer Omer BarNir would like to ask you to assist by testing key features in 5.0: stored procedures, views, and triggers.
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.
Guaranteeing Data Integrity with MySQL 5.0
The IT crown jewels of any organization lies in their database infrastructure. Obviously, well-designed front end applications play a leading role when it comes to ensuring that critical information is captured or reviewed, but the buck stops at the database when it comes to data retention and protection. Because such things are the database's responsibility, it is important that the underlying engine act in ways that preserve the integrity and validity of the data. This means the RDBMS should stand guard and deny entry of any and all invalid data through the welcome gates of the actual database.
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, and other DBMS-related functions required of a DBA. Follow these steps to access a MySQL database (for the UNIX crowd) over the Web and manage the tables and data with Access.
MySQL 5.0 Data Dictionary
This is the fourth part in the "MySQL 5.0 New Features" series. Trudy Pelzer covers the MySQL 5.0 Data Dictionary using detailed examples, source code, and hands-on exercises.
MySQL 5.0 Triggers
This is the second part in the "MySQL 5.0 New Features" series. Peter Gulutzan covers MySQL 5.0 support for Triggers using detailed examples, source code, and hands-on exercises.
MySQL 5.0 Views
This is the third part in the "MySQL 5.0 New Features" series. Trudy Pelzer covers MySQL 5.0 support for Views using detailed examples, source code, and hands-on exercises.
MySQL 5.1's New XML Functions
MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples. You'll find that most (not all but most) examples on those pages are applicable to MySQL now.
MySQL Network and You
As news about MySQL Network is presented in the press, MySQL's Community Relations Manager Arjen Lentz explains what it all means for you, the MySQL Community, including developers.
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.
New Event Feature
This article shows a preliminary description of a new MySQL feature for scheduling and executing tasks. In version 5.1.6, MySQL has added support for events. That is, you can now say: "I want the MySQL server to execute this SQL statement every day at 9:30am, until the end of the year" -- or anything similar that involves any number of SQL statements, and a schedule.
New in 4.1: All the Little Features
We've covered the major features in 4.1, now we wrap up our 'New in 4.1' series with an article about all of the little features. But don't let their small size fool you, some of these features may be just what you've been needing from your database server.
New in 4.1: GIS and Spatial Extensions with MySQL
In this article, Anders Karlsson takes a look at the new spatial extensions in MySQL 4.1, which allow for easier manipulation and storage of spatial data in geographic information system (GIS) and non-GIS applications.
New in 4.1: Temporal Functionality
We continue our tour of new and improved features in 4.1 with a look at the changes to the temporal (date and time related) functionality, including support for fractional seconds, time zones, and a small army of new functions for slicing and dicing temporal information.
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 Jaguar is ODBC, or Open Database Connectivity. ODBC
allows programs to connect to databases from different vendors
using the same set of connectivity protocols. This allows for
simplified database programming as well as database access from
programs that normally would not allow such access. For
instance, with ODBC you can use Excel to get data from MySQL,
or you can use FileMaker to get data from Oracle.
Open Source Databases: As The Tables Turn
My July Article comparing PostgreSQL and MySQL caused a stir that really surprised me. Of course, users of both databases called the tests rigged one way or the other, even though I noted that both databases had their strong points under various circumstances.
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 what is hiding under the covers, and are amazed once they start playing with the 'hidden' tools.
Ten MySQL Best Practices
MySQL is a complex piece of software that may seem overwhelming when you're first trying to learn it. This article describes a set of best practices for MySQL administrators, architects, and developers that should help in the security, maintenance, and performance of a MySQL installation.
Upgrading a MySQL Application
In this article I will examine such a quandary and offer some suggestions for putting together an upgrade to a MySQL application. I'll provide examples of how such an upgrade might unfold. Finally, I'll also comment on how one might update the data in a reference table of an application.
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 are many changes in JDBC-3.0 that make you, the Java developer using MySQL job a little easier. Today, we'll talk about one feature in particular, the ability to retrieve the values of database-generated keys.
Using MySQL in a federated database environment
Learn how to configure DB2 II to read and write to tables and views managed by MySQL, an open source DBMS. Once you've done this, you'll be able to join and union data in your MySQL database with other corporate data accessible to your DB2 II federated database. The DB2 II family supports a wide variety of data sources, including commercial relational DBMSs, non-relational DBMSs, mainframe data, XML files, Web services, message queues and more.
Visual Basic / MySQL Datatypes
Visual Basic can be very loose with it's data types. If you want to avoid worrying about which type of data is coming from your database, you can simply not specify a datatype when you declare a variable, which defaults the datatype to variant. The variant should be avoided whenever possible, as it can be very CPU and memory intensive. This article demonstrates the different MySQL and VB6 datatypes and how they correlate.
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.
YourSQL Database Might Just Be MySQL
Your users have browsers. You have the web server and application software. Need a powerful, affordable database? What are your choices?
Files
