"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!