Join Bill Weinman for an in-depth discussion in this video Understanding SQLite in iOS, part of iOS SDK and SQLite: Building Data-Driven Apps.
- SQLite is a fully featured…relational database management system.…It's small.…It's fast.…It's light weight,…and it's perfectly suited for mobile applications.…The SQLite database management system…lives entirely in a driver.…This means that there's no server and no client.…You access the database directly.…The database itself is fully contained in one file.…This makes it very convenient…to use in a mobile environment.…To say that iOS support SQLite natively,…is to that the driver is built in.…
The interface of the driver is written in C,…so it's not object oriented…and it's not an Objective-C interface.…To make it easier to use…we will build a native object oriented interface…for SQLite in Objective C.…This kind of interface is sometimes called a wrapper…as it wraps one interface around another.…It's designed to be convenient…and easy for out development purposes.…It's general purpose so you can use it…in your future projects…and you'll have the source code so you can modify it…and expand it to suit your needs.…
I could have used Swift to build this interface…
- Building a testbed
- Creating an Objective-C interface for SQLite
- Creating a CRUD interface
- Designing the database schema
- Creating the main table view
- Creating the items table view
- Adding new feeds
- Parsing feeds with NSXML Parser
- Viewing webpages
- Preparing icons and toolbar images
- Adding a preferences pane
- Including pull-to-refresh and other features
Skill Level Intermediate
Android SDK: Local Data Storagewith David Gassner3h 41m Intermediate
1. Building a Testbed
2. Building the Database Library
3. Creating the Main Table View
Populating the table view3m 30s
4. Creating the Items Table View
5. Adding New Feeds
6. Viewing Webpages
7. Preparing the Visual Assets
8. Adding a Preferences Pane
9. Adding Features
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.