Android Programming: The Big Nerd Ranch Guide, Third Edition
by Bill Phillips, Chris Stewart, Kristin Marsicano
For the More Curious: More Databases
For the sake of space and simplicity, we do not go into all the details you might see in a professional app’s application database here. There is a reason people resort to tools like ORMs: This stuff can get complicated.
For a more substantial application, you will want to look into adding the following to your database and your description of it:
-
Data types on columns. Technically, SQLite does not have typed columns, so you can get by without them. Giving SQLite hints is kinder, though.
-
Indexes. Queries against columns with appropriate indexes are much faster than columns without them.
-
Foreign keys. Your database here only has one table, but associated data would need foreign key constraints, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access