SQLite

Overview

We spent today working on schemas and commands in SQLite. One thing that I've realized as I've been working with SQLite is the importance of workflow. People have different ways in which they plan out databases, but I like to first imagine the UI view of my application and then figure out the schema that way. All relationships between tables in databases can be summed up as three different types.

Using SQlite in Ruby

SQlite is a gem in Ruby. You need to require it at the beginning of it as well. THen you need to open the database such as line 8. When you want to run the database and query it, you need to use .execute("SQLITE COMMANDS HERE")