> For the complete documentation index, see [llms.txt](https://xylem.gitbook.io/xylem-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://xylem.gitbook.io/xylem-docs/3.-advanced-guides/3-advanced-usage.md).

# Advanced Guides Overview

This section covers complex hardware integration and specialized data formatting:

* [Raw Pinning & Bootloaders](/xylem-docs/3.-advanced-guides/3-advanced-usage/raw-pinning-and-bootloaders.md) — Ditching partition tables and managing flash directly.
* [Tree-Typed Columns](/xylem-docs/3.-advanced-guides/3-advanced-usage/tree-typed-columns.md) — Handling nested configurations (YAML) directly within database columns.
* [Query Overlays & Hooks](/xylem-docs/3.-advanced-guides/3-advanced-usage/query-overlays-and-hooks.md) — Intercepting, overriding, and extending database reads, writes, and custom operators.