Skip to content
HeliosDB HeliosDB Lite

HeliosDB-Lite Tutorials

HeliosDB-Lite Tutorials

Step-by-step guides for every major feature. Each tutorial includes SQL examples, expected output, and troubleshooting tips.

Getting Started

TutorialDescriptionDifficulty
RBACRoles, GRANT/REVOKE, column-level permissionsBeginner
Backup & RestoreFull/incremental backup, restore to branchBeginner
Vacuum & MaintenanceVACUUM, CHECKPOINT, REINDEXBeginner

Security

TutorialDescriptionDifficulty
Row-Level SecurityPer-row access control policiesIntermediate
Rate Limiting & SSLPer-user quotas, SSL enforcementIntermediate
Security HardeningResource limits, checksums, input validationIntermediate
EncryptionTDE, key rotation, ZKEAdvanced

HTAP & Analytics

TutorialDescriptionDifficulty
HTAP & ColumnarColumnar storage, workload classification, compressionIntermediate
Materialized ViewsCreate, refresh, auto-refresh, optimizer rewriteIntermediate
Plan Cache & PerformanceHow the 129x plan cache works, monitoringIntermediate

Advanced SQL

TutorialDescriptionDifficulty
Advanced SQLWindow functions, CTEs, JSONB, FTS, UPSERTIntermediate
Vector SearchHNSW indexes, kNN queries, distance metricsIntermediate
Triggers & PL/pgSQLUser-defined functions, triggers, control flowAdvanced

Recovery & Branching

TutorialDescriptionDifficulty
PITRPoint-in-time recovery, branch forkingAdvanced
Branching & Time TravelGit-like branches, AS OF TIMESTAMP queriesAdvanced

Graph & Search

TutorialDescriptionDifficulty
Graph QueriesProperty graph, traversal algorithms, SQL functionsIntermediate
Hybrid SearchBM25, hybrid BM25+vector, RRF/MMR rerankersIntermediate
CursorsDECLARE, FETCH, CLOSE for large result setsBeginner

Monitoring

TutorialDescriptionDifficulty
System ViewsAll 30+ system views for monitoringReference

HA / Proxy (Feature-Gated)

TutorialDescriptionDifficulty
Pool ModesConnection pooling modesAdvanced
DistribCacheDistributed cachingAdvanced

Suggested Learning Path

  1. Start with RBAC to understand users and permissions
  2. Try Backup & Restore for data safety
  3. Learn Advanced SQL for query power
  4. Explore HTAP & Columnar for analytics
  5. Set up Security Hardening for production
  6. Try Graph Queries and Hybrid Search for advanced retrieval
  7. Use System Views for monitoring