Introducing SQLite for Mobile Developers

1. Getting Up to Speed with Databases and SQLite [6]2. Understanding What SQLite Is... [based on the SQLite.org description] [14]a. Software Libraryb. Self-containedc. Serverlessd. Zero-configuratione. Transactionalf. SQL Database Engineg. Where to Get More Information (sqlite.org)h. When to Use SQLitei. Embedded devices and Internet of Thingsii. Application filesiii. Websitesiv. Command line and data analysisv. Cache from transactional and historical databasesvi. ... more3. Working with the relationship model and SQLite [8]a. What's not in SQLitei. triggersii. viewsiii. altering tables and modifying columnsb. What's different in SQLitei. Typing -- dynamic and weakii. Command line accessc. What's new and beyond in SQLite"div>i. multiple threadsii. write-ahead logging (WAL) and file implicationsiii. full text search (FTS4)iv. Indexed Database API -- Indexed DB (formerly WebSimpleDB)4. Using SQLite basics - storing and retrieving data [8]a. tablesb. rowsc. columnsd. how schemas are implementede. SELECT statements5. Using SQLite features - What you can do with SELECT statements [6]a. Grouping Datab. Sorting Datac. Grouping and Sorting Data together6. Using SQLite with PHP [6]a. Creating a tableb. Adding a rowc. Finding a rowd. Finding several rowse. Deleting a row7. Using SQLite with Java (Android) [6]a. Creating a tableb. Adding a rowc. Finding a rowd. Finding several rowse. Deleting a row8. Using SQLite with Swift (iOS/Mac) [6]a. Creating a tableb. Adding a rowc. Finding a rowd. Finding several rowse. Deleting a row9. Using SQLite with Objective-C (iOS/Mac) [6]a. Creating a tableb. Adding a rowc. Finding a rowd. Finding several rowse. Deleting a row10. Exploring the simple database (used in chapters 10-12 [6]a. Database overviewi. Events tableii. Places tableb. Adding a placec. Adding an eventd. Setting a place for an evente. Adding an event for a placef. Adding a place for an event11. Using the simple database with a website (database example code included) [6]12. Adding the simple database to an Android app (using android.database.sqlite) [6]13. Adding the simple database to an iOS app (using Core Data) [6]14. Considering performance issues [6]a. This chapter is mostly text, best practices for mobile devices, and tips. It may be removed.15. Managing the SQLite life cyle [6]a. Creating a databaseb. Deleting a databasec. Checking for a database