MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0.

Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL. In addition, you can turn a page and find such unexpected riches as: A thorough comparison of MySQL with SQL standards and other databasesA discussion of privileges and suggested uses of privileges to enhance securityDirections for replicating a database and for running several MySQL servers on a single systemDirections for initializing a database from a flat fileGuidelines for estimating the performance of different queriesA far-reaching discussion of optimization, with reference to the implementation of MySQLInvestigations of the differences between data types and the pros and cons of each type of number, string, or timestampAn extended inquiry into the effects of using delayed insertsA candid explanation of why various errors occur and how to recover from themTips for weighted, full-text searchesDetailed descriptions of the features, strengths, and weaknesses of available table formatsA guide to adding new functions to MySQL

No serious MySQL user should be without this book.

Over the years, thousands of tools have been developed for debugging TCP/IP networks. They range from very specialized tools that do one particular task, to generalized suites that do just about everything except replace bad Ethernet cables. Even better, many of them are absolutely free. There's only one problem: who has time to track them all down, sort through them for the best ones for a particular purpose, or figure out how to use them?

"Network Troubleshooting Tools" does the work for you—by describing the best of the freely available tools for debugging and troubleshooting. You can start with a lesser-known version of "ping" that diagnoses connectivity problems, or take on a much more comprehensive program like MRTG for graphing traffic through network interfaces. There's "tkined" for mapping and automatically monitoring networks, and Ethereal for capturing packets and debugging low-level problems.

This book isn't just about the tools available for troubleshooting common network problems. It also outlines a systematic approach to network troubleshooting: how to document your network so you know how it behaves under normal conditions, and how to think about problems when they arise, so you can solve them more effectively.

The topics covered in this book include:

Understanding your network

Connectivity testing

Evaluating the path between two network nodes

Tools for capturing packets

Tools for network discovery and mapping

Tools for working with SNMP

Performance monitoring

Testing application layer protocols

Software sources

If you're involved with network operations, this book will save you time, money, and needless experimentation.

Ninety percent of companies in the United States qualify as small businesses. Every day these employers have to deal with common computing problems, such as tracking electronic documents, scheduling, accounting functions, managing contact lists, and reducing spam. Many expensive software products are available to help solve these problems, but they often have features small businesses don't need (or are missing the ones they do). Open source software presents easy-to-implement solutions at a fraction of the cost. Unfortunately, these solutions are relatively unknown to most small businesses. Open Source Solutions for Small Business Problems explores operational problems most small businesses share. It identifies good open source software that can help businesses solve these problems, and compares them to their proprietary counterparts. The strengths and weaknesses of the open source packages are discussed, and additional information is included on how to integrate open source with existing proprietary systems to achieve specific goals. This is the perfect reference for the tech professional looking for help choosing and understanding excellent open source software to deploy in a business setting, as well as for small business proprietors interested in streamlining their business problems using computer-based solutions.

The Perl Cookbook is a comprehensive collection of problems, solutions, and practical examples for anyone programming in Perl. Topics range from beginner questions to techniques that even the most experienced of Perl programmers will learn from. More than just a collection of tips and tricks, the Perl Cookbook is the long-awaited companion volume to Programming Perl, filled with previously unpublished Perl arcana. The Perl Cookbook contains thousands upon thousands of examples ranging from brief one-liners to complete applications. Covered topic areas spread across nearly four hundred separate "recipes," including: Manipulation of strings, numbers, dates, arrays, and hashes Reading, writing, and updating text and binary files Pattern matching and text substitutions Subroutines, libraries, and modules References, data structures, objects, and classes Signals and exceptions Accessing text, hashes, and SQL databases Screen addressing, menus, and graphical applications Managing other processes Writing secure scripts Client-server programming Internet applications programming with mail, news, ftp, and telnet These recipes were rigorously reviewed by scores of the best minds inside and outside Perl, foremost of which was Larry Wall, the creator of Perl himself. The Perl Cookbook is written by Tom Christiansen, Perl evangelist and coauthor of the bestselling Programming Perl and Learning Perl; and Nathan Torkington, Perl trainer and co-maintainer of the Perl Frequently Asked Questions list. —This text refers to an out of print or unavailable edition of this title.

Find a Perl programmer, and you'll find a copy of Perl Cookbook nearby. Perl Cookbook is a comprehensive collection of problems, solutions, and practical examples for anyone programming in Perl. The book contains hundreds of rigorously reviewed Perl "recipes" and thousands of examples ranging from brief one-liners to complete applications. The second edition of Perl Cookbook has been fully updated for Perl 5.8, with extensive changes for Unicode support, I/O layers, mod_perl, and new technologies that have emerged since the previous edition of the book. Recipes have been updated to include the latest modules. New recipes have been added to every chapter of the book, and some chapters have almost doubled in size. Covered topic areas include:Manipulating strings, numbers, dates, arrays, and hashesPattern matching and text substitutionsReferences, data structures, objects, and classesSignals and exceptionsScreen addressing, menus, and graphical applicationsManaging other processesWriting secure scriptsClient-server programmingInternet applications programming with mail, news, ftp, and telnetCGI and mod_perl programmingWeb programmingSince its first release in 1998, Perl Cookbook has earned its place in the libraries of serious Perl users of all levels of expertise by providing practical answers, code examples, and mini-tutorials addressing the challenges that programmers face. Now the second edition of this bestselling book is ready to earn its place among the ranks of favorite Perl books as well. Whether you're a novice or veteran Perl programmer, you'll find Perl Cookbook, 2nd Edition to be one of the most useful books on Perl available. Its comfortable discussion style and accurate attention to detail cover just about any topic you'd want to know about. You can get by without having this book in your library, but once you've tried a few of the recipes, you won't want to.

