SQL for fun and profit

Want to learn more SQLite? Check out the full course: https://highperformancesqlite.com.

Recursive CTEs (common table expressions) are really powerful, and actually useful! In this video, I demonstrate how to use a recursive CTE in SQLite to identify a missing order from an orders table, showcasing a practical solution to a common business problem. This technique is not only powerful for maintaining data integrity but also impressively versatile for various scenarios, such as filling gaps in sequences like dates or numbers.

Check out Turso for SQLite in production: https://tur.so/af.

Follow Aaron:
Twitter:   / aarondfrancis  
LinkedIn:   / aarondfrancis  
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.

Check out the article version of this video: https://aaronfrancis.com/2024/finding...

Chapters:
00:00 Recursive CTE in SQLite
00:31 Orders Table Set-Up
01:55 Find Missing Order using Recursive CTE
05:40 When to Use Recursive CTE