Android SQLite essentials : develop android applications with one of the most widely used database engines, SQLite /: develop android applications with one of the most widely used database engines, SQLite. (2014)

• Record Type: Book
• Further Information: Note: Sunny Kumar Aditya, Vikash Kumar Karn ; cover image by Pratyush Mohanta.
• Authors: Aditya, Sunny Kumar; Karn, Vikash Kumar
• Other Names: Mohanta, Pratyush cover designer.
• Contents: Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Enter SQLite; Why SQLite?; The SQLite architecture; The SQLite interface; The SQL compiler; The virtual machine; The SQLite backend; A quick review of database fundamentals; What is an SQLite statement?; The SQLite syntax; Datatypes in SQLite; The storage classes; The Boolean datatype; The Date and Time datatype; SQLite in Android; SQLite version; Database packages; APIs; The SQLiteOpenHelper class; The SQLiteDatabase class; ContentValues; Cursor; Summary. Chapter 2: Connecting the DotsBuilding blocks; Database handler and queries; Building the Create query; Building the Insert query; Building the Delete query; Building the Update query; Connecting the UI and database; Summary; Chapter 3: Sharing is Caring; What is a content provider?; Using existing content providers; What is a content resolver?; Creating a content provider; Understanding content URIs; Declaring our contract class; Creating UriMatcher definitions; Implementing the core methods; Initializing the provider through the onCreate() method; Querying records through the query() method. Adding records through the insert() methodUpdating records through the update() method; Deleting records through the delete() method; Getting the return type of the data through the getType() method; Adding a provider to a manifest; Using a content provider; Summary; Chapter 4: Thread Carefully; Loading data with CursorLoader; Loaders; Loader API''s summary; Using CursorLoader; Data security; ContentProvider and permissions; Encrypting critical data; General tips and libraries; Upgrading a database; Database minus SQL statements; Shipping with a prepopulated database; Summary; Index.
• Publisher Details: Birmingham, England : Packt Publishing Ltd
• Publication Date: 2014
• Copyright Date: 2014
• Extent: 1 online resource (110 pages), illustrations
• Subjects: 005.1; COMPUTERS -- Desktop Applications -- Databases; Application software -- Development; SQL (Computer program language) -- Examinations, questions, etc; SQL (Computer program language); COMPUTERS -- Programming -- Open Source; COMPUTERS -- Software Development & Engineering -- General; COMPUTERS -- Software Development & Engineering -- Tools; Application software -- Development; SQL (Computer program language); COMPUTERS -- Operating Systems -- General; Electronic books; Examinations
• Languages: English
• ISBNs: 9781783282968; 1783282967
• Related ISBNs: 1783282959; 9781783282951
• Notes: Note: Online resource; title from PDF title page (ebrary, viewed September 4, 2014).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.