Using SQLite: Small. Fast. Reliable. Choose Any Three.

"O'Reilly Media, Inc."
5
Free sample

Application developers, take note: databases aren't just for the IS group any more. You can build database-backed applications for the desktop, Web, embedded systems, or operating systems without linking to heavy-duty client-server databases such as Oracle and MySQL. This book shows you how to use SQLite, a small and lightweight relational database engine that you can build directly into your application.

With SQLite, you'll discover how to develop a database-backed application that remains manageable in size and complexity. This book guides you every step of the way. You'll get a crash course in data modeling, become familiar with SQLite's dialect of the SQL database language, and much more.

  • Learn how to maintain localized storage in a single file that requires no configuration
  • Build your own SQLite library or use a precompiled distribution in your application
  • Get a primer on SQL, and learn how to use several language functions and extensions
  • Work with SQLite using a scripting language or a C-based language such as C# or Objective-C
  • Understand the basics of database design, and learn how to transfer what you already know to SQLite
  • Take advantage of virtual tables and modules

"Complex SQL concepts explained clearly."

--D. Richard Hipp, creator of SQLite

Read more

About the author

Jay Kreibich is a professional software engineer who has always beeninterested in how people process and understand information. He iscurrent working for Volition, Inc., a software studio that specializesin open-world video games. He lives on a small farm in central Illinois with his wife and two sons, where he enjoys reading, photography, and tinkering.

Read more
4.8
5 total
Loading...

Additional Information

Publisher
"O'Reilly Media, Inc."
Read more
Published on
Aug 10, 2010
Read more
Pages
530
Read more
ISBN
9781449399641
Read more
Language
English
Read more
Genres
Computers / Desktop Applications / Databases
Computers / Desktop Applications / General
Computers / Programming / Open Source
Computers / Programming Languages / SQL
Read more
Content Protection
This content is DRM free.
Read more
Read Aloud
Available on Android devices
Read more
Eligible for Family Library

Reading information

Smartphones and Tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and Computers

You can read books purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like the Sony eReader or Barnes & Noble Nook, you'll need to download a file and transfer it to your device. Please follow the detailed Help center instructions to transfer the files to supported eReaders.
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 Introducing SQLite Getting Started SQL for SQLite Advanced SQL for SQLite SQLite Design and Concepts The Core C API The Extension C API Language Extensions iOS Development with SQLite Android Development with SQLite SQLite Internals and New Features
©2018 GoogleSite Terms of ServicePrivacyDevelopersArtistsAbout Google|Location: United StatesLanguage: English (United States)
By purchasing this item, you are transacting with Google Payments and agreeing to the Google Payments Terms of Service and Privacy Notice.