Small. Fast. Reliable.
Ready for production.
High Performance SQLite is a comprehensive video course by database educator @aarondfrancis . Learn everything you need to confidently use SQLite in production.
This course is sponsored by:
What to expect
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.
Module 1
Introduction
Module 2
SQLite Internals
Module 3
Schema
Module 4
Optimizing SQLite
Module 5
Indexes
Video 34
Introduction to indexes
5:32
Video 35
B+ trees
5:00
Video 36
Primary, secondary, and clustered indexes
8:06
Video 37
Without rowid tables
1:56
Video 38
Benchmarking without rowid tables
7:04
Video 39
Imposter tables
3:23
Video 40
Primary key data types
4:02
Video 41
Where to add indexes
11:43
Video 42
Index selectivity
9:14
Video 43
Composite indexes
11:37
Video 44
Composite ordering
3:01
Video 45
Covering indexes
9:33
Video 46
Partial indexes
8:06
Video 47
Indexes on expressions
5:02
Video 48
Automatic indexes
4:22
Video 49
Duplicate indexes
6:17
Video 50
Indexing joins
8:31
Module 6
Advanced SQL
Video 51
Explain
6:00
Video 52
Index obfuscation
Free
3:47
Video 53
Joins
9:01
Video 54
Subqueries
11:37
Video 55
Unions
6:37
Video 56
CTEs
3:48
Video 57
Recursive CTEs
9:26
Video 58
Window functions
Free
10:52
Video 59
Dealing with NULLs
3:36
Video 60
Row value syntax
10:11
Video 61
Indexed sorting
6:11
Video 62
Upserts
7:56
Video 63
Returning
3:33
Video 64
Aggregates
9:59
Video 65
Triggers
5:29
Module 7
Operating SQLite
Module 8
Advanced JSON
Video 73
Intro to JSON
3:40
Video 74
JSON vs. JSONB
5:06
Video 75
Argument types: path, value, JSON
9:19
Video 76
JSON5
3:20
Video 77
Valid JSON
7:12
Video 78
Creating JSON objects + arrays
2:43
Video 79
JSON Extraction
6:47
Video 80
Updating JSON
7:10
Video 81
JSON aggregates
5:14
Video 82
JSON table functions
7:43
Video 83
Indexing JSON
7:48
Module 9
Full Text Search
Module 10
Bonus Interviews
Video 88
DHH discusses SQLite in Ruby on Rails
Free
54:00
Video 89
Distributed SQLite with Litestream and LiteFS
Free
54:36
Video 90
Offline-first, multiplayer SQLite
Free
81:24
Video 91
Production SQLite with Turso and libSQL
Free
62:53
Video 92
Migrating from Postgres to SQLite with Kent C. Dodds
Free
57:02
Video 93
Ruby on Rails with SQLite
Free
82:39
Join 1,220 students
Here's what some of the students who have taken the course have to say:
I had given up on SQLite 5 years ago, because of some false myths across the internet. Thank you Aaron for bringing me back to this powerful database! Shipped almost two apps, love the simplicity and the high performance of SQLite! This course is best possible investment 🚀Iliyan Slavov
Whether you want to learn SQLite from scratch or just want to level up your game, High Performance SQLite is by far the best course out there. I've been using SQlite for over a decade now and still managed to learn a lot from this course. It's a fantastic investment and a no brainer.Kulshekhar Kabra
Aaron's course offered invaluable insights into using SQLite on the server side, boosting my confidence to implement it in our company's projects.Alexis Trechau
Thank you for the excellent High Performance SQLite course! It’s been incredibly useful in deepening my understanding of SQLite. The sections on SQLite internals, schema, and optimization techniques are particularly insightful and have significantly improved my ability to work with SQLite in production environments.Ali Kasmani
Aaron is an incredible! Every video is packed full of useful information explaining concisely, I learned so much from this course!Derek Dorr
Some people stray away from a course like this because they find it too niche, but really there are great takeaways that you can apply to other databases. There are sections that cover optimization like how to treat indexing and how to write better queries SQLite is also relatively smaller, so it makes it easier to digest and really understand the engine that drives your application layer. I think this course really hit the nail on all points and I highly recommend it to anyone even curious about databases in general. Also of course the Aaron Francis/Try Hard touch always makes it a great time and interactive.Dylan Hackworth
The production quality of this course is so good and Aaron‘s enthusiasm and energy is infectious. I’m excited to master this extremely useful and powerful database technology that I had once written off as a toy for small projects. Now I know where SQLite shines and how I can use it effectively.JD Lien
I highly recommend the HighPerformanceSQLite course! Aaron's design makes it easy to grasp the basics before diving into advanced performance topics. It's a fantastic learning experience that will definitely boost your SQLite skills for real-world applications.Antonio Pagano
High Performance SQLite is an excellent and immersive course, featuring real-time typed commands and valuable edge case explanations. I highly recommend it for enhancing your SQLite skills.Han-Hsun Liu
One of the best courses I've ever had! This is something that I wish I watched in my early engineering days. But it also brings a lot of interesting and useful knowledge even now when I'm a senior. Totally worth the money!Piotr Tobiasz
I highly recommend High-Performance SQLite to fellow engineers. My motivation for learning SQLite stemmed from my interest in local-first applications, and I needed to understand SQLite to effectively use it in the browser. This resource provided that knowledge in a clear and practical manner, making it a must-watch for modern developers.Yuya Fujimoto
Aaron is anything but boring, he makes learning engaging and has given me more than one trick up my sleeve. I have been working with relational databases both professionally and for all my side projects and I've learned things about databases I didn't even know existed. Any course this man produces is an instant auto-buy because he makes it easy to do. You can tell he's put his heart and soul into this course and it'll stick with me longer than the current season of 'The House of the Dragon.' Wow is there any topic this guy can't make fun!Alex Maven
It’s not just for SQLite, Aaron is a veritable fount of SQL knowledge. The tips and pointers given in this course will surely help you decide what to handle on the db vs the app side.Hans Verschooten
High Performance SQLite helped level up our local-first React Native apps, taking full advantage of the database features and squeezing out the best performance.Dwight Watson
Aaron and Steve are a killer combo for high quality courses like High Performance SQLite. The course shows at great detail the ins and outs of SQLite and how to scale it to compete with any other database. I love it!Nik Spyratos
High Performance SQLite is more than just an SQLite course, it is a general SQL masterclass. The course has unlocked new breakthroughs for query performance in my day-to-day, it's a great level-up!Eckhardt Dreyer
Aaron Francis has done it again with High Performance SQLite! You'll learn how to make SQLite fast and some important database fundamentals. There's a ton of lifetime value you won't want to miss out on!Austin Karren
This is by far the best course on SQLite out there, Aaron put a lot of effort into it to explain the ins and outs of this fantastic database. Highly recommend it!Alexandru Vladutu
High Performance SQLite has been the single best pragmatic guide for SQLite on the Internet. This course is a must have for all developers at any stage in their DB journey.Tony Mannino
Aaron is communicating so clearly that my 10 year old daughter understands what he is talking about. Production is at the highest level I have ever seen. I first watched his MySQL course and I can see the progress Steve and Aaron are making. HP SQLite course is a pure masterpiece.Ivan Bunčić
This course is great. Not only is it an insightful deep dive on performant SQLite, but it also helps one understand a lot about modern databases in general.Steven Fox
The course is very clear, accessible and ready for the beginner, advanced or the future sqlite user. Get ready for a serious mix of in depth technical knowledge and an approachable way of learning from an experienced teacher.Martijn De Boer
I went from near 0 to 100 in less than two weeks with this course. If you want to be a SQLite wizard, and just want to up-level your SQL skills in general, this is definitely the course for you.Anthony Bullard
Aaron has this fantastic way of breaking down complex topics to bits that are understandable. I finally understand how to tune my PRAGMA values instead of just copy/pasting from StackOverflow.Mathias Hansen
It's a really well-structured course that helped me understand the intricacies of SQLite through short and easy-to-grasp videos. The content is on point, non-opinionated, thoughtfully presented, and has good real-life applicability. Thanks to Aaron and the team!Viacheslav Azarov
Fantastic! So much packed into one course. Full-text search was a cherry on top of what's possible with SQLite. The course opened my mind to completely new ideas, and gave me perspective on databases in general.Przemyslaw Figura
Meet your instructor
My name is Aaron Francis.
I'm a software developer, database educator, and content creator. (More importantly though, I'm a dad to two (!) sets of twins!)
I created this course because I love databases and want more software developers to feel empowered to work with them.
If you want to get in touch you can always find me on Twitter or shoot us an email [email protected].
Start learning today
Learn how to make SQLite production ready from a developer's point-of-view.
Team Pricing
$
479
USD, plus local taxes
We offer team discounts on the full course based on the number of team members you'd like to purchase for.
Need more seats? Email us.
It's a really well-structured course that helped me understand the intricacies of SQLite through short and easy-to-grasp videos. The content is on point, non-opinionated, thoughtfully presented, and has good real-life applicability. Thanks to Aaron and the team!Viacheslav Azarov
Frequently Asked Questions
I'm having issues with the course. Who can I contact?
Oh no! Send us an email at [email protected].
Is there a free trial available?
There are several free videos, but no free trial. If you aren’t fully satisfied with the course, just ask for your money back—no problem.
Is there a money back guarantee?
If, for any reason, you find yourself less than fully satisfied with the course, you may request a refund at any time.
Can I get an invoice?
Absolutely! After making a purchase we will automatically email you a receipt. If you need a more detailed invoice, just email us.
Do you offer discounts?
Sure, if you live in a country where the USD price is too high or if you are a student, don't hesitate to email us!