The Definitive Guide to SQLite [NOOK Book]

Overview



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 ...

See more details below
The Definitive Guide to SQLite

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$25.49
BN.com price
(Save 42%)$43.99 List Price

Overview



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!





What you’ll learn


  • Deploy SQLite as the database engine for iPhone and Android applications.


  • Interact with SQLite from Java, C++, PHP, and other key languages.


  • Create robust database designs, taking advantage of support for primary and foreign key constraints.


  • Embed zero-maintenance databases directly within applications that you write.


  • Improve performance through a good understanding of SQLite internals.


  • Exploit features such as the shared cache, the SQL Logic Test Suite, the Unlock and Notify APIs, and query plan improvements.




Who this book is for


The Definitive Guide to SQLite 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.



Table of Contents


  1. Introducing SQLite


  2. Getting Started


  3. SQL for SQLite


  4. Advanced SQL for SQLite


  5. SQLite Design and Concepts


  6. The Core C API


  7. The Extension C API


  8. Language Extensions


  9. iOS Development with SQLite


  10. Android Development with SQLite


  11. SQLite Internals and New Features




Read More Show Less

Product Details

  • ISBN-13: 9781430232261
  • Publisher: Apress
  • Publication date: 11/4/2010
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 2
  • Pages: 368
  • File size: 3 MB

Meet the Author

Grant Allen has worked in the IT field for over 20 years, as a CTO, enterprise architect, and database administrator.� Grant's roles have covered private enterprise, academia and the government sector around the world, specialising in global-scale systems design, development, and performance.� He is a frequent speaker at industry and academic conferences, on topics ranging from data mining to compliance, and technologies such as databases (DB2, Oracle, SQL Server, MySQL), content management, collaboration, disruptive innovation, and mobile ecosystems like Android.� His first Android application was a task list to remind him to finish all his other unfinished Android projects.� Grant works for Google, and in his spare time is completing a Ph.D on building innovative high-technology environments.� Grant is the author of Beginning DB2, and lead author of Oracle SQL Recipes and The Definitive Guide to SQLite.
Mike Owens is the�information technology�director for a major real estate firm in Fort Worth, Texas, where he's charged with the development and management of the company's core systems. His prior experience includes time spent at Oak Ridge National Laboratory as a process design engineer, and at Nova Information Systems as a C++ programmer. He is the original creator of Pysqlite, the Python extension for SQLite. Mike earned his bachelor's degree in chemical engineering from the University of Tennessee in Knoxville.
Read More Show Less

Table of Contents

Ch. 1 Introducing SQLite 1
Ch. 2 Getting started 17
Ch. 3 The relational model 47
Ch. 4 SQL 73
Ch. 5 Design and concepts 171
Ch. 6 The core C API 205
Ch. 7 The extension C API 255
Ch. 8 Language extensions 301
Ch. 9 SQLite internals 341
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted July 24, 2011

    No text was provided for this review.

Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)