1. Introduction to Databases
Introduction to working with data through databases
Installing Postgres
Before you start adding databases to your Sinatra application, you’ll need to get Postgres up and running on your computer. Below is a quick guide to getting started
If you’re on Mac OSX
Download https://postgresapp.com, copy to Applications, launch. Done
If you’re on Windows
You will need to install Postgres on your computer. I recommend using the BigSQL installer https://www.openscg.com/bigsql/postgresql/installers.jsp/
Databases - Series
This series guides you through working with databases, from setting up and installing your database, storing and retrieving data and deploying to heroku
-
-
2. Installing Postgres
Getting started - installing your database engine
-
3. Adding Postgres and ActiveRecord
Getting started - adding dependencies to your project
-
4. Set up a project Rake file
Getting started - adding activerecord rake commands
-
5. Making Migrations
Migration files are small Ruby scripts that make changes to your database
-
6. Database Schemas
Schemas define the structure of your database table and allow ActiveRecord to structure requests and changes for data
-
7. Connecting Tables to ActiveRecord models
Use Models to map a database table onto native ruby objects.
-
8. CRUD Basics
Linking Models to Routes. Making a CRUD API
-
9. Adding Associations
Linking Models to Models - Adding Associations
-
10. Deploying with a Database
How to deploy your project to Heroku and add a database
-
11. Validating Models
How to check the information you're adding to the database
-
12. Seeding Data
How to create initial data with a Seed File