Notes for the entire course will be available here as the videos go live - https://register.educosys.com/new-courses/25
Github Link for the open source code - https://github.com/sqlite/sqlite
Official Documentation - https://sqlite.org
๐๐ก๐๐๐ค๐จ๐ฎ๐ญ ๐๐๐ญ๐๐ข๐ฅ๐ฌ ๐๐ง๐ ๐๐ง๐ซ๐จ๐ฅ๐ฅ ๐๐จ๐ซ ๐จ๐ฎ๐ซ ๐๐๐๐ ๐๐จ๐ฎ๐ซ๐ฌ๐๐ฌ ๐ก๐๐ซ๐-
https://www.educosys.com
If you appreciate the hard work or want to be consistent with the course, Please ๐ฌ๐ฎ๐๐ฌ๐๐ซ๐ข๐๐ - https://www.youtube.com/@KeertiPurswani
You can also connect with me on-
๐๐ข๐ง๐ค๐๐๐๐ง - https://www.linkedin.com/in/keertipurswani
๐๐ง๐ฌ๐ญ๐๐ ๐ซ๐๐ฆ (for personal, raw and real side of my life) - https://www.instagram.com/keerti.purswani
๐๐๐ฎ๐๐จ๐ฌ๐ฒ๐ฌ ๐๐ง๐ฌ๐ญ๐๐ ๐ซ๐๐ฆ - https://www.instagram.com/educosys
The video contains following parts-
0:00-0:23 - Coming up
0:23-1:20 - Intro
1:20-3:52 - SQLite Basics and Intro
3:52-4:50 - MySQL, PostgreSQL Vs SQLite
4:50-5:50 - GitHub and Documentation
5:50-19:33 - Architecture Overview
19:33-21:15 - Educosys
21:15-24:09 - Code structure
24:09-27:00 - Tokeniser
27:00-31:18 - Parser
31:18-37:10 - ByteCode Generator
37:10-45:43 - VDBE
45:43-48:48 - Pager, BTree and OS Layer
48:48-1:00:29 - Write Ahead Logging, Journaling
1:00:29-1:04:25 - Cache Management
1:04:25-1:12:45 - Pager in Detail
1:12:45-1:17:36 - Pager Code walkthrough
1:17:36-1:18:12 - Coming up
1:18:12-1:20:17 - Limitations of SQLite and Thank you
#softwaredevelopment #softwareengineer #database #systemdesign