Guides
Pages in this section of the HeliosDB Lite documentation.
- Change Data Capture (CDC) and Tenant Migration Tutorial
- Compression & Storage Quick Start Guide — This guide explains HeliosDB-Lite’s compression architecture and per-column storage optimization features.
- 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 — CONCURRENT refresh provides zero-downtime updates to materialized views using atomic table swap.
- Docker Deployment Guide — This guide covers building, running, and deploying HeliosDB and HeliosProxy using Docker containers.
- Encryption Quick Start Guide
- Getting Started with HeliosDB Lite
- 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 — HeliosDB Lite supports 4 distinct deployment modes, each optimized for different use cases.
- HeliosDB Lite 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 — 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 — 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 — In production, HeliosDB Lite runs as a server: one heliosdb-lite start process per data directory.
- HeliosDB-Lite Quick Start Guide — Get started with time-travel queries, database branching, materialized views, and system views in a few minutes.
- HeliosDB-Lite Security Hardening Guide
- 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 — How to integrate HeliosProxy into your application stack.
- Migration Guide to HeliosDB Lite — This guide helps you migrate your existing database to HeliosDB Lite from SQLite, MySQL, or PostgreSQL.
- Parameterized Queries - SQL Injection Protection
- PostgreSQL Protocol Quick Start Guide — For developers integrating HeliosDB-Lite with PostgreSQL clients
- PostgreSQL SSL/TLS Configuration Guide — This guide covers SSL/TLS encryption for PostgreSQL wire protocol connections in HeliosDB-Lite.
- RLS (Row-Level Security) Quick Start Guide — Row-level security filters the rows each user can see and change, inside the database.
- Row-Level Security (RLS) Policy Management Tutorial
- Session Management Quick Reference — Quick reference guide for HeliosDB-Lite session management and monitoring.
- System Views Quick Reference — System views provide metadata about database internals.
Sub-sections
- Quickstart — 7 pages
- Tutorials — 9 pages
- User — 8 pages