Web Database Applications with PHP & MySQL, 2nd Edition

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:

Really comes in handy for a Quick snippet.....
most useful python book to have on your shelf
once read, does't read so many times
Good book for taking your python skills to the next level
Good stuff

Python Cookbook
Alex Martelli , Anna Ravenscroft , and David Ascher
Manufacturer: O'Reilly Media, Inc.
ProductGroup: Book
Binding: Paperback

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

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

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

Scripting Languages | Programming | O'Reilly | By Publisher | Books

General | Programming | 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:

ASIN: 0596007973

Book Description

Portable, powerful, and a breeze to use, Python is the popular open source object-oriented programming language used for both standalone programs and scripting applications. It is now being used by an increasing number of major organizations, including NASA and Google. Updated for Python 2.4, The Python Cookbook, 2nd Edition offers a wealth of useful code for all Python programmers, not just advanced practitioners. Like its predecessor, the new edition provides solutions to problems that Python programmers face everyday. It now includes over 200 recipes that range from simple tasks, such as working with dictionaries and list comprehensions, to complex tasks, such as monitoring a network and building a templating system. This revised version also includes new chapters on topics such as time, money, and metaprogramming. Here's a list of additional topics covered:

Manipulating text
Searching and sorting
Working with files and the filesystem
Object-oriented programming
Dealing with threads and processes
System administration
Interacting with databases
Creating user interfaces
Network and web programming
Processing XML
Distributed programming
Debugging and testing

Another advantage of The Python Cookbook, 2nd Edition is its trio of authors--three well-known Python programming experts, who are highly visible on email lists and in newsgroups, and speak often at Python conferences. With scores of practical examples and pertinent background information, The Python Cookbook, 2nd Edition is the one source you need if you're looking to build efficient, flexible, scalable, and well-integrated systems.

Customer Reviews:

Really comes in handy for a Quick snippet............2007-07-05

Hi whoever invented the cook book concept should be really brilliant.I have always had a liking for the cookbook series from o'reilly and this one is a clear winner.It really comes in useful as a quick reference for any small piece of code that u are trying to do to fit in to ur application and finding it difficult for and out of box idea in code.My favorites in python cookbook are the sections on Algorithms and Programs about Programs.A must have for anyone who wishes to explore the charm called python.

most useful python book to have on your shelf.......2007-06-06

I'm new to python but not programming. Like a lot of people I had a need to get up to speed really quickly on Python so I purchased several Python books (Learning Python, Python Essential Reference, and this book). What I've found is that once you learn the basics, I find myself using this book much more than the others. It's a great little "cheat". You start with wanting to accomplish something-or-other and simply look it up in the appendex and there is a real good chance you'll find something similar that will at least get you started. The scope that they cover is really impressive, and the examples are simple and to the point. Just what I need. There is not tons of description for each thing, just enough to get you started. This is truly and invaluable resource.

once read, does't read so many times.......2007-05-19

I expected this book explain the detail sample of python libraries that python library help does not explains.
This book gathers many examples wide domain of program, network, web programming, language basics, xml, design patterns, and so on.

But not include the detail explannation of python's libraries, I think gathering many samples is very easy in this internet world, so, to know many samples from the book like this is only the time consuming.

TO know short samples of library and extend yourself without detail knowledge of libraries, this book is worth reading, otherwise, choise another book.

Good book for taking your python skills to the next level.......2007-05-14

This is an excellent book for anyone who knows programming, and knows a little bit of python already. It is formatted exactly as a cookbook, many 2-3 page recipes for solving a specific common problem. As such it has many coded examples, all of which demonstrate good programming style and may introduce the reader to some of the more obscure features of the language. It also covers a very wide array of topics, many of which are pure gold. And possibly the best aspect of the book is that it makes a great compliment to resources available on the internet (which are mostly scattered and unorganized).
The drawbacks are that it doesn't cover any topics to a great depth, which is understandable given the nature of the book. Also, it talks about small atomic solutions, but will not help you develop your skills at developing large software systems with python. Lastly, as of this review, python 2.5 has been out for months, and python 3000 is in the works, so look for a new edition or a more contemporary text.

