"The Definitive Guide to SQLite" is the perfect book about SQLite. It covers everything needed to start working with SQLite including installation, using the SQLite shell, and programming with SQLite using six different language extensions. -- Joe Topjian, Adminspotting

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.

"The Definitive Guide to SQLite" is the first book to devote complete coverage to the latest version of this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide." Youll learn about SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl. The book thoroughly covers SQLite internals to help you take full advantage of its features while minimally impacting resource consumption. Author Mike Owens is the original creator of Pysqlite, the popular Python extension for SQLite.

Andy Pollitt is as close to a Hollywood A-lister as the climbing world will ever get. He had the looks, and he starred in all the big roles in the 1980s and 1990s - Tremadog, Pen Trwyn, the big Gogarth climbs, Raven Tor and the cult Australian adventures. Alongside co-stars like Jerry Moffatt, John Redhead and Malcolm 'HB' Matheson, he brought us sexy climbing - gone were the beards, the woolly socks and the fibre pile. Andy was all skin-tight pink Lycra, vests and brooding looks. For those watching, Andy Pollitt had it all. But Punk in the Gym gives us the whole truth. The self-doubt, the depression, the drinking, the fags, the womanising, the injuries, the loss of a father and the trouble that brings, and a need for something - for recognition, a release for the pain, and, for Andy, more drinking, more tears, bigger run-outs.With nothing held back, Andy tells his roller-coaster story from the UK to Australia, exactly as it happened. Exposing his fragile ego and leaving us to laugh, cry, marvel and judge, this is a sports autobiography like no other. The legendary routes are all here - The Bells, The Bells!, Skinhead Moonstomp, The Hollow Man, Boot Boys, The Whore of Babylon and Knockin' on Heaven's Door. And the route that broke him and robbed the climbing world of its Hollywood star - Punks in the Gym.

This is the first book to devote complete coverage to the most recent release of the popular embedded open source database SQLite. The book acts as both an ideal tutorial and reference guide. It offers experienced database developers a thorough overview of its capabilities and APIs, yet is mindful of newcomers who may be making their first foray into the database environment with SQLite. Readers are presented with introductions to the SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl.

Outside of the world of enterprise computing, there is one database that enables a huge range of software and hardware to flex relational database capabilities, without the baggage and cost of traditional database management systems. That database is SQLite-an embeddable database with an amazingly small footprint, yet able to handle databases of enormous size. SQLite comes equipped with an array of powerful features available through a host of programming and development environments. It is supported by languages such as C, Java, Perl, PHP, Python, Ruby, TCL, and more. The Definitive Guide to SQLite, Second Edition is devoted to complete coverage of the latest version of this powerful database. It offers a thorough overview of SQLite's capabilities and APIs. The book also uses SQLite as the basis for helping newcomers make their first foray into database development. In only a short time you can be writing programs as diverse as a server-side browser plug-in or the next great iPhone or Android application! Learn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. Get solid coverage of SQLite internals. Explore developing iOS (iPhone) and Android applications with SQLite. SQLite is the solution chosen for thousands of products around the world, from mobile phones and GPS devices to set-top boxes and web browsers. You almost certainly use SQLite every day without even realizing it!

How ordinary urban objects influence our behavior, exacerbate inequality, and encourage social change Assumptions about human behavior lie hidden in plain sight all around us, programmed into the design and regulation of the material objects we encounter on a daily basis. In the Midst of Things takes an in-depth look at the social lives of five objects commonly found in the public spaces of New York City and its suburbs, revealing how our interactions with such material things are our primary point of contact with the social, political, and economic forces that shape city life. Drawing on groundbreaking fieldwork and a wealth of original interviews, Mike Owen Benediktsson shows how we are in the midst of things whose profound social role often goes overlooked. A newly built lawn on the Brooklyn waterfront reflects an increasingly common trade-off between the marketplace and the public good. A cement wall on a New Jersey highway speaks to the demise of the postwar American dream. A metal folding chair on a patch of asphalt in Queens exposes the political obstacles to making the city livable. A subway door expresses the simmering conflict between the city and the desires of riders, while a newsstand bears witness to our increasingly impoverished streetscapes. In the Midst of Things demonstrates how the material realm is one of immediacy, control, inequality, and unpredictability, and how these factors frustrate the ability of designers, planners, and regulators to shape human behavior.