Join Bill Weinman for an in-depth discussion in this video Designing a database schema, part of iOS SDK and SQLite: Building Data-Driven Apps.
- The next step in building our database is…to design the database schema.…This is done in SQL.…Here I've opened a working copy of bwrss.sql…from the SQL folder of the Exercise Files.…I'm using TextWrangler for this.…You may use any plain text editor you like.…I do strongly recommend TextWrangler for this purpose…or its bigger brother BBEdit.…TextWrangler is free on the OS X app store…and it's very powerful editor.…So this SQL file, it's like a SQL script…where we can drop tables if they already exist,…create each of the tables in this database,…and then insert some data into the tables.…
So our database consists of three tables.…The feed table for RSS feeds.…All of these have id INTEGER PRIMARY KEY…so that they can be used with our cred tools.…This group_id is for feedgroups.…I'm not actually using that in this version of the app.…I'm working on a newer version of the app…probably for next year…that merely not have some new features…that might use that.…There's a url, a title, a description,…an icon, I'm also not using that,…
- 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.