{"product_id":"9781430232261","title":"The Definitive Guide to SQLite","description":"\u003cp\u003eOutside 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. \u003c\/p\u003e\u003cp\u003e\u003cem\u003eThe Definitive Guide to SQLite, Second Edition\u003c\/em\u003e 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! \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eLearn about SQLite extensions for C, Java, Perl, PHP, Python, Ruby, and Tcl. \u003c\/li\u003e\n\u003cli\u003eGet solid coverage of SQLite internals. \u003c\/li\u003e\n\u003cli\u003eExplore developing iOS (iPhone) and Android applications with SQLite. \u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eSQLite 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!  \u003c\/p\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eDeploy SQLite as the database engine for iPhone and Android applications. \u003c\/li\u003e   \u003cli\u003eInteract with SQLite from Java, C++, PHP, and other key languages. \u003c\/li\u003e   \u003cli\u003eCreate robust database designs, taking advantage of support for primary and foreign key constraints. \u003c\/li\u003e   \u003cli\u003eEmbed zero-maintenance databases directly within applications that you write. \u003c\/li\u003e   \u003cli\u003eImprove performance through a good understanding of SQLite internals. \u003c\/li\u003e   \u003cli\u003eExploit features such as the shared cache, the SQL Logic Test Suite, the Unlock and Notify APIs, and query plan improvements. \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eThe Definitive Guide to SQLite\u003c\/em\u003e is for developers needing a zero-maintenance database solution to deploy as an embedded component within their product. The book is especially useful for mobile developers delivering applications to run on the iPhone, or on the Android platform. PHP developers will also find the book useful if they are using the default database delivered as part of a PHP installation.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eIntroducing SQLite \u003c\/li\u003e   \u003cli\u003eGetting Started \u003c\/li\u003e   \u003cli\u003eSQL for SQLite \u003c\/li\u003e   \u003cli\u003eAdvanced SQL for SQLite \u003c\/li\u003e   \u003cli\u003eSQLite Design and Concepts \u003c\/li\u003e   \u003cli\u003eThe Core C API \u003c\/li\u003e   \u003cli\u003eThe Extension C API \u003c\/li\u003e   \u003cli\u003eLanguage Extensions \u003c\/li\u003e   \u003cli\u003eiOS Development with SQLite \u003c\/li\u003e   \u003cli\u003eAndroid Development with SQLite \u003c\/li\u003e   \u003cli\u003eSQLite Internals and New Features \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47107162931440,"sku":"9781430232261","price":43.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430232261_p0.jpg?v=1763750263","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430232261","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}