Android SQLite Essentials

by Sunny Kumar Aditya, Vikash Kumar Karn

Develop Android applications with one of the most widely used database engines, SQLite About This Book
Develop database-driven Android applications and stay ahead of the curve
Explore the best techniques to use cursors and loaders to achieve optimum results
A step-by-step approach to use SQLite for building Android applications
Who This Book Is For

This is an ideal book for Android programmers who want to explore SQLite databases based on Android applications. The general competency level expected of the reader is prior knowledge of developing applications and basic knowledge of Android and SQL.

What You Will Learn
Design and develop an Android SQLite database architecture
Learn the basic principles of a database and include them in your applications
Get familiar with Android support classes with examples highlighting their uses
Create cutting-edge, database-driven applications in no time
Use SQLiteOpenHelper and SQLiteDatabase methods with Android views
Make use of ContentProvider to share your data
Use Loaders and SimpleCursorAdapter in your applications
In Detail

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.

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.

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.

110 pages, Paperback

First published January 1, 2014

Reviews

[Fabio Radin · Rating 5 out of 5]

In every Android (and not) application what makes the difference is the information the application could transfer or give. In other words, data. Databases are the heart of applications (both locally managed or server sided). Google, Yahoo, Facebook, manage a lot of information and data using databases to store, retrieve, query and search the particular information you need. In an Android device, SQLite is the engine feeding every database-centric application.

The book by Sunny Kumar Aditya and Vikash Kumar Karn gives a very detailed and exhaustive description of several techniques that could be used with Android SQLite databases. First two chapters are unproductive and give the reader all the basic knowledge to start working with SQLite in an Android application. Several best practices are explained as well, bringing the reader to the third chapter, where the Content Provider is described. This is the powerful engine enabling application to connect in an abstract way to a database, sharing information between applications and so on. In the end, the last chapter explains loaders and security issues.

The book is written in a simple and concise way. It is really simple to be read and the examples provided with the book are useful and well suited for the book. A must for every Android (and not) developer who wants to be introduced to the database world...

[Alain Couniot · Rating 5 out of 5]

This ebook, as most entries of PacktPub's Essentials series, is a fairly short one (127 p.). The authors have nevertheless managed to give a broad (and, in my humble opinion, fairly exhaustive) high-level coverage of how to make the best use of the SQLite database on the Android platform.

Specific aspects of data sharing and application development on Android are duly addressed. Source code examples, practical hints and even "best practices" are provided.

Highly recommended for Android developers!

[Bill Jones · Rating 5 out of 5]

Android SQLite Essentials

Absolutely love this book, I was saving data from my phone through ssh and winscp which was just easier than using scp. Now onto the book, chapter 1 was pretty aggressive as another reviewer mentioned and I'd have to agree. I know the book is about Android but the iOS also uses sqlite so it's worth noting, this book is just focused on the latter. The book was organized rather well and I loved the chapter on "Thread Safely."

You get the whole deal with this book from how to interact with your data and getting setup for success with a hands on approach that in my opinion is the total package. If you want to get started with making more robust applications than this is a no brainier.

More details on the book here: http://bit.ly/1ohtDqr

[Mohsen · Rating 5 out of 5]

This book really helped me in best understanding how to use SQLite in Android and contains lots of useful aspects and incredibly informative content that no one knows about SQLite.