How to write tests, when to use each type of test, and how to run them. Contains information about conversion of `.test` to `.sqltest`, and how to write `.sqltest` and rust tests

Overview of Experimental MVCC feature - snapshot isolation, versioning, limitations

How to debug tursodb using Bytecode comparison, logging, ThreadSanitizer, deterministic simulation, and corruption analysis tools

General Correctness rules, Rust patterns, comments, avoiding over-engineering. When writing code always take these into account

SQLite file format, B-trees, pages, cells, overflow, freelist that is used in tursodb

Explanations of common asynchronous patterns used in tursodb. Involves IOResult, state machines, re-entrancy pitfalls, CompletionGroup. Always use these patterns in `core` when doing anything IO

General guidelines for Commits, formatting, CI, dependencies, security