Level-up Your ActiveRecord Skills: Learn SQL!
summary
Claims that learning SQL fixes performance and reporting problems by moving work into the database, with concrete examples: a Ruby dashboard that would otherwise pull millions of rows is replaced by a single SQL query; exploratory queries using group by and joins produce counts (4,000 books, 500 authors) and find authors with five or more topic books; use Explain Analyze to spot costly sequential scans and add indexes or use migrations with raw SQL (e.g. concurrent index) to make it actually fast.
AI-written summary · about
chapters (31)
- 0:00Introduction
- 1:06Why SQL
- 3:00SQL vs Sequel
- 3:43Overview
- 3:57About me
- 5:01Before ORM
- 9:38ActiveRecord
- 10:01SQL is everywhere
- 10:54Why learn SQL
- 11:47Chris Nelson
- 12:16Richard Hipp
- 13:14Examples
- 13:25Authors and Books
- 14:15New Project
- 14:28Existing Project
- 15:01Querying the Database
- 15:48Query Results
- 17:10Minimum
- 18:37Results
- 19:40Join Data Together
- 20:17Join Explanation
- 20:48SQL Join Criteria
- 24:32SQL Join Data Types
- 25:14Explain
- 26:22Explain Analyze
- 27:09Sequential Scan
- 31:01Middle Bobby Tables
- 31:31Where to go from here
- 32:26Remote pairing
- 33:51Summary
- 34:39Questions
related talks
01h 52mBuild High Performance Active Record Apps
01h 52mBuild High Performance Active Record Apps
25mPowerful Data: Making Rails Apps Faster with Aggregation
26mLess Code, Faster Apps- Rediscovering SQL for Modern ORM Developers
20mLevel up your SQL skills as a developer
31m"Optimizing SQL Queries"
14mDatabase Performance at Scale for RoR Applications
33mBetter Rails by Knowing Better Database by Ding ding Ye