Good stuff.......2007-05-07

Lots of great ideas in this book. It will help you get your head around Python. A little advanced so I would start with Learning Python or Python for Absolute Beginners.

Rapid Web Applications with TurboGears: Using Python to Create Ajax-Powered Sites (Prentice Hall Open Source Software Development Series)

Average customer rating:

Frustrating Read
Read once for the content, keep open as a reference.
I know computer books are obsolete in a short time, but come on.
A lot of useful information. A lot of editing problems.
Flawed, but still useful

Rapid Web Applications with TurboGears: Using Python to Create Ajax-Powered Sites (Prentice Hall Open Source Software Development Series)
Mark Ramm , Kevin Dangoor , and Gigi Sayfan
Manufacturer: Prentice Hall PTR
ProductGroup: Book
Binding: Paperback

General | Programming | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | 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:

ASIN: 0132433885

Book Description

<>âDear PHP,

It’s over between us. You can keep the kitchen sink, but I want my MVC.

With TurboGears, I was able to shed the most heinous FileMaker Pro legacy âsoluÂtion’ imaginable. It has relationships based on fields that change frequently, causing âdisappearing data.’ I replaced it with an easy to maintain TurboGears application. Defunkifying and normalizing many years worth of munged data took twice as long as developing the TurboGears’s application itself. TurboGears’s excellent set of tools and best-of-breed approach makes it so easy to build applications quickly.â

â Isaac Csandl, Manager of Information Technology, Chicago Legal Search, Ltd.

âTurboGears has resulted in significant time savings for rPath. Before it was released, we exÂpected to spend significant time building a Web framework for our rPath Appliance Agent product. TurboGears sharpens our focus on building a quality application; it allows us to provide more value to our customers, rather than reinventing the Web wheel.â

â Michael K. Johnson, rPath Founding Engineer and Coauthor of Linux Application Development, Second Edition

âI think this is the first time that a Web framework’s functionality has been so obvious.â

â Bruce Eckel, Author of Thinking in Java and Thinking in C++

âTurboGears helped me build more complex Web applications more quickly and with fewer headaches than any other framework I’ve used. Just like Python itself, it made me more productive with a minimal learning curve.â

â Quentin Hartman, System Administrator

âTurboGears has changed the way I develop Web applications, from model, to view, to controller. Thanks to the power of TurboGears, I was able to develop the first version of WhatWhat in less than a week of my spare time.â

â Jonathan LaCour, Development Team Lead, Optio

âTurboGears has provided a way for me to greatly enhance my productivity by realÂizing the potential of Web-based agile development with Python.â

â Brandon Goldfedder, Vice President of Engineering, Information Extraction and Transport (IET Inc.), and Author of The Joy of Patterns

âTurboGears really changed the way I schedule project releases: It allows me to deliver them faster and with better quality than when I used to use GUI toolkits.â

â Jorge Godoy, Owner of G2C Tech Consultoria in Brazil, former Lead Developer for Conectiva documentation team

âWith TurboGears, I was able to transition my Python projects into Web applications as easily as possible.â

â Benjamin T. Hamilton, Software Engineer

âNorwegian-based company Scanmine AS makes extensive use of Python and Turbo-Gears in all parts of its operation. TurboGears makes it a breeze to build highly sophisÂticated Web 2.0 applications with out-of-the-box features for multiple languages with full Unicode, REST, AJAX, RSS/Atom, and more. This enables Scanmine to put a face on their technology development in a minimal amount of time.

âIt has been said that there are as many Web frameworks as there are Python Web programmers. This apparent Web framework fragmentation has long been perceived as a weakness, until TurboGears came along and turned weakness into strength.â

â Rune Hansen, Senior Systems Designer, Scanmine AS

