---
title: "Guides"
description: "Pages in the Guides 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.

- [Change Data Capture (CDC) and Tenant Migration Tutorial](/docs/lite/guides/cdc_and_migration_tutorial/)
- [Compression & Storage Quick Start Guide](/docs/lite/guides/compression_quick_start/) — This guide explains HeliosDB-Lite's compression architecture and per-column storage optimization features.
- [Compression Codecs User Guide](/docs/lite/guides/compression_codecs_user_guide/) — This guide provides detailed information about each compression codec in HeliosDB-Lite, including optimal use cases, data characteristics, and estimated compression ratios for 10GB data scenarios.
- [CONCURRENT REFRESH MATERIALIZED VIEW - Quick Reference](/docs/lite/guides/concurrent_mv_refresh_quick_ref/) — CONCURRENT refresh provides zero-downtime updates to materialized views using atomic table swap.
- [Docker Deployment Guide](/docs/lite/guides/docker_deployment/) — This guide covers building, running, and deploying HeliosDB and HeliosProxy using Docker containers.
- [Encryption Quick Start Guide](/docs/lite/guides/encryption_quickstart/)
- [Getting Started with HeliosDB Lite](/docs/lite/guides/getting_started/)
- [HeliosCore Operations Guide](/docs/lite/guides/helioscore_operations_guide/) — This guide covers day-to-day operations for the HeliosCore Native Storage Engine, including monitoring, configuration, troubleshooting, and performance tuning.
- [HeliosDB Lite Deployment Modes Guide](/docs/lite/guides/deployment_modes/) — HeliosDB Lite supports 4 distinct deployment modes, each optimized for different use cases.
- [HeliosDB Lite REPL Guide](/docs/lite/guides/repl_guide/) — Interactive command-line interface for HeliosDB Lite, inspired by PostgreSQL's psql and SQLite's shell.
- [HeliosDB REPL: Bulk Loading & Feature Exploration Guide](/docs/lite/guides/repl_bulk_loading_guide/) — This guide shows how to populate HeliosDB with test data and explore all HeliosCore features using the REPL.
- [HeliosDB-Lite High Availability Hands-On Tutorial](/docs/lite/guides/ha_hands_on_tutorial/) — Build a HeliosDB Lite primary with a sync and an async standby behind HeliosProxy, test write routing and read routing, monitor replication in SQL.
- [HeliosDB-Lite Production Deployment Guide](/docs/lite/guides/production_deployment/) — In production, HeliosDB Lite runs as a server: one heliosdb-lite start process per data directory.
- [HeliosDB-Lite Quick Start Guide](/docs/lite/guides/quick_start/) — Get started with time-travel queries, database branching, materialized views, and system views in a few minutes.
- [HeliosDB-Lite Security Hardening Guide](/docs/lite/guides/security_hardening/)
- [HeliosProxy Configuration Reference](/docs/lite/guides/heliosproxy_configuration_reference/) — The core proxy.toml settings for running HeliosProxy in front of HeliosDB Lite, with defaults and a complete example.
- [HeliosProxy Integration Guide](/docs/lite/guides/heliosproxy_integration_guide/) — How to integrate HeliosProxy into your application stack.
- [Migration Guide to HeliosDB Lite](/docs/lite/guides/migration/) — This guide helps you migrate your existing database to HeliosDB Lite from SQLite, MySQL, or PostgreSQL.
- [Parameterized Queries - SQL Injection Protection](/docs/lite/guides/parameterized_queries/)
- [PostgreSQL Protocol Quick Start Guide](/docs/lite/guides/postgres_protocol_quick_start/) — For developers integrating HeliosDB-Lite with PostgreSQL clients
- [PostgreSQL SSL/TLS Configuration Guide](/docs/lite/guides/postgresql_ssl_configuration/) — This guide covers SSL/TLS encryption for PostgreSQL wire protocol connections in HeliosDB-Lite.
- [RLS (Row-Level Security) Quick Start Guide](/docs/lite/guides/rls_quickstart/) — Row-level security filters the rows each user can see and change, inside the database.
- [Row-Level Security (RLS) Policy Management Tutorial](/docs/lite/guides/rls_policy_management_tutorial/)
- [Session Management Quick Reference](/docs/lite/guides/session_management_quick_reference/) — Quick reference guide for HeliosDB-Lite session management and monitoring.
- [System Views Quick Reference](/docs/lite/guides/system_views_quick_reference/) — System views provide metadata about database internals.

## Sub-sections

- [Quickstart](/docs/lite/guides/quickstart/) — 7 pages
- [Tutorials](/docs/lite/guides/tutorials/) — 9 pages
- [User](/docs/lite/guides/user/) — 8 pages

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