The Definitive Guide to SQLite (Expert's Voice in Open Source)

The Definitive Guide to SQLite (Expert's Voice in Open Source), 9781430232254 (1430232250), Apress, 2010

The Definitive Guide to SQLite, Second Edition is your one-stop resource for integrating one of the most advanced and innovative open source database management systems into your development projects. SQLite is freely-available and comes with an amazingly small foot print of less than 300 kilobytes for a full-blown implementation. It’s perfect for mobile and other embedded implementations, including the iPhone and Android platforms. It’s also the default database distributed with PHP.

In The Definitive Guide to SQLite, Second Edition, Authors Grant Allen and Mike Owen provide complete coverage of SQLite’s powerful array of features. You’ll learn to use SQLite with PHP, C++, Java, and more. You’ll see how SQLite’s file-based approach can easily handle databases as large as two terabytes. You’ll also enjoy complete coverage of the API, and learn to embed SQLite within mobile applications on the iPhone, and on Android platforms.

Demonstrates SQLite’s use in iPhone and Android development.
Helps you integrate with popular languages such as PHP, C++, Java, and more.
Serves as an excellent tutorial, and ongoing reference.

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

Comments

Amazing Books

Hacking: The Beginners Guide to Master The Art of Hacking In No Time - Become a

CreateSpace Independent Publishing Platform, 2016

Do you want to learn ethical hacking/ penetration testing but not sure where to begin? Does the amount of information on the web make you feel overwhelmed and confused? Or maybe your looking to start a career as an ethical hacker and want to further your skills? How about step by step, methodical, literally foolproof approaches to be...

Nginx: From Beginner to Pro

Apress, 2016

Teaches you to start up Nginx and quickly take your expertise to a level where you can comfortably work with various aspects of the web server and make informed design decisions for your web farm. Nginx powers more than 40% of the top 1000 websites and is among the handful of web servers that can handle more than 10K simultaneous connections....

Euclidean Shortest Paths: Exact or Approximate Algorithms

Springer, 2011

This unique text/reference reviews algorithms for the exact or approximate solution of shortest-path problems, with a specific focus on a class of algorithms called rubberband algorithms. Discussing each concept and algorithm in depth, the book includes mathematical proofs for many of the given statements. Topics and features: provides...

Cutting-Edge Direct3D Programming: Everything You Need to Create Stunning 3D Applications with Direct3D

Coriolis Group Books, 1996

Explains Direct3D in clear, understandable language. Appeals to software developers interested in writing any type of 3D application for Windows 95, from hobbyist to professional. Emphasizes development of many types of software, not just games. Includes plenty of demos enabling readers of varying skill levels to create source code ideal for their...

For Men Of Understanding

Ta-Ha Publisher, 1999

It is stated as follows in the 164th verse of Surah al-Baqarah that one of the purposes of the Qur’an’s revelation is to think, "In the creation of the heavens and earth, and the alternation of the night and day, and the ships which sail the seas to people’s benefit, and the water which Allah sends down from the sky –...

Project Management for Business, Engineering, and Technology: Principles and Practice, 3rd Edition

Butterworth-Heinemann, 2008

Project Management for Business, Engineering and Technology, 3rd edition is a direct response to the ever-increasing need for better project management. First covering the essential background, from origins and philosophy to methodology, the main bulk of the book is dedicated to the concepts and techniques of practical...