âTurboGears is a well thought-out framework; the design choices it has made will help you be more productive. TurboGears will give you confidence with its foundation of stable best-of-breed Python components. If you are coming from other languages, consider working in TurboGears and Python to bring fun back into your Web developÂment work.â

â Jeff Marshall, Partner with FrozenBear

âWhen we started developing Oprius Foundations with TurboGears, we weren’t sure if it really would help us develop quicker and higher-quality code. After two months, we had a task manager to rival Tada List. After seven months, we had an entire contact management system to compete with the big boys.â

â Jason Chu, Lead Developer, Oprius Software Inc.

âConventional programming wisdom states that rewriting any working project from scratch is a bad idea. TurboGears was good enough to convince me to do this anyway, and I have been nothing but thrilled with the results. With TurboGears, I was able to implement an AJAX-based Web site with a nice Web API more easily than I ever thought possible. If you are trying to do either of those in Python, you owe it to yourÂself to look at this project. Using TurboGears was one of the few times in my programÂming career where a task was significantly less complicated than I thought possible.â

â Adam Jones, Lead Programmer, RecursiveThought Software

Master TurboGears: The Easy Python Framework for Rapid Web Development

TurboGears harnesses the power of Python to provide a dynamic and easy-to-use Web development framework: one that
dramatically increases developer productivity, and makes it far easier to create dynamic, user-friendly, Ajax-enabled Web applications. Now, for the first time, there’s a definitive guide to TurboGearsâcoauthored by its creator, Kevin Dangoor.

This book will help experienced Web developers get productive with TurboGearsâfast. You’ll quickly build your first TurboGears Web applicationâthen extend it one step at a time, mastering the underlying libraries that make these enhancements possible. Next, the authors demonstrate TurboGears at work in a real-world application, by examining the code for âWhatWhat Status,â an open source project status tracking application. Finally, you’ll gain deep insight into the model, view, and controller technologies TurboGears is built upon: knowledge that will help you build far more robust and capable Python applications.

Coverage includes

Understanding the architecture of a TurboGears application
Mastering SQLObject, customizing it, and using it with TurboGears models
Utilizing TurboGears view technologies, including dynamic templates and MochiKit for Ajax
Bringing CSS, XHTML, and JavaScript together in reusable components with TurboGears Widgets
Using CherryPy and TurboGears controller technologies: from decorators to deployment
Exploring the TurboGears toolbox
Ensuring security and managing user access permissions in TurboGears applications

Preface xxiii

Acknowledgments xxv

Part I: TurboGears Fundamentals

Chapter 1: Introduction to TurboGears 3

Chapter 2 Getting Started with TurboGears 13

Chapter 3: The Architecture of a TurboGears Application 25

Part II: Building a Simple TurboGears Application

Chapter 4: Creating a Simple Application 43

Chapter 5: Enhancing Our Bookmark Application 59

Part III: Exploring a Real World TurboGears Application

Chapter 6: Exploring More Complex Models in WhatWhat Status 83

Chapter 7: Controllers, Views, and JavaScript in the WhatWhat Status 97

Chapter 8: RSS, Cookies, and Dynamic Views in WhatWhat Status 115

Chapter 9: Ajax and WhatWhat Status Projects 133

Part IV: SQLObject and TurboGears Models

Chapter 10: SQLObject Basics 151

Chapter 11: Mastering SQLObject 165

Chapter 12: Customizing SQLObject Behavior 183

Part V: TurboGears View Technologies

Chapter 13: Dynamic Templates with Kid 209

Chapter 14: Creating Better JavaScript with MochiKit 225

Chapter 15: Effective Ajax with MochiKit 273

Chapter 16: TurboGears Widgets: Bringing CSS, XHTML, and JavaScript Together in Reusable Components . 309

Part VI: CherryPy and TurboGears Con...

Customer Reviews:

Frustrating Read.......2007-07-11
I'm working on a Turbogears app. I find it a good framework. The book, however, is frustrating to work with. I rarely have time to read computer books sequentially. I generally jump around trying to find answers to my questions. I'm not finding answers... just partial examples throughout.

