Book Image

Android SQLite Essentials

By : Sunny Kumar Aditya, Vikash Kumar Karn
Book Image

Android SQLite Essentials

By: Sunny Kumar Aditya, Vikash Kumar Karn

Overview of this book

<p>SQLite is an open source relational database management system. Android uses the SQLite database to store and retrieve data persistently. The driving force behind the platform is the database, enabling a myriad of choices for developers making cutting-edge applications.</p> <p>Android SQLite Essentials focuses on the core concepts behind building database-driven applications. This book covers the basic and advanced topics with equivalent simplicity and detail, in order to enable readers to quickly grasp and implement the concepts to build an application database.</p> <p>This book takes a hands-on, example-based approach to help readers understand the core topics of SQLite and Android database-driven applications. This book focuses on providing you with latent as well as widespread knowledge about practices and approaches towards development in an easily understandable manner.</p>

Related Content you might be interested in

Current Title:

Small book image
Android SQLite Essentials
Sunny Kumar Aditya | Vikash Kumar Karn
Aug, 2014 | 110 pages
No titles found
Table of Contents (11 chapters)
Android SQLite Essentials
Android SQLite Essentials
Credits
Credits
About the Authors
About the Authors
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Enter SQLite
Enter SQLite
Why SQLite?
The SQLite architecture
A quick review of database fundamentals
SQLite in Android
Summary
2
Connecting the Dots
Connecting the Dots
Building blocks
A database handler and queries
Connecting the UI and database
Summary
3
Sharing is Caring
Sharing is Caring
What is a content provider?
Creating a content provider
Implementing the core methods
Using a content provider
Summary
4
Thread Carefully
Thread Carefully
Loading data with CursorLoader
Data security
General tips and libraries
Summary
Index
Index

Chapter 2. Connecting the Dots

 

"You don't understand anything until you learn it more than one way."

 
 ---Marvin Minsky

In the previous chapter, we learned the two important Android classes and their corresponding methods in order to work with an SQLite database:

  • The SQLiteOpenHelper class

  • The SQLiteDatabase class

We also saw code snippets explaining their implementation. Now, we are ready to use all these concepts in an Android application. We will be leveraging what we learned in the previous chapter to make a functional application. We will further look into the SQL statements to insert, query, and delete data from a database.

In this chapter, we will be building and running an Android application on an Android emulator. We will also be building our own full-fledged contacts database. We will encounter Android UI components, such as Buttons and ListView, while progressing through this chapter. In case a revisit of UI components in Android is required, please visit the link http://developer...

Previous Section
End of Section 1
Next Section