Useful Books and Software

New Price: $29.57 / Used Price: $10.99

The majority of this slender book comprises eminently useful syntax documentation (which is in the style of Unix man pages, with bracketed options and monospace arguments) and the other information that's specific to individual statements and functions. Additionally, it includes a relatively small amount of conceptual information, such as a section on the proper use of NULL values. The material that's not statement-specific also contrasts data-type implementations of the four covered platforms--for example, readers learn that a PostgreSQL int2 value is known as a smallint in ANSI standard SQL. This is a particularly handy reference book, if you use one of the emphasized SQL implementations. --David Wall

Topics covered: Structured Query Language (SQL), as implemented in Oracle, Microsoft SQL Server, MySQL, and PostgreSQL, as well as in ANSI standard SQL (SQL92 and SQL99). After an introduction to data types and relational database fundamentals (the latter is not emphasized), the authors document SQL statements and functions, one by one and alphabetically. They take care to point out differences among the four implementations.

SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is focused, and thoroughly comprehensive reference for those who live in a deadline-driven world. This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases. When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Third Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.

Publisher: O'Reilly Media, Inc.
Authors: Kevin Kline, Daniel Kline, Brand Hunt
Release Date: 2008-11-15
ISBN/EAN: 0596518846 / 9780596518844

New Price: $29.69 / Used Price: n.a.

MySQL 5 is slated to be the most significant release in the products history. The Definitive Guide to MySQL 5, Third Edition, is the newest revision of Michael Koflers popular book. This is the first book to offer in-depth instruction about the new features of the worlds most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQLs impressive array of new features: views, stored procedures, triggers, and spatial data types.

Whether youre a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.

Unmistakably, the advent of Open Source technologies has made a considerable impact upon the IT sector in recent years. Perhaps the repercussions of this impact resonate no more loudly than in the database sector, where Open Source databasing products offer users a comparable alternative to the costly commercial solutions available on the market today. One such Open Source database enjoying enormous popularity is MySQL. Offering very fast and reliable data management, MySQL has come to be depended on by a number of the World's largest and most respected organizations for handling mission critical information.In a successful effort to tackling those issues most important to the reader, Kofler not only concentrates on the MySQL database server itself, but also demonstrates how it can be used in conjunction with various other technologies in order to Web-enable the reader's database information.

Kofler's MySQL introduces the many facets of MySQL, guiding the reader through installation, configuration, and subsequent implementation of the popular database server. Intermingling MySQL instruction with valuable general database design philosophy, MySQL proves to be an irreplaceable resource for MySQL novices and experts alike.
Technologer is a special interest media website focused on the technology book market. The website distinguishes itself through its comprehensive evaluations, trusted buying advice, recognized industry experts, thought provoking news, reviews and analyses.

New Price: $24.76 / Used Price: $29.00

"PHP in a Nutshell" is a complete reference to the core of the language as well as the most popular PHP extensions. This book doesn't try to compete with or replace the widely available online documentation. Instead, it is designed to provide depth and breadth that can't be found elsewhere. "PHP in a Nutshell" provides the maximum information density on PHP, without all the fluff and extras that get in the way. The topic grouping, tips, and examples in this book complement the online guide and make this an essential reference for every PHP programmer. This book focuses on the functions commonly used by a majority of developers, so you can look up the information you need quickly. Topics include:

Object-oriented PHP

Networking

String manipulation

Working with files

Database interaction

XML

Multimedia creation

Mathematics

Whether you're just getting started or have years of experience in PHP development, "PHP in a Nutshell" is a valuable addition to your desk library.

Publisher: O'Reilly Media, Inc.
Author: Paul Hudson
Release Date: 2005-10-13
ISBN/EAN: 0596100671 / 9780596100674

New Price: $7.48 / Used Price: $6.85

Each technology has uses outside of this context, of course, but within it they form something greater than the sum of their parts. This book shows you how to take full advantage of this power, walking you through all the steps required to lay your Linux foundation, install and configure your Apache web server, and then begin using PHP to access content stored in MySQL. Here are a few of the specific topics you'll find covered inside:

• Installing and configuring qmail with support for IMAP, POP3, SMTP, virtual domains, spam filtering, and antivirus
• Managing system users and groups
• Configuring your network
• Creating a custom firewall script using IP tables
• Recognizing when a system is in distress
• Handling MySQL database replication
• Configuring virtual domains
• Writing a basic PHP script that integrates with MySQL

If you're new to all of this, you'll quickly get to where you need to be to start developing and deploying the higher-level pieces of your web application. Even if you have experience with one or all of these technologies, this book—including its quick-start installation appendix—is a resource you'll want close by whenever you're setting up or fine-tuning your LAMP system.

Publisher: Sybex
Authors: Eric Rosebrock, Eric Filson
Release Date: 2004-07-22
ISBN/EAN: 0782143377 / 9780782143379

New Price: $13.14 / Used Price: $18.91

New Price: $18.37 / Used Price: $15.41

New Price: $28.38 / Used Price: $17.72

Security is an issue that demands attention, given the growing frequency of attacks on web sites. Essential PHP Security explains the most common types of attacks and how to write code that isn't susceptible to them. By examining specific attacks and the techniques used to protect against them, you will have a deeper understanding and appreciation of the safeguards you are about to learn in this book.

In the much-needed (and highly-requested) Essential PHP Security, each chapter covers an aspect of a web application (such as form processing, database programming, session management, and authentication). Chapters describe potential attacks with examples and then explain techniques to help you prevent those attacks.

Topics covered include:

• Preventing cross-site scripting (XSS) vulnerabilities
• Protecting against SQL injection attacks
• Complicating session hijacking attempts

You are in good hands with author Chris Shiflett, an internationally-recognized expert in the field of PHP security. Shiflett is also the founder and President of Brain Bulb, a PHP consultancy that offers a variety of services to clients around the world.

New Price: $16.61 / Used Price: $12.95

New Price: $8.68 / Used Price: $8.73

after it is installed.

Postfix was written by well-known security expert Wietse Venema, who reviewed this book intensively during its entire development. Author Kyle Dent covers a wide range of Postfix tasks, from virtual hosting to controls for unsolicited commercial email.

While basic configuration of Postfix is easy, every site has unique needs that call for a certain amount of study. This book, with careful background explanations and generous examples, eases readers from the basic configuration to the full power of Postfix. It discusses the Postfix interfaces to various tools that round out a fully scalable and highly secure email system. These tools include POP, IMAP, LDAP, MySQL, Simple Authentication and Security Layer (SASL), and Transport Layer Security (TLS, an upgrade of SSL). A reference section for Postfix configuration parameters and an installation guide are included.

Topics include:

Basic installation and configuration

DNS configuration for email

Working with POP/IMAP servers

Hosting multiple domains (virtual hosting)

Mailing lists

Handling unsolicited email (spam blocking)

Security through SASL and TLS

From compiling and installing Postfix to troubleshooting, "Postfix: The Definitive Guide" offers system administrators and anyonewho deals with Postfix an all-in-one, comprehensive tutorial and reference to this MTA.

Publisher: O'Reilly Media, Inc.
Author: Kyle Dent
Release Date: 2003-12-01
ISBN/EAN: 0596002122 / 9780596002121

New Price: $22.00 / Used Price: $17.99