For example, I would expect an AJAX example to have all the pieces necessary to implement an AJAX conversation with the file names clearly labeled. I would expect a diagram of how the pieces interact. What I find is little snippets of code without context and no diagrams anywhere in the book.

I think the authors did a reasonable job of explaining Turbogears from their perspective. It was the editors' job to push them to explain things from their audience's perspective. This has the look of a rush job.

Read once for the content, keep open as a reference........2007-06-22
I use this book daily. The book is a great read and walks the reader through many of the complexities of modern web-app development in a clear and easy style. Though there are plenty of gotchas throughout the book, the errata site has most of them nailed cold. The clarity of thought and insight into the rationale behind the design of TurboGears are well worth the price of entry. In addition to covering the current state of TurboGears, the book discusses many of the future options for the project, giving it life beyond the 1.0 version.
I know computer books are obsolete in a short time, but come on........2007-05-24
The information in this book is completely out of date only a few months after it came out. Turbogears 2.0 is going to basically replace every component of TG 1.0. So I would not recommend buying this book unless you want to re-learn everything again when the Turbogears 1.0 codebase is abandoned (it largely already has been as developers move to 2.0 or other frameworks).

Turbogears is a good example of what happens when PR outruns project maturity, and fundamental decisions are abandoned late in a development cycle.
A lot of useful information. A lot of editing problems. .......2007-04-26
I ordered this book immediately after "discovering" TurboGears. It is full of useful information, but the editing and organization leave a lot to be desired.

It is VERY IMPORTANT to be familiar with Python, because a lot of the programming examples contain mistakes. Many of the issues look like search-and-replace problems, because half of the examples in a chapter might refer to a class named one thing, and the others might refer to a different name that is obviously the same thing if you are paying attention.

Given that online documentation for TurboGears also seems somewhat disorganized and scattered, I'll be using this book as reference information while working on my first TG-based site.

Since the book provides a ton of information about a broad range of topics (TurboGears is, after-all, a conglomeration of a bunch of separate technologies), I'm overlooking the editing errors and giving it a 4 out of 5.
Flawed, but still useful.......2007-03-16
I was somewhat disappointed with this book, although I still found it to be useful for learning TurboGears. I won't mince words: the editing sucks. If you can get through the typos, though, you'll learn a fair amount and be better positioned to do something useful with TurboGears after you've read the book. Treat the book more as a tutorial than a reference.

Average customer rating:

Web Component Development with Zope 3

Excelent material

Web Component Development with Zope 3
Philipp von Weitershausen
Manufacturer: Springer
ProductGroup: Book
Binding: Hardcover

Software Development | Software Design, Testing & Engineering | Programming | Computers & Internet | Subjects | Books
General | Programming | Computers & Internet | Subjects | Books
General | Computers & Internet | Subjects | Books
General | Operating Systems | Computers & Internet | Subjects | Books
General | Software | Computers & Internet | Subjects | Books
Look Inside Computer Books | Trip | Specialty Stores | Books
All Deals | Blowout Books | Stores | Books
Computers & Internet | Blowout Books | Stores | Books
All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Zope 3 Developer's Handbook, First Edition

Building Websites With Plone

The Definitive Guide to Plone

Content Management with Plone: Handbook for Authors and Editors

Web Component Development with Zope 3

ASIN: 3540338071

Book Description

Zope is a powerful Python web application platform for developing complex web applications rapidly and collaboratively. With version 3, Zope has been rebuilt on top of a Component Architecture that combines the best ideas available from modern web platforms.

This book focuses on Zope 3, though it also addresses the needs of Zope 2 developers who want to use Zope 3 features as they are backported into the Zope 2 platform. First, the key concepts of Zope and its Component Architecture are introduced. Each of Zope's capabilities is demonstrated by building a sample application and then extending it with more features.
Now in its second edition, the book has been overhauled completely. It has been adapted to the changes and new features in Zope 3 since its first release. The new edition also makes it easier to get started with Zope, incorporating input and suggestions from Zope 3 experts and newcomers alike.
Customer Reviews:

