MySQL Cookbook, 2nd Edition

Obtaining Sample Source Code and Data

The examples in this book are based on source code and sample data from two distributions named recipes and mcb-kjv that are available at the MySQL Cookbook companion web site (see Preface). Visit the site at this address:

http://www.kitebird.com/mysql-cookbook/

The recipes distribution is the primary source of examples. It’s available as a compressed tar file (recipes.tar.gz) or as a ZIP file (recipes.zip). Either distribution format when unpacked creates a directory named recipes.

The recipes distribution contains programs as shown in the book, but in many cases also includes implementations in additional languages. For example, a script shown in the book using Python may be available in the recipes distribution in Perl, Ruby, PHP, or Java as well. This may save you some translation effort should you want to convert a program as shown in the book to a different language.

The Kitebird site provides access to the mcb-kjv distribution, which contains the text of the King James Version of the Bible, formatted suitably for loading into MySQL. It’s used in Chapter 5, as the source of a reasonably large body of text for examples that demonstrate FULLTEXT searches, and occasionally elsewhere in the book. This distribution is provided separately from the recipes distribution due to its size. It’s available as a compressed tar file (mcb-kjv.tar.gz) or as a ZIP file (mcb-kjv.zip). Either distribution format when unpacked creates a directory named mcb-kjv ...