SQL Cookbook (Cookbooks (O'Reilly))

Book Description

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.

Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

Bucketization, and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Customer Reviews:

It is real cook book.......2007-08-03
I am completely satisfied with this book.
Instead of inventing all the time "bicycle" I can use this book in my everyday work and concentrate on more important things in my projects.

MS SQL Server must be 2005.......2007-06-26
This is a great product but some of the advanced features weren't available in SQL Server 2000. I really liked the windowing and hierarchical queries in this book but those features are not available in 2000. For the most part 2000 isn't used that often anymore but if you are one of the unfortunate to have to use it there will be some compatibility problems with the examples in this book.
Mind-expanding.......2007-05-09
It doesn't take long to learn the basics of SQL. Once you start to do multi-table joins and you get to sub-selects and outer joins you can almost convince yourself you are an expert. Trust me. You aren't. I've read at least ten books on using SQL. This is the first one to blow my horizons away and open a completely new landscape.

The "recipies" are well explained and almost entirely practical and useful. This book showed me dozens of things I did not ever think of using SQL for, even though I have the BNF for SQL pretty much in my head after more than 18 years of being a practicing programmer.

Before this book I used to recommend "generic" SQL books to students and newbies because such books apply to virtually all SQL databases and it can be harmful for one to use a specific "dialect" (such as Oracle or SQL Server) that won't port to other SQL databases. I would urge people to learn "generic" SQL. You can always add the features of you specific dialect, but it is hard to give up features you assume will be in all dialects.

This book neatly avoids that problem by providing dialect-specific sections when you can or must code differently for a particular database. Even better, they explain the differences and the pros and cons of those differences. So this book can even be an aid to selecting the "right" database for your application.

I happen to be a fan of Open Source and Free Software and I'm pleased to say that this book covers both MySQL and PostgreSQL. Naturally it provides the "big three" of Oracle, Microsoft SQL Server, and IBM's DB2.

This book really opened my eyes to possibilities in SQL that I really didn't know existed in spite of the fact that I have been using the language (apparently without mastering it) for almost two decades.

I still recommend using a "generic SQL" book to learn the basics, but this should literally be ordered at the same time. It is the best of the "Cookbook" series that I have seen. (And I have used the Java Cookbook, Perl Cookbook, and Python Cookbook).

Too long; get the Sams 10 minute series.......2007-04-13
Too long at 600 pages. Sure you'll understand SQL if you go through all 600 pages and understand them well. Heck that's true for any subject, including the Qu'ran. But who'se got the time? Get the Sams Teach Yourself SQL in 10 Minutes, Third Edition - Ben Forta; and in about a day you'll be half way towards mastery. But if you don't value your time, perhaps you're still a student rather than a professional, then by all means read this book.
Everything you need.......2007-01-09
The Cookbook series has always been a reference for users that had at least some knowledge of the subject.
But even if you are just starting out, you can get started right away with writing commands. And since this book covers the major SQL formats, you won't be left out. I bought this book because an application uses Oracle and I was able to do what I needed to do. The great thing about the cookbook series is that you don't have to go through alot of text to get what you want. You find your problem and apply the solution.
Great book!!!

Average customer rating:

MySQl-PHP textbook

I really like this book

Fairly Useful

Buy this book

Disappointingly poor index

Web Database Applications with PHP & MySQL, 2nd Edition
Hugh E. Williams
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

General | SQL | Databases | Computers & Internet | Subjects | Books
Database Design | Databases | Computers & Internet | Subjects | Books
MySQL & mSQL | Specific Databases | Databases | Computers & Internet | Subjects | Books
General | Databases | Computers & Internet | Subjects | Books
Software Development | Software Design, Testing & Engineering | Programming | Computers & Internet | Subjects | Books
General | Programming | Computers & Internet | Subjects | Books
Databases | Software | Computers & Internet | Subjects | Books
General | Software | Computers & Internet | Subjects | Books
PHP | Programming | Web Development | Computers & Internet | Subjects | Books
General | Programming | Web Development | Computers & Internet | Subjects | Books
Web Publishing | Apple | Computers & Internet | Subjects | Books
Databases | Apple | Computers & Internet | Subjects | Books
General | Computers & Internet | Subjects | Books
General | Unix & Linux | O'Reilly | By Publisher | Books
Linux | Unix & Linux | O'Reilly | By Publisher | Books
Perl | Programming | O'Reilly | By Publisher | Books
Web Programming | Programming | O'Reilly | By Publisher | Books
General | Programming | O'Reilly | By Publisher | Books
Oracle & Database Programming | Programming | O'Reilly | By Publisher | Books
Web Authoring & Design | Web Development | O'Reilly | By Publisher | Books
Macintosh | O'Reilly | By Publisher | Books
Look Inside Computer Books | Trip | Specialty Stores | Books
All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books
Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Programming PHP

PHP Cookbook (Cookbooks (O'Reilly))

Learning PHP 5

Learning PHP and MySQL (Learning)

MySQL Cookbook

ASIN: 0596005431

Amazon.com

PHP and MySQL go hand in hand; the former has been carefully adapted, through the efforts of the open-source community, to the latter. For situations that require dynamic content but don't merit the complexity and development time of Java or .NET enterprise applications, the PHP language and the MySQL database server fit the bill perfectly. That's the point Hugh Williams and David Lane make in Web Database Applications with PHP & MySQL, which combines language tutorials with application design advice to yield a comprehensive picture of its subjects at a reasonable price. Williams and Lane--both Australian academics who use an online wine store in many of their examples--deserve tremendous kudos for their way of presenting recommended coding strategies. Though the code listings themselves aren't remarkably well commented, the authors do a commendable job of explaining in prose what the code is up to.

Case in point: The ever-essential task of using PHP to open a connection to a MySQL database, submit a query to that database, receive a response, and format the returned rows, if any. The book addresses this problem with a straight code listing, followed by text that explains what's happening in five numbered steps. Similar care goes to the other popular applications of the PHP/MySQL duo: session management, shopping carts, and authentication of users. --David Wall

Topics covered: How to use the PHP server-side scripting language and the MySQL database engine to underlie dynamic Web sites (those that rely on database queries) and full-on Web applications, such as those that require session management and maintenance of user rosters. Tutorials in both subjects begin with the basics and proceed through moderately complicated stuff, though there's no absolutely comprehensive reference here.

Book Description

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably. Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look. But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools. Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking. Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use. This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:

Installation and configuration of Apache, MySQL, and PHP on Unix®, Windows®, and Mac OS® X systems
Introductions to PHP, SQL, and MySQL administration
Session management, including the use of a custom database for improved efficiency
User input validation, security, and authentication
The PEAR repository, plus details on the use of PEAR DB and Template classes
Production of PDF reports

Customer Reviews:

MySQl-PHP textbook.......2007-02-19

As usual in text books, there is a lot of useless information that is not necessary, but since writers are paid by the word, this is to be expected.

I wish there was a section on MySQL commands.

I really like this book.......2006-11-18

I really like this book--direct, no-nonsense, and intelligently written with a minimum of jokes.

One thing that seems strange, that I'm hoping someone can clarify:

In the section of chapter 8 dealing with transactions and concurrency, there is no mention of setting transaction isolation levels (SET TRANSACTION ISOLATION LEVEL command in MySQL). Instead, concurrency is achieved solely by setting table locks.

I can sort of understand this in that the authors are using MyISAM tables. But why no mention of transaction isolation levels using INNODB tables, given that this is the more standard way of dealing with concurrency issues?

Fairly Useful.......2006-11-06

The book got me off the ground with my first client application, a rudimentary database maintenance system. Most valuable were the techniques and thorough understanding required to build a satisfactory security component.

However, it falls way short as a reference tool and could have included a more comprehensive list of mysql functions.

Buy this book.......2006-10-26

If your having trouble deciding on a book for your php & mysql development buy this book. It covers all major aspects of php and mysql web development and then some. You will find something useful on every page of this book, and theres a good amount of book here.

Disappointingly poor index.......2006-06-28

I'm new to PHP and MySQL, but a programmer for over 3 decades. I'm customizing some PHP code, using code examples for ideas. When I (a) see something I want to understand better or (b) want to find the PHP analog for basic functions, I naturally turn to the index to try to find the information I need. However, I found the index very disappointing because of what it doesn't have. For example, simple and basic keywords are not in the index: "comment", "logical operator", "and", "or", etc. I'm going to have order a different book as a PHP reference.

Average customer rating:

Too much book, too much money.
MySQL help!
Thick and Lovely
MySQL Recipes Galore!!!
Excellent Reading for MySQL Users

MySQL Cookbook
Paul DuBois
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

Database Design | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Systems Analysis & Design | Computer Science | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Perl | Programming | O'Reilly | By Publisher | Books

General | Programming | O'Reilly | By Publisher | Books

Oracle & Database Programming | Programming | O'Reilly | By Publisher | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 059652708X

Amazon.com

Good programming--which is to say, programming that yields both efficient code and a profitable life for the programmer--depends on not reinventing the wheel. If someone else has solved the problem you're facing (and someone almost always has), you'd be foolish to waste your energy figuring out your own solution. MySQL Cookbook presents solutions to scores of problems related to the MySQL database server. Readers stand a good chance of finding a ready-made solution to problems such as querying databases, validating and formatting data, importing and exporting values, and using advanced features like session tracking and transactions. Paul DuBois has done a great job assembling efficient solutions to common database programming problems, and teaches his readers a lot about MySQL and its attendant APIs in the process.

DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall

Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques.

Book Description

MySQL Cookbook provides a unique problem-and-solution format that offers practical examples for everyday programming dilemmas. For every problem addressed in the book, there's a worked-out solution or "recipe"--short, focused pieces of code that you can insert directly into your applications. More than a collection of cut-and-paste code, this book explanation how and why the code works, so you can learn to adapt the techniques to similar situations.

Customer Reviews:

Too much book, too much money........2007-07-03

If this was a quick reference book, then the information contained would be useful. This, unfortunately is a big book containing a little book's amount of useful info. Save your money and print out the mysql users guide that is available online for free. I found myself using the online guide as a reference even when the book was in front of me.

Bottom line: A wide range of methods for doing things you probably already know how to do if you are using mysql.

MySQL help!.......2007-05-28

The MySQL Cookbook weighs in at over 940 pages and will help you find quick answers to everything from beginner-level basics up through dba and software developer tricks.

The book is a collection of real-world tasks and compliments Paul's DuBois' other MySQL books very well. It goes beyond basic use and admin-level goodies - it has loads of code examples as well. As a software developer using MySQL for many projects, I find the MySQL Cookbook indispensible.

Thick and Lovely.......2007-03-08

If you deal with MySQL on a daily or weekly basis then this book is a perfect go-to. So many scenarios (recipes) are covered, from simple to fairly advanced.

This second edition is almost twice as thick as the first, but that doesn't mean it's too much to handle since you wouldn't entirely read it from cover to cover because you'll want to go try out so much of it.

This really is worth space on a shelf (digital or not). I would prefer the digital edition since it'd be a breeze to search through.

MySQL Recipes Galore!!!.......2007-02-09

At ~950 pages, the 'MySQL Cookbook' is an EXTENSIVE look at using MySQL from top to bottom. Upgrading this cookbook with lots of new material and Ruby examples, Paul DuBois takes a great book and makes it that much better. There is SO much material it would be difficult to easily condense it all, but I can provide a chapter listing that should make it easier to see all the yummies included within:

01. Using the mysql Client Program
02. Writing MySQL-based Programs
03. Selecting Data
04. Table Management
05. Strings
06. Dates and Times
07. Sorting Query Results
08. Generating Summaries
09. Obtaining and Using Metadata
10. Importing/Exporting Data
11. Generating and Using Sequences
12. Using Multiple Tables
13. Statistical Techniques
14. Handling Duplicates
15. Transactions
16. Stored Procedures, Triggers, Events
17. MySQL on the Web
18. Incorporating Query Results into Web Pages
19. Processing Web Input with MySQL
20. Using MySQL-Based Web Session Management

Add on 4 appendixes and 250+ tips/tricks/recipes/yummies (yes 250!) and you have an indispensable reference for any and all MySQL developers and/or administrators. Solid layout and regular fantastic O'Reilly writing make this a MUST HAVE book for MySQL users. Go out and get it now!!

***** HIGHLY RECOMMENDED

Excellent Reading for MySQL Users.......2007-02-09

The MySQL Cookbook removes some abstraction from reading the docs. The recipes are concise answers to real-world questions about how to accomplish specific goals with MySQL. It covers common vexing problems that would require significant spelunking in the manuals or web search engines. The recipes provide more clarifying context than the manual, making it easier to learn how to use all those arcane features you had barely noticed. Great as a reference or, upgrade your brain by reading a few entries a day.

Average customer rating:

Practical book for working programmers.
Love the recipie format
Essential once you start building your first app
Will reach both programmers and serious programming libraries.
A fine collection of problems and solutions

Rails Cookbook (Cookbooks (O'Reilly))
Rob Orsini
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Computer Science | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Unix & Linux | O'Reilly | By Publisher | Books

Linux | Unix & Linux | O'Reilly | By Publisher | Books

Web Programming | Programming | O'Reilly | By Publisher | Books

General | Programming | O'Reilly | By Publisher | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 0596527314

Book Description

Rails Cookbook is packed with the solutions you need to be a proficient developer with Rails, the leading framework for building the new generation of Web 2.0 applications. Recipes range from the basics, like installing Rails and setting up your development environment, to the latest techniques, such as developing RESTful web services.

With applications that are code light, feature-full and built to scale quickly, Rails has revolutionized web development. The Rails Cookbook addresses scores of real-world challenges; each one includes a tested solution, plus a discussion of how and why it works, so that you can adapt the techniques to similar situations. Topics include:

Modeling data with the ActiveRecord library
Setting up views with ActionView and RHTML templates
Building your application's logic into ActionController
Testing and debugging your Rails application
Building responsive web applications using JavaScript and Ajax
Ensuring that your application is security and performs well
Deploying your application with Mongrel and Apache
Using Capistrano to automate deployment
Using the many Rails plugins
Working with graphics

Whether you're new to Rails or an experienced developer, you'll discover ways to test, debug and secure your applications, incorporate Ajax, use caching to improve performance, and put your application into production. Want to get ahead of the Web 2.0 curve? This valuable cookbook will save you hundreds of hours when developing applications with Rails.

Customer Reviews:

Practical book for working programmers........2007-08-27

The "Rails Cookbook" is a very useful book for the working programmer.

Programming is all about solving problems, and that is exactly what this book is about. Each "Recipe" contains the problem, the solution and a discussion about the solution. They are concise without being too vague to be useful.

The book contains almost 200 of these problems / solutions.

This probably wouldn't be a good introduction to the language or the framework, but if you already are familiar with both - this book is a very valuable tool to help you get your work done.

Love the recipie format.......2007-06-20

Now that I've encountered a few recipies books, I have to admit I'm in love with the format. I proves very practical and much easier to use.

Essential once you start building your first app.......2007-06-08

Probably my most worn RoR book. It doesn't teach you Ruby or Rails since it's really a how-to book. I learned Ruby and Rails from other books but once I set out to build an app, I often thought to myself "now I remember reading about this somewhere, I just can't remember the syntax." Instead of digging through my other books, I thumbed through the TOC and quickly found a refresher. Well worth your money and saves you a lot of time spent on google or searching for solutions in other books.

Will reach both programmers and serious programming libraries........2007-05-08

Web programmers and practicing developers working with Rails will want this solution-oriented guide to building web 2.0 applications - a guide packed with recipes for success from the basics of installing and using Rails to the latest applications. Learn how to work with an application's logic, how to test and debit a Rails application, and use Rails plug-ins with RAILS COOKBOOK: APPLICATIONS FOR RAPID WEB DEVELOPMENT WITH RUBY, which covers version 1.2 and will reach both programmers and serious programming libraries.

A fine collection of problems and solutions.......2007-04-05

When reading the foreword of Rails Cookbook I felt a strong kinship with Zed Shaw, I too have fond memories of the first edition of Perl Cookbook and the way I relied on it once I'd taken the training wheels off. Since that one I have relied on several of the O'Reilly Cookbook series. It is only when I discard the early tutorial and dive in the deep end with a "cookbook" on my desk that I really start to learn proficiency.

I felt timorous and unsure when I finished "Agile Web Development with Rails", a marvelous tutorial that introduced me to my first real web development framework (I must have enjoyed it, I just bought the second edition). Since I have volunteered to develop a fairly large and complex web application in Rails I awaited the arrival of my copy of Rails Cookbook with hopeful anticipation and bated breath.

Rob Orsini, his fellow contributors (15 in all) and the team at O'Reilly have once again delivered. Compared to the previous titles in the series I've owned "Rails Cookbook" seems to have fewer recipes but as it is tackling an entire application framework and some serious issues, some of the solutions and discussions run a lot longer. The book is targeted at programmers who know something about web development but are early in their use of Rails, though it should be helpful to all Rails developers.

The book starts with tackling issues of installation and getting development tools installed in the first two chapters. Despite already deploying a couple of simple Rails apps I found that there was the odd useful tip in these chapters. The book then covers each of the three main sections of Rails; Active Record, Action View and Action Controller. The rest of the book goes on with large chapters on testing, Javascript, debugging, performance and hosting and deployment. Along the way it also covers REST, Action Mailer, security, plug-ins and graphics.

The extremely large section on Active Record was to me the most useful. I seem to spend an inordinate percentage of my Rails coding time with Active Record and it contains a large part of Rails power so I appreciated the size of this chapter. By contrast the chapter on graphics is almost entirely unread.

It seems obvious that this book should be compared to Pragmatic's "Rails Recipes". The first point of difference is that Rails Cookbook covers installation and setup. The second point is that is 'Recipes' covers Rails 1.1 while 'Cookbook' targets the brand new Rails 1.2. As a project fairly new on the scene Rails is a fast moving target so the six months between the two books makes a difference. Both books have excellent coverage of the various aspects of Rails, with a great deal of overlap. 'Recipes' has more, shorter pieces while 'Cookbook' tends towards longer pieces with more discussion. 'Cookbook' is also more general, with more recipes more likely to be useful in every Rails project you write.

The style is different between the two. Here Cookbook comes off second best, it feels as though tightly edited by a number of hands and ends up lacking personality; functional but cold compared to Recipes. The writing, however, is good. It's easily read, at times it feels like a good textbook. The layout is clean, it is easy to find the information you need from each recipe when you want.

With almost all "cookbook" style books I seem to be left feeling that a number of the recipes are just a little too obvious and covered well in beginner tutorials. There is some of this in Rails Cookbook, most notably the first two chapters, but overall the book will be useful to any beginner to intermediate Rails programmer. Personally I had a couple of moments where I read a tip and wanted to scream as it demonstrated and explained in a few short sentences and half a page of code what had taken me hours to discover for myself.

The "Cookbook" series all seem to be books worth the price and shelf space. This one is no exception. I'd give it three out of five with an extra half for its timely information on Rails 1.2 and would recommend it for all Rails programmers from the absolute beginner through to all but the most experienced. If you already have a copy of 'Recipes' and are happy with it then you might want to stick with that till either volume is updated for the next major revision of Rails, otherwise you will almost certainly appreciate a copy of Rails Cookbook.

Average customer rating:

Just what I needed
This book has something about sendmail for everyone
A must have for anyone who administers sendmail
Not for amatuers
A Much Easier Way to Handle Sendmail

sendmail Cookbook
Craig Hunt
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

E-mail | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Unix & Linux | O'Reilly | By Publisher | Books

Linux | Unix & Linux | O'Reilly | By Publisher | Books

Network Administration | O'Reilly | By Publisher | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 0596004710

Book Description

More often than not, the words "sendmail configuration" strike dread in the hearts of sendmail and system administrators--and not without reason. sendmail configuration languages are as complex as any other programming languages, but used much more infrequently--only when sendmail is installed or configured. The average system administrator doesn't get enough practice to truly master this inscrutable technology. Fortunately, there's help. The sendmail Cookbook provides step-by-step solutions for the administrator who needs to solve configuration problems fast. Say you need to configure sendmail to relay mail for your clients without creating an open relay that will be abused by spammers. A recipe in the Cookbook shows you how to do just that. No more wading through pages of dense documentation and tutorials and creating your own custom solution--just go directly to the recipe that addresses your specific problem. Each recipe in the sendmail Cookbook outlines a configuration problem, presents the configuration code that solves that problem, and then explains the code in detail. The discussion of the code is critical because it provides the insight you need to tweak the code for your own circumstances. The sendmail Cookbook begins with an overview of the configuration languages, offering a quick how-to for downloading and compiling the sendmail distribution. Next, you'll find a baseline configuration recipe upon which many of the subsequent configurations, or recipes, in the book are based. Recipes in the following chapters stand on their own and offer solutions for properly configuring important sendmail functions such as:

Delivering and forwarding mail
Relaying
Masquerading
Routing mail
Controlling spam
Strong authentication
Securing the mail transport
Managing the queue
Securing sendmail

sendmail Cookbook is more than just a new approach to discussing sendmail configuration. The book also provides lots of new material that doesn't get much coverage elsewhere--STARTTLS and AUTH are given entire chapters, and LDAP is covered in recipes throughout the book. But most of all, this book is about saving time--something that most system administrators have in short supply. Pick up the sendmail Cookbook and say good-bye to sendmail dread.

Customer Reviews:

Just what I needed.......2005-08-08

Great book, exactly what I needed. I'm pretty good with Sendmail, but there is nothing like just looking up an issue and following through a solution. I would recommend this to anyone who works with Sendmail!

This book has something about sendmail for everyone.......2005-01-20

This book has something about sendmail for everyone.
I know sendmail very well, and have used it for years.

But even I and sendmail gurus I work with learned a lot.

this is a great book.

A must have for anyone who administers sendmail.......2004-08-27

Working with sendmail can be very challenging at times; while the documentation for it is very complete, finding real-life use-cases can be tough and messing up a configuration is very easy. Fortunately the sendmail authors and community adopted the m4 language to help make building and managing sendmail configurations less painful (I remember having bad dreams about sendmail configuration language when I started learning it). Even with m4, understanding what goes where when and why in a sendmail configuration file can be a real challenge.

O'Reilly helped we mere mortals out tremendously with the publication of "Sendmail: The Definitive Guide," a book that helped demystify and clarify many of sendmail's inner-workings and configuration options. Even with this book, it was still hard to answer real-life use case questions, like how to enable SMTP AUTH for sendmail, how do I use LDAP with sendmail, how do I use sendmail to accept email for multiple domains in a virtual hosting environment, how do I use blackhole list services?

Enter "Sendmail Cookbook." This clear, easy to read, well-indexed book contains a wealth of useful recipies that make previously difficult to figure out tasks quite easy. The book is organized in typical Cookbook fashion; each chapter or section stands on it's own, and if it does require knowledge of other sendmail configuration topics, the section includes cross-references to other relevant recipies and references to appropriate sections in the "Sendmail: The Definitive Guide" book, which is a nice additional feature.

This cookbook starts with recipies that step the reader through building and installing sendmail, with sections on configuring the build so that sendmail compiles with SSL/STARTTLS support, LDAP support, and SASL support. Chapters that follow deal with everything from enabling and configuring SMTP AUTH, to securing sendmail itself, to controlling spam. Recipies use m4 whenever possible and only dip into the sendmail configuration language when necessary, another feature I found very impressive.

I own quite a few O'Reilly books; this is one of a small number that I enjoy just picking up and flipping to a random page and reading; I always find something that I either didn't know or had forgotten. I wish I had this book seven years ago when I was struggling to learn the basics of sendmail configuration and administration; I might have more hair left if I had! I highly recommend this book to anyone who works with sendmail, be that daily administration or occassional troubleshooting.

Not for amatuers.......2004-04-30

This is definitely a book for systems administrators. You won't learn the basics about sendmail, or get an introduction. This book is for folks who generally know sendmail, but are having specific issues with it.

The first chapter has a lot of very specific fixes for a bunch of operating system specific issues. After that the solutions become a bit more general.

The two standout chapters are chapter four, on relaying, and chapter six on spam filtering. Both of these have great introductions and in-depth techincal descriptions, with effective graphics, covering the topics.

I recommend this book for systems administrators and for people actively using with sendmail.

A Much Easier Way to Handle Sendmail.......2003-12-31

The first killer application of the Internet was email. For over twenty years, the most common program used to handle this was sendmail, written by Eric Allman. Over this time, sendmail has become a fully fledged language, with a very inelegant syntax. To learn how this, you need the book "Sendmail" by Costales and Allman.

The basic problem is that twenty years of ever increasing complexity in mail handling has created concomitant complexity in sendmail. For system adminstrators, the sendmail configuration files are probably the most complicated things they have to understand and maintain.

The rub is that most sysadmins have many duties, and little time to thoroughly read the above book. What is needed is a crib sheet, that lets you quickly solve very common sendmail configuration issues. Wherein the need for this book. Hunt takes a pragmatic approach. He tells you enough to handle these common issues. Sometimes, this comes at a slight cost. For example, he never really fully explains the the sendmail class notation. For a rigorous explanation, you still need Allman's book. But as a practical matter, you probably not that curious about the notation anyway. Hunt's approach may solve your problems quicker!

An interesting aspect of this Cookbook is that it shows the recent evolution of sendmail, as seen in the subtitle at the top of the cover, "Spam-Fighting". Sysadmins who dealt with sendmail from 5 years ago or earlier will recall nothing pertaining to antispam techniques.

But just as email was the first killer application, the second killer application was the browser, starting in 1992-3. The third killer application was spam, often viewed via the second application. In the last 5 years, spam has grown amazingly. So much so that it has been debated on the floors of the US Parliament! It has gotten to the point that some alarmists are even claiming that this third killer app might be crippling the first app!

Well, this Cookbook has several sections, including an entire chapter, focussed on various antispam techniques, like procmail parsing, or hooking up to Real Time Block Lists like spamhaus.org. The efficacy of such methods may vary widely, but you do get a choice. Though none of these currently appear to offer a truly effective countermeasure. You are still getting tons of spam, aren't you?

Book Description

This digital document is an article from The Bookwatch, published by Thomson Gale on February 1, 2007. The length of the article is 510 words. The page length shown above is based on a typical 300-word page. The article is delivered in HTML format and is available in your Amazon.com Digital Locker immediately after purchase. You can view it with any web browser.

Citation Details
Title: O'Reilly.(Learning MySQL)(SQL Hacks: Tips and Tools for Digging Into Your Data)(Essential CVS, 2d ed.)(The Relational Database)(MySQL Cookbook, 2d ed.)(Information Architecture for the World Wide Web, 3d ed.)(Book review)
Author: Gale Reference Team
Publication: The Bookwatch (Magazine/Journal)
Date: February 1, 2007
Publisher: Thomson Gale
Page: NA

Article Type: Book review

Distributed by Thomson Gale

Books:

Books Index

Books Home

Recommended Books