High Performance SQLite

15h 27m 55s
English
Paid

Course description

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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 93 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing

Watch Online High Performance SQLite

0:00
/
#1: 01. Introduction to this course

All Course Lessons (93)

#Lesson TitleDurationAccess
1
01. Introduction to this course Demo
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

Unlock unlimited learning

Get instant access to all 92 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Full-Stack Fundamentals 2 - Backend

Full-Stack Fundamentals 2 - Backend

Sources: Mckay Wrigley (takeoff)
In the first project, we focused on the frontend, creating a personal portfolio website. Now we will take the next step towards full-stack development...
1 hour 45 minutes 49 seconds
Database Design & Implementation

Database Design & Implementation

Sources: Amigoscode (Nelson Djalo)
Backend starts from Your Database. When you have a solid database design coding is easy. In this course you will learn how to design databases for your backend applications. You...
2 hours 7 minutes 49 seconds
Build an app with ASPNET Core and Angular from scratch

Build an app with ASPNET Core and Angular from scratch

Sources: udemy
Have you learnt the basics of ASP.NET Core and Angular? Not sure where to go next? This course should be able to help with that. In this course we start from nothing and incr...
29 hours 51 minutes 36 seconds
Apache Kafka Series - Kafka Streams for Data Processing

Apache Kafka Series - Kafka Streams for Data Processing

Sources: udemy
Learn the Kafka Streams API with Hands-On Examples, Learn Exactly Once, Build and Deploy Apps with Java 8. Learn the Kafka Streams data processing library, for
4 hours 50 minutes 7 seconds
Full-Stack Fundamentals 3 - Auth

Full-Stack Fundamentals 3 - Auth

Sources: Mckay Wrigley (takeoff)
In the previous project, we created a working application - Prompt Manager, mastering the key principles of full-stack development using Next.js, Supabase...
1 hour 9 minutes 21 seconds