From the author's preface:

This book is a catalog of the mistakes that I've made while building more than 100 Web sites in the last five years. I wrote it in the hopes that others won't have to repeat those mistakes.

For the manager in charge of a Web publication or service, this book gives you the big picture. It is designed to help you to affirmatively make the high-level decisions that determine whether a site will be manageable or unmanageable, profitable or unprofitable, popular or unpopular, reliable or unreliable. I don't expect you to be down in the trenches typing Oracle SQL queries. But you'll learn enough from this book to decide whether in fact you need a database, whom to hire as the high database priest, and whom to allow anywhere near the database.

For the literate computer scientist, I hope to expose the beautiful possibilities in Web service design. I want to inspire you to believe that this is the most interesting and exciting area in which we can work.

For the working Web designer or programmer, I want to arm you with a new vocabulary and mental framework for building sites. There can be more to life than making a client's bad ideas flesh with PhotoShop and Perl/CGI.

For the users of the world, I document a comprehensive open-source approach to building online communities and show a collaborative Web-based way that we can dig ourselves out of our desktop application morass.

*Includes 200 photographs from Greenspun's highly successful photo.net Web site.
*Presents a general theory of the issues in Web Publishing.

The PHP 4 Bible is a comprehensive tutorial and reference to PHP. The Bible provides a clear, coherent description of PHP and how to use it whether you are a web developer, someone with ASP experience, or a C programmer. The book covers why users need PHP, how to get started, how to add PHP to HTML, and how to connect HTML web pages to databases. The authors take advantage of their own extensive experience using PHP to provides case studies of how and where to use PHP, along with advanced topics such as HTTP, cookies, redirection, building graphics, and sessions.

Why you need this book: Comprehensive tutorial for PHP4: covers all the basics of PHP 4, and how to use PHP to connect HTML- and XML-based web pages to databases.Essential reference for programmers: provides extensive PHP case studies, and appendices that get you up and running quickly if you have a experience with JavaScript, ASP, Perl and C/C++Covers the key features and improvements in PHP 4Advance topics include: building graphics, classes and objects, sessions, cookies, and real-life case studiesExpert authors: Tim Converse is a programmer with experience in web developer and who instructs at the University of Chicago. Joyce Park is a writer on open source topics and web developer who creates sites using PHP.

Sams¿ PHP and MySQL Web Development, by Luke Welling and Laura Thomson, showed that there is a strong demand for books that describe how to use PHP together with a specific open-source database to develop Web applications.

While MySQL is very popular, PostgreSQL is widely considered to be the more powerful of the two open-source databases. And PostgreSQL is rapidly gaining market share large organizations are beginning to use PostgreSQL instead of Oracle; the demand for PostgreSQL training and support has increased by some accounts 50% in the last six months; and Web hosting services increasingly offer PostgreSQL along with MySQL.

PHP and PostgreSQL Advanced Web Programming focuses on the specific needs of a PostgreSQL developer and will detail how to make use of PostgreSQL¿s unique, advanced features to develop high-availability, fail-safe Web applications with PHP and PostgreSQL.

PHP has rapidly established itself as an extremely popular open-source server-side scripting language for creating dynamic Web pages for e-Commerce and other Web applications. It runs on any Web server, and it offers a simple, intuitive, and universal solution for easy-to-program dynamic Web pages.

The latest version of PHP is a major new release that includes a new scripting engine which greatly improves the object model, adds exception handling, and provides a much better infrastructure for the integration of external technologies like Java or .NET.

This version of PHP requires significant changes in the way most Web developers approach their programming tasks, and the PHP Developer's Cookbook shows how to accomplish these common PHP taskes using the new version. The main content of the book is presented in a problem and solution format, logically organized on a topic-by-topic basis. Each question specifies a goal, and the following text provides a detailed solution that achieves the stated goal along with any additional related information.

PHP is a server-side, HTML embedded scripting language used to create dynamic Web pages. PHP is the number one add on module for Apache servers, and best of all—it—it's free! This is the only book on PHP that takes a visual approach to learning this topic. As a part of the Fast & Easy Web Development series, this book applies the highly successful combination of easy-to-understand instructions and real screenshots for a truly unique learning experience. PHP Fast & Easy Web Development is ideal for the beginning Web developer or for Web developers who want to increase their skill set.

Usage of PHP—cross-platform, server-side, HTML embedded scripting language—is rising by 100,000 domains per month. First PHP reference on market, and it contains more code examples with more comments than any other UNIX book. Provides UNIX programmers with all the necessary tools to build dynamic Web applications and databases from open-source software. CD-ROM includes Red Hat Linux 6.0 operating system, award-winning MySQL database engine, code listings, sample applications, software documentation, and much more.

I thoroughly enjoyed this...I write and maintain a fair amount of Perl, and matching and parsing patterns is often the largest part of the work.

— A.P. Lawrence, Information and Resources for Unix and Linux Systems

Perl, one of the world's most diffuse programming languages, was born out of the need to resolve the creator's dissatisfaction with what were at the time standard data-parsing solutions. Indeed, since the 1.0 release in 1987, Perl has been heralded for its powerful parsing capabilitiesfeatures that are further enhanced through the thousands of Perl extensions made available through CPAN (the Comprehensive Perl Archive Network).

Pro Perl Parsing begins with several chapters devoted to key parsing principles, discussing topics pertinent to regular expressions, parsing grammars, and parsing techniques. This material sets the stage for later chapters, which introduce numerous and powerful CPAN parsing modules, and provide an ample supply of example applications.