Web Component Development with Zope 3.......2007-09-06
The book seems to be well written, and pretty detailed in it's methods, But for me it is to advanced for what I was looking to get from the book.
Excelent material.......2007-04-08
Very good book about Zope3. Clear conceptual explanation of the tecnology and easy to understand examples. I'm very impressed with zope3.

Average customer rating:

Beware: Now an on-demand reprint

Brevity is the soul of wit, and utility in this case,

Justifies the title

New to Python? This book is the best.

Nice!

Python (Visual QuickStart Guide)
Chris Fehily
Manufacturer: Peachpit Press
ProductGroup: Book
Binding: Paperback

General | Programming | Computers & Internet | Subjects | Books
Python | Languages & Tools | Programming | Computers & Internet | Subjects | Books
General | Languages & Tools | Programming | Computers & Internet | Subjects | Books
General | Computers & Internet | Subjects | Books
General | Software | Computers & Internet | Subjects | Books
Mathematics | Professional Science | Professional & Technical | Subjects | Books | Applied | Chaos & Systems | Geometry & Topology | Mathematical Analysis | Mathematical Physics | Number Systems | Pure Mathematics | Transformations | Trigonometry
All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books
Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Professional | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Learning Python (Learning)

Beginning Python: From Novice to Professional (Beginning: From Novice to Professional)

Python For Dummies (For Dummies (Computer/Tech))

Python Programming for the Absolute Beginner

Python Programming: An Introduction to Computer Science

ASIN: 0201748843

Book Description
Untitled

In patented Visual QuickStart Guide fashion, the book doesn't just tell you how to use Python to develop applications, it shows you, breaking Python into easy-to-digest, step-by-step tasks and providing example code. Python: Visual QuickStart Guide emphasizes the core language and libraries, which are the building blocks for programs. Author Chris Fehily starts with the basics - expressions, statements, numbers, strings - then moves on to lists, dictionaries, functions, and modules before wrapping things up with straightforward discussions of exceptions and classes. Some additional topics covered include:- Object-oriented programming- Working in multiple operating systems- Structuring large programs- Comparing Python to C, Perl, and Java- Handling errors gracefully.

Books:

Using R for Introductory Statistics

Visual Studio 2005 All-In-One Desk Reference For Dummies (For Dummies (Computer/Tech))

Waltzing With Bears: Managing Risk on Software Projects

Web Component Development with Zope 3

Web Design in a Nutshell: A Desktop Quick Reference (In a Nutshell (O'Reilly))

Web Standards Programmer's Reference : HTML, CSS, JavaScript, Perl, Python, and PHP

Wiley CPA Exam Review 2007 4-volume Set (Wiley Cpa Examination Review (4 Vol Set))

Wiley GAAP 2007: Interpretation and Application of Generally Accepted Accounting Principles (Wiley Gaap)

Wiley IFRS 2007: Interpretation and Application of International Financial Reporting Standards

A Professional Approach Series: Office 2000 Beginning Course Student Edition (Professional Approach Series)

Books Index
Books Home
Recommended Books

Making Your Move to One of America's Best Small Towns: How to Find a Great Little Place as Your Next
Gregor and the Code of Claw
Wiley: A Computerized Practice Set T/A Financia L Accounting
A Smart Girl's Guide to Starting Middle School: Everything You Need to Know About Juggling More Home
Death by Meeting: A Leadership Fable...About Solving the Most Painful Problem in Business
Do I Have to Give Up Me to Be Loved by You
Dinero En Marcha: LA Revolucion En Las Finanzas Internacionales a Partir De 1980
Contabilidad - Un Enfoque Para Usuarios
A World Without Walls: Freedom, Development, Free Trade and Global Governance
Battlestar Galactica: Redemption