High Performance SQLite

15h 27m 55s
English
Paid

This course is designed to take you from beginner to expert in SQLite. You'll learn how to use SQLite in production, how to optimize it, and how to use advanced features like full text search and JSON support.

Watch Online High Performance SQLite

Join premium to watch
Go to premium
# Title Duration
1 01. Introduction to this course 04:33
2 02. Introduction to SQLite 05:12
3 03. SQLite is safe 03:04
4 04. It's just a file 03:17
5 05. Running SQLite locally 02:56
6 06. Good uses for SQLite 06:23
7 07. SQLite's limitations 03:52
8 08. The documentation 02:28
9 09. SQLite's structure 04:39
10 10. SQLite's file format 03:52
11 11. Dot commands 09:22
12 12. Pragmas 06:10
13 13. Virtual tables 03:48
14 14. Flexible types 05:43
15 15. Types 10:26
16 16. Strict types 05:41
17 17. Dates 07:59
18 18. Booleans 01:02
19 19. Floating point 07:27
20 20. Rowid tables 11:02
21 21. Auto increme 06:47
22 22. Without rowid 03:26
23 23. Generated columns 06:49
24 24. Locking 04:30
25 25. Rollback mode 04:16
26 26. WAL mode 04:13
27 27. WAL vs Journal benchmarks 05:37
28 28. Busy timeout 04:29
29 29. Transaction modes 04:21
30 30. Vacuum 06:48
31 31. Analyze & Optimize 05:16
32 32. Suggested pragmas 05:23
33 33. Faster inse 01:32
34 34. Introduction to indexes 05:33
35 35. B+ trees 05:01
36 36. Primary, secondary, and clustered indexes 08:07
37 37. Without rowid tables 01:56
38 38. Benchmarking without rowid tables 07:04
39 39. Imposter tables 03:24
40 40. Primary key data types 04:02
41 41. Where to add indexes 11:43
42 42. Index selectivity 09:14
43 43. Composite indexes 11:38
44 44. Composite ordering 03:01
45 45. Covering indexes 09:33
46 46. Partial indexes 08:07
47 47. Indexes on expressions 05:02
48 48. Automatic indexes 04:23
49 49. Duplicate indexes 06:17
50 50. Indexing joins 08:32
51 51. Explain 06:14
52 52. Index obfuscation 03:47
53 53. Joins 09:01
54 54. Subqueries 11:38
55 55. Unions 06:37
56 56. CTEs 03:48
57 57. Recursive CTEs 09:26
58 58. Window functions 10:53
59 59. Dealing with NULLs 03:36
60 60. Row value syntax 10:12
61 61. Indexed sorting 06:12
62 62. Upse 07:56
63 63. Returning 03:34
64 64. Aggregates 09:59
65 65. Triggers 05:29
66 66. Altering schema 10:57
67 67. Altering schema with tools 04:24
68 68. Multi-database 02:20
69 69. Multi-tenancy 11:34
70 70. Backups 04:26
71 71. Expo 05:37
72 72. How to corrupt SQLite 03:04
73 73. Intro to JSON 03:40
74 74. JSON vs. JSONB 05:07
75 75. Argument types- path, value, JSON 09:19
76 76. JSON5 03:20
77 77. Valid JSON 07:13
78 78. Creating JSON obje + arrays 02:43
79 79. JSON Extraction 06:47
80 80. Updating JSON 07:11
81 81. JSON aggregates 05:14
82 82. JSON table functions 07:43
83 83. Indexing JSON 07:49
84 84. Creating tables 13:56
85 85. Performing searches 10:45
86 86. Ranking resu 05:58
87 87. Highlighting matches 05:52
88 88. DHH discusses SQLite in Ruby on Rails 54:00
89 89. Distributed SQLite with Litestream and LiteFS 54:37
90 90. Offline-first, multiplayer SQLite 01:21:25
91 91. Production SQLite with Turso and libSQL 01:02:53
92 92. DHH discusses SQLite in Ruby on Rails 54:00
93 93. Ruby on Rails with SQLite 01:22:39

Similar courses to High Performance SQLite

Fundamentals of Networking Engineering

Fundamentals of Networking Engineeringudemy

Category: Other (Backend)
Duration 13 hours 40 minutes 46 seconds
Web API From Start to Finish

Web API From Start to Finishiamtimcorey.com (Tim Corey)

Category: Other (Backend)
Duration 17 hours 59 minutes 54 seconds
Fundamentals of Backend Engineering

Fundamentals of Backend Engineeringudemy

Category: Other (Backend)
Duration 16 hours 53 minutes 4 seconds
Streaming Databases

Streaming Databasesoreillymedia

Category: Other (Backend)
Duration
Apache Flink

Apache Flinkrockthejvm.com

Category: Other (Backend)
Duration 8 hours 31 minutes 38 seconds
Node, SQL, & PostgreSQL - Mastering Backend Web Development

Node, SQL, & PostgreSQL - Mastering Backend Web Developmentudemy

Category: Sql, Node.js, Other (Backend)
Duration 4 hours 59 minutes 41 seconds
PostgreSQL High Performance Tuning Guide

PostgreSQL High Performance Tuning Guideudemy

Category: Other (Backend)
Duration 2 hours 41 minutes 14 seconds
Building Full-Stack Apps with AI

Building Full-Stack Apps with AIMckay Wrigley (takeoff)

Category: Other (Backend), Other (Frontend)
Duration 8 hours 3 minutes 16 seconds
Clean Code: Writing Code for Humans

Clean Code: Writing Code for Humans pluralsight

Category: Other (Backend), Other (Frontend)
Duration 3 hours 10 minutes 36 seconds