book

Android™ Database Best Practices

by Adam Stroud

July 2016

Intermediate to advanced

328 pages

8h 30m

English

Addison-Wesley Professional

Read now

Unlock full access

About the Series Editor
Who Should Read This BookHow This Book Is OrganizedExample CodeConventions Used in This Book

History of DatabasesHierarchical ModelNetwork ModelThe Introduction of the Relational ModelThe Relational ModelRelationAttributeTuplesIntension/ExtensionSchemaProperties of a RelationRelationshipsReferential IntegrityRelational LanguagesRelational AlgebraUnion (A ∪ B)Intersection (A ∩ B)Difference (A - B)Cartesian Product (A × B)Selection (σpredicate (σ))Projection (Πa1, a2,…,an(A))JoinsRelational CalculusTuple Relational CalculusDomain Relational CalculusDatabase LanguagesALPHAQUELSEQUELSummary
Data Definition LanguageTablesCREATE TABLEALTER TABLEDROP TABLEIndexesCREATE INDEXDROP INDEXViewsCREATE VIEWDROP VIEWTriggersCREATE TRIGGERDROP TRIGGERData Manipulation LanguageINSERTVALUESSELECTDEFAULTUPDATEDELETEQueriesORDER BYJoinsSummary
SQLite CharacteristicsSQLite FeaturesForeign Key SupportFull Text SearchAtomic TransactionsJournal ModeWrite-Ahead-Log (WAL) ModeMultithread SupportWhat SQLite Does Not SupportLimited JOIN SupportRead-Only ViewsLimited ALTER TABLE SupportSQLite Data TypesStorage ClassesType AffinitySummary
Data Persistence in PhonesAndroid Database APISQLiteOpenHelperSQLiteOpenHelper ConstructorsSQLiteOpenHelper.onCreate()SQLiteOpenHelper.onUpgrade()SQLiteOpenHelper.onConfigure()SQLiteOpenHelper.onDowngrade()Putting It All TogetherSQLiteDatabaseStrategies for Upgrading DatabasesRebuilding the DatabaseManipulating the DatabaseCopying and Dropping TablesDatabase Access and the Main ThreadExploring Databases in AndroidAccessing a Database with adbIntroduction to adbPermissions and the Android File SystemFinding a Database Location with adbConnecting to a Database with sqlite3A Shorthand Approach to adb and sqlite3Using Third-Party Tools to Access Android DatabasesAccessing a Database with StethoSummary
Manipulating Data in AndroidInserting Rows into a TableUpdating Rows in a TableReplacing Rows in a TableDeleting Rows from a TableTransactionsUsing a TransactionTransactions and PerformanceRunning QueriesQuery Convenience MethodsRaw Query MethodsCursorsReading Cursor DataManaging the CursorCursorLoaderCreating a CursorLoaderStarting a CursorLoaderRestarting a CursorLoaderSummary
REST-Like APIs in AndroidContent URIsExposing Data with a Content ProviderImplementing a Content ProvideronCreate()insert()delete()getType()query()update()bulkInsert() and applyBatch()Content ResolverExposing a Remote Content Provider to External AppsProvider-Level PermissionIndividual Read/Write PermissionsURI Path PermissionsContent Provider PermissionsContent Provider ContractAllowing Access from an External AppImplementing a Content ProviderExtending android.content.ContentProviderinsert()delete()update()query()getType()When Should a Content Provider Be Used?Content Provider WeaknessesThe Need for Extra CodeUse of URIs and Cursors over ObjectsNo Convenient Place to Close the DatabaseContent Provider StrengthsAbstraction Layer for Structured DataWell Supported by Other Android ComponentsHandles Interprocess CommunicationSummary
Getting Data from the Database to the UIUsing a Cursor Loader to Handle ThreadingBinding Cursor Data to a UIListViewRecyclerViewCursors as ObserversregisterContentObserver(ContentObserver)registerDataSetObserver(DataSetObserver)unregisterContentObserver(ContentObserver)unregisterDataSetObserver(DataSetObserver)setNotificationUri(ContentResolver, Uri uri)Accessing a Content Provider from an ActivityActivity LayoutActivity Class DefinitionCreating the Cursor LoaderHandling Returned DataReacting to Changes in DataSummary
Sending IntentsExplicit IntentsImplicit IntentsStarting a Target ActivityReceiving Implicit IntentsBuilding an IntentActionsIntent.ACTION_SENDIntent.ACTION_SEND_MULTIPLEExtrasEXTRA_TEXTEXTRA_STREAMExtra Data TypesImplementing ParcelableWriting a ParcelCREATORReading a ParcelWhat Not to Add to an IntentShareActionProviderShare Action MenuSummary
REST and Web ServicesREST OverviewREST-like Web API StructureAccessing Remote Web APIsAccessing Web Services with Standard Android APIsCommunicating with the Web ServiceWorking with JSONAccessing Web Services with RetrofitAdding Retrofit to an Android ProjectUsing RetrofitAccessing Web Services with VolleyAdding Volley to an Android ProjectUsing VolleyPersisting Data to Enhance User ExperienceData Transfer and Battery ConsumptionData Transfer and User ExperienceStoring Web Service Response DataAndroid SyncAdapter FrameworkAccountAuthenticatorSyncAdapterManually Synchronizing Remote DataA Short Introduction to RxJavaAdding RxJava Support to RetrofitUsing RxJava to Perform the SyncSummary
Adding Data Binding to an Android ProjectData Binding LayoutsBinding an Activity to a LayoutUsing a Binding to Update a ViewReacting to Data ChangesUsing Data Binding to Replace Boilerplate CodeData Binding Expression LanguageSummary