Learn How to Design a Database Schema with SQLite


show more Designing a database schema provides you with in-depth training on Developer. Taught by Bill Weinman as part of the iOS SDK and SQLite: Building Data-Driven Apps (2013) show less
please wait ...

Designing a database schema

Because we're using a database for this application, we must start with a database schema. A schema is simply a description of the structure of the database that contains descriptions of tables, columns, indexes, and other associated constructs that are part of the database. There are tools available for defining a schema for a database. But this database is simple, and we'll be writing it in SQL in a text editor, and creating the database using the SQLite 3 Command Line client. So, in your Chapter 2 folder in exercise files, you'll find a file called bwrss.sql, and I'm going to open that in my text editor.

I'm using TextWrangler which is free, and it is a great text editor. You may use whatever text editor you like just make sure it is not a word processor. This is a very simple database. It has two tables, one for Feeds and one for Items. You'll notice here, at the top, we do DROP TABLE IF EXISTS feed, and DROP TABLE IF EXISTS item. This is SQL, and if you need a premier o...

Designing a database schema
Video duration: 8m 7s 3h 45m Intermediate

Viewers:

Designing a database schema provides you with in-depth training on Developer. Taught by Bill Weinman as part of the iOS SDK and SQLite: Building Data-Driven Apps (2013)

Subject:
Developer
Software:
iOS
Author:
please wait ...