This brief book is an introduction to SQLite for both iOS and Android developers. The book includes an optional introduction to SQL, a discussion of when to use SQLite, and chapters devoted to using SQLite with the most likely programming languages and then goes through adding a simple database to an Android or iOS app and finally a chapter on managing the apps life cycle.
What You Will Learn:
The basics of SQLite
The SQL you need to use SQLite effectively
How to integrate a database into your mobile app.
How to maintain the app
Who this book is for:
This book is for Android or iOS developers who wish to use a lightweight but flexible database for their applications. It mobile development experience but does not assume anything but very basic database knowledge.
1.Getting Up to Speed with Databases and SQLite [6]
2.Understanding What SQLite Is... [based on the SQLite.org description] [14]
a.Software Library
b.Self-contained
c.Serverless
d.Zero-configuration
e.Transactional
f.SQL Database Engine
g.Where to Get More Information (sqlite.org)
h.When to Use SQLite
i.Embedded devices and Internet of Things
ii.Application files
iii.Websites
iv.Command line and data analysis
v.Cache from transactional and historical databases