---
title: "Guides / User"
description: "Pages in the Guides / User section."
sidebar:
  hidden: true
pagefind: false
---

<!-- generated by scripts/gen-section-indexes.py; edit the script or replace this page by hand -->

Pages in this section of the HeliosDB Lite documentation.

- [Dump and Restore Procedures Guide](/docs/lite/guides/user/dump_restore/) — heliosdb-lite dump writes a database to a compressed dump file, and heliosdb-lite restore loads a dump file into a database.
- [HeliosDB-Lite Advanced Features Tutorial](/docs/lite/guides/user/advanced_features_tutorial/) — Hands-on guide to EXPLAIN, Vector Search, Materialized Views, and Bulk Loading.
- [HeliosDB-Lite Quick Start Guide](/docs/lite/guides/user/quick_start_guide/) — HeliosDB-Lite is available to licensed customers; contact sales@heliosdb.com for access to the source distribution.
- [HeliosDB-Lite SQLite Conversion Guide](/docs/lite/guides/user/heliosdb_sqlite_conversion_guide/) — Complete Guide to Transparent SQLite ↔ HeliosDB-Lite Conversion
- [HeliosDB-Lite Storage Modes Tutorial](/docs/lite/guides/user/storage_modes_tutorial/)
- [In-Memory Mode User Guide](/docs/lite/guides/user/inmemory_mode/) — In-memory mode allows HeliosDB-Lite to operate entirely in RAM without persisting data to disk during normal operations.
- [Per-Column Storage Modes Guide](/docs/lite/guides/user/storage_modes_guide/) — This guide explains how to use per-column storage modes to optimize storage and query performance for different data characteristics.
- [Self-Maintaining Filter Index (SMFI) User Guide](/docs/lite/guides/user/smfi_guide/) — SMFI is enabled by default and requires no configuration.

[Up one level](/docs/lite/guides/)