This book presents the architecture, functionalities, and data types supported by SQLite. It demonstrates how to use SQLite Command-Line shell. Then, the book presents the approach to use SQLite in Mobile Apps. Later, it presents developing Android, BlackBerry and iOS Applications using SQLite to store and retrieve data with step-by-step details as well as list of source code. In addition, it presents how to use Android ADB Shell to open SQLite Database created for the application. Similarly, it shows the database contents from BlackBerry SD Card and iOS database file. Chapter 1 - Introduces SQLite and describes the chapters. Chapter 2 - SQLite Overview - Architecture, functionality, data types, Data Definition Language (DDL) statements, DML (Data Manipulation Language) statements and function call process flow and mobile devices. Chapter 3 - Command line shell - This chapter describes how to use SQLite Command line shell. Chapter 4 - Set up for use in Mobile Apps - This chapter presents a process flow. It presents the database structure, DDL and DML executed in the database. It also presents the sample Part Maintenance application user interface to be used repeated in Android, BlackBerry, iOS and Web App. Chapter 5 - Use in Android Apps - This chapter narrates the approach, implementation, code listing, screenshots, accessing SQLite Database through launching ADB shell and opening SQLite command line. Chapter 6 - Use in BlackBerry App - This chapter narrates the approach, implementation, code listing, screenshots, accessing SQLite Database through opening SQLite database in command line. Chapter 7 - Use in iOS App - This chapter narrates the approach, implementation, code listing, screenshots, accessing SQLite Database through opening SQLite database in command line.


Sribatsa Das holds a Bachelors and Masters in Computer Science. He holds an MBA from New York University’s Leonard N. Stern School of Business in Finance and Strategy. Sribatsa’s passion is technology. He strives at bringing technological innovative products to life every day leveraging his long technology career and finance education. Sribatsa started as a DBA and application developer in his early career. After 20+ years long stint in IT and consulting, he embarked upon entrepreneurship. He launched Business Compass(R) LLC mobile app start-up venture in 2008. This start-up has launched 200+ mobile apps. MBA Sidekick, Mobile Statistics Professor(R) and Altman Z-Score+ are his key innovations. MBA Sidekick offers a full array of analytical tools to MBA students and professionals. MBA Statistics Professor provides tools to carry out college and MBA level statistical analysis. Altman Z-Score+ analyzes credit risk of companies worldwide including bond rating equivalent and up to 10 years of default probability. This product is available on leading financial data terminal via APPS ALTMAN command. Business Compass LLC’s web sites are http: //businesscompassllc.com and http: //altmanzscoreplus.com. More details about this book including templates can be found at http: //sqliteformobileapps.com.