01 Introduction to this course (34.52 MB)
02 Introduction to SQLite (202.12 MB)
03 SQLite is safe (114.36 MB)
04 It's just a file (122.72 MB)
05 Running SQLite locally (68.14 MB)
06 Good uses for SQLite (205.81 MB)
07 SQLite's limitations (121.35 MB)
08 The documentation (11.22 MB)
09 SQLite's structure (26.68 MB)
10 SQLite's file format (20 MB)
11 Dot commands (27.55 MB)
12 Pragmas (23.78 MB)
13 Virtual tables (14.96 MB)
14 Flexible types (27.67 MB)
15 Types (45.09 MB)
16 Strict types (19.46 MB)
17 Dates (30.04 MB)
18 Booleans (2.56 MB)
19 Floating point (33.47 MB)
20 Rowid tables (41.85 MB)
21 Auto increments (28.51 MB)
22 Without rowid (16.66 MB)
23 Generated columns (30.86 MB)
24 Locking (32.19 MB)
25 Rollback mode (25.51 MB)
26 WAL mode (28.61 MB)
27 WAL vs Journal benchmarks (23.12 MB)
28 Busy timeout (14.16 MB)
29 Transaction modes (17.78 MB)
30 Vacuum (29.04 MB)
31 Analyze & Optimize (17.45 MB)
32 Suggested pragmas (37.14 MB)
33 Faster inserts (10.29 MB)
34 Introduction to indexes (40.03 MB)
35 B+ trees (26.46 MB)
36 Primary, secondary, and clustered indexes (57.03 MB)
37 Without rowid tables (14.36 MB)
38 Benchmarking without rowid tables (27.55 MB)
39 Imposter tables (9.07 MB)
40 Primary key data types (30.71 MB)
41 Where to add indexes (42.87 MB)
42 Index selectivity (36.61 MB)
43 Composite indexes (45.96 MB)
44 Composite ordering (10.72 MB)
45 Covering indexes (31.82 MB)
46 Partial indexes (28.82 MB)
47 Indexes on expressions (17.4 MB)
48 Automatic indexes (13.12 MB)
49 Duplicate indexes (22.73 MB)
50 Indexing joins (41.54 MB)
51 Explain (55.67 MB)
52 Index obfuscation (17.2 MB)
53 Joins (39.51 MB)
54 Subqueries (40.39 MB)
55 Unions (23.9 MB)
56 CTEs (14.49 MB)
57 Recursive CTEs (30.96 MB)
58 Window functions (49.49 MB)
59 Dealing with NULLs (10.41 MB)
60 Row value syntax (36.76 MB)
61 Indexed sorting (16.56 MB)
62 Upserts (26.9 MB)
63 Returning (13.77 MB)
64 Aggregates (28.98 MB)
65 Triggers (21.34 MB)
66 Altering schema (47.78 MB)
67 Altering schema with tools (16.05 MB)
68 Multi-database (19.09 MB)
69 Multi-tenancy (57.97 MB)
70 Backups (22.52 MB)
71 Exports (95.91 MB)
72 How to corrupt SQLite (23.57 MB)
73 Intro to JSON (27.18 MB)
74 JSON vs JSONB (26.61 MB)
75 Argument types- path, value, JSON (35.49 MB)
76 JSON5 (16.39 MB)
77 Valid JSON (20.07 MB)
78 Creating JSON objects + arrays (7.54 MB)
79 JSON Extraction (20.22 MB)
80 Updating JSON (29.62 MB)
81 JSON aggregates (19.14 MB)
82 JSON table functions (24.71 MB)
83 Indexing JSON (31.5 MB)
84 Creating FTS tables (52.05 MB)
85 Performing searches (33.55 MB)
86 Ranking results (22.2 MB)
87 Highlighting matches (20.89 MB)
88 DHH discusses SQLite in Ruby on Rails (592.23 MB)
89 Distributed SQLite with Litestream and LiteFS (580.89 MB)
90 Offline-first, multiplayer SQLite (758.94 MB)
91 Production SQLite with Turso and libSQL (485.67 MB)
92 DHH discusses SQLite in Ruby on Rails 2 (592.23 MB)
93 Ruby on Rails with SQLite (692.49 MB)
code (272.76 MB)