Expanded

Your Database Is Your Friend

By Xavier Shay
Learn how to use your database to make your Ruby on Rails applications rock solid.
Get started
Course info
Rating
(68)
Level
Intermediate
Updated
Oct 3, 2013
Duration
1h 58m
Table of contents
Introduction
What is this? 2m Logistics 2m
Data Modelling
Introduction 1m The Unexpected Nil 1m Nil versus Empty String 2m ActiveRecord Validation 1m Not Nil Database Migration 2m The Unexpected Nil: Recap 1m The Missing Parent 1m ActiveRecord has_many options 3m Foreign Keys 2m Cascading Deletes 1m Schema.rb and Foreigner gem 2m The Missing Parent: Recap 1m Duplicate Data 2m Resolving Duplicates 3m Retrying Duplicate Exceptions 3m One-to-one Relationships 2m Duplicate Data: Recap 1m Polymorphic Associations 1m Converting to Separate Tables 2m Reactive Integrity Tests 2m Wrapping Up 2m
Concurrency
Introduction 1m A Development Environment for Concurrency 2m Concurrent Requests Primer 2m Concurrency and Unique Constraints 2m Concurrency and Foreign Keys 1m Thinking Concurrently 1m Optimistic Locking Introduction 2m Optimistic Locking with ActiveRecord 2m Counters 1m Optimistic Locking Recap 1m Pessimistic Locking 3m Pessimistic Locking Recap 1m Concurrency in the Real World 3m Combined Locking Example 6m Acts as List 4m Isolation Levels 6m Summary 2m
Reporting
What is reporting? 5m Introduction to Star Schemas 3m Creating a Star Schema 2m Using a Star Schema 2m Calendar Tables 4m Multi-valued Dimensions: Creating 4m Multi-valued Dimensions: Querying 3m Columnar Databases 2m Summary 2m
Appendix: MySQL
Introduction 1m Handling Invalid Data 2m InnoDB Locking 3m Deadlocks 2m Scan Locks 2m Summary 0m
Description
Course info
Rating
(68)
Level
Intermediate
Updated
Oct 3, 2013
Duration
1h 58m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Start a Premium 10-day free trial
Description

Databases have endured a lot of flak from the Rails camp, but they can do some pretty fantastic things. We can make our software better by spending some time to get to know them. Your database wants to be your friend.

About the author
Xavier Shay
About the author

Xavier has been on the startup scene for nearly a decade, and is prolific in the open-source community. He is on the RSpec core team and is Rails contributor, and has over 80 projects on Github.

More from the author
Testing Ruby Applications with RSpec
Beginner
1h 46m
Dec 30, 2015
Learn by Building Redis with Ruby
Intermediate
1h 45m
Apr 9, 2014

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT

Course info
Rating
(68)
Level
Intermediate
Updated
Oct 3, 2013
Duration
1h 58m
Pluralsight IQ
Know exactly where everyone on your team stands with assessments and analytics.
Try our full library including this course free for your whole team for 14-days.