• [] Explain persistence, the need for using SQL, and difference between SQLite3 and SQL
  • Install the Sqlite extension for VSCode. It's a good resource for navigating through your DB right within VSCode.
  • You can also explore provided data through DB Browser for SQLite
• [] Perform CRUD actions on a single table
• [] Explore how to interact with a sqlite3 database with a ruby file
• [] Perform CRUD actions using ActiveRecord

• RailsGuides on ActiveRecord
• RailsGuides on ActiveRecord Migrations
• RailsGuides for ActiveRecord Query Interface
• Rails documentation (section on ActiveRecord)
• Sqlite tutorial
• Sqlite Cheatsheet
• VSCode Sqlite Extension

...

...

...

...

...

• Create Dogs model and table
• open up ./bin/console and do create a couple of dogs.

1. Create a computers table with the following columns:

• brand (string)
• model (string)
• screen_size (float)
• model_year (integer)
• asleep (boolean)
• last_backed_up_at (datetime)

2. In lib/computer.rb, create a Computer class that inherits from ActiveRecord::Base

3. In lib/exercises.rb fill in the first_computer and second_computer methods so that they both return computers with brand, model, screen_size and model_year properties assigned.

...

...

...

...

...

...

For this, let's open up ./bin/console and attempt the following:

1. Define a back_up method within the computer class that updates the last_backed_up_at attribute of the computer to the current date and time.

2. Define a sleep method within the computer class that updates the asleep attribute of the computer to true.

3. Define a wake_up method within the computer class that updates the asleep attribute of the computer to false.

4. Define a backed_up method within the computer class that returns all of the computers that have been backed_up.

...

...

...