Query
loading editor…
Examples
Engine canvas
scanned 0matched 0
B+tree index
No index allocated
Create a table with an INT PRIMARY KEY, then insert rows to grow a B+tree.
Pages
No pages allocated yet
The pager hands out 4,096-byte pages on demand. Run a query.
idle0/0
No results yet. Run a query.
Write-ahead log
0 records durableEvery CREATE and INSERT is appended here before the pages change. That ordering is what makes recovery possible.