SQLite Database

  1. SQLite Internals and Architecture
    1. The Virtual Database Engine
      1. Role of the VDBE
        1. Compilation of SQL to Bytecode
          1. Execution by the Virtual Machine
            1. Opcodes and Instruction Set
              1. Query Planning Process
              2. B-Tree Implementation
                1. Tables as B-Trees
                  1. Indexes as B-Trees
                    1. Structure of Pages and Nodes
                      1. Page Size and Storage Organization
                        1. B-Tree Balancing
                          1. Overflow Pages
                          2. The Pager Module
                            1. Managing Data Pages
                              1. Caching Strategies
                                1. Page Journaling
                                  1. Memory Management
                                    1. I/O Operations
                                    2. Locking and Concurrency Control
                                      1. Database-Level Locking
                                        1. Lock States
                                          1. UNLOCKED
                                            1. SHARED
                                              1. RESERVED
                                                1. PENDING
                                                  1. EXCLUSIVE
                                                  2. Lock Escalation and Contention
                                                    1. Reader-Writer Conflicts
                                                      1. Deadlock Prevention
                                                      2. Write-Ahead Logging
                                                        1. How WAL Mode Operates
                                                          1. Advantages for Concurrency and Performance
                                                            1. Comparison with Rollback Journal Mode
                                                              1. Enabling and Configuring WAL Mode
                                                                1. WAL File Management
                                                                  1. Checkpointing Process
                                                                  2. Storage Engine Details
                                                                    1. File Format Structure
                                                                      1. Page Organization
                                                                        1. Record Format
                                                                          1. Free Space Management
                                                                            1. Database Header Information

                                                                          Previous

                                                                          9. SQLite Extensions and Advanced Capabilities

                                                                          Go to top

                                                                          Next

                                                                          11. Performance Tuning and Best Practices