User Guides

Task-oriented guides for using and operating HeliosDB Full. For a guided tour, start with Getting Started and Connecting.

Getting started

• Getting Started with HeliosDB — Install, start a node and run your first queries.
• Connecting to HeliosDB — Connecting with protocols, drivers and command-line tools.
• Querying Data in HeliosDB — Writing queries, from basic SELECT statements to advanced features.
• HeliosDB Data Types Reference — Supported data types and how they map to SQL.
• HeliosDB Frequently Asked Questions (FAQ) — Answers to common questions about HeliosDB Full.
• HeliosDB User Documentation Index — Overview of the user documentation.
• HeliosDB Zero-Code Developer Guide — Building on HeliosDB with minimal application code.

Configuration and performance

• HeliosDB Configuration Guide — Server configuration options and how to set them.
• HeliosDB Caching Configuration Guide — Configuring the cache layers.
• HeliosDB Performance Tuning Guide — Tuning for OLTP, analytical and mixed workloads.
• HeliosDB Performance Tuning Guide v7.0 — Tuning guidance for the v7 configuration surface.
• HeliosDB Performance Tuning Playbook — Step-by-step playbook for diagnosing performance problems.
• Enhanced EXPLAIN PLAN User Guide — Reading query plans with EXPLAIN.
• HeliosDB Query Optimization Troubleshooting Guide — Diagnosing slow queries and plan problems.
• HeliosDB Workload Management User Guide — Resource groups, priorities and workload isolation.
• HeliosDB Full-Text Search Tuning Guide — Configuring and tuning full-text search.
• HeliosDB Quantum Optimization Guide — Quantum-inspired optimization for complex query plans.

Transactions, replication and availability

• HeliosDB Transactions User Guide — Transaction semantics, isolation levels and usage.
• HeliosDB Deadlock Prevention Operations Guide — Detecting, preventing and resolving deadlocks.
• PostgreSQL 17 Advisory Locks - User Guide — Application-level locking with advisory locks.
• HeliosDB Replication Operations Guide — Setting up and operating replication.
• Multi-Master Replication Operations Guide — Operating multi-master (active-active) replication.
• HeliosDB High Availability Operational Procedures — Failover, switchover and HA maintenance procedures.
• HeliosDB Sharding Strategy Decision Guide — Choosing shard keys and sharding strategies.
• HeliosDB Backup & Recovery Guide — Backup strategies, restore and point-in-time recovery.
• HeliosDB Time-Travel Debugging User Guide — Querying historical states of your data.

Security and compliance

• HeliosDB Security Hardening Guide v7.0 — Hardening a HeliosDB Full deployment.
• Backup Encryption Regulatory Compliance Matrix — How backup encryption maps to regulatory requirements.
• Backup Encryption: Consumer Protection & Privacy Impact Guide — Privacy considerations for encrypted backups.
• HeliosDB Data Quality Management Guide — Defining and enforcing data quality rules.

Data models and integration

• HeliosDB Multi-Model Data Guide — Working with relational, document, graph and other data models together.
• HeliosDB Document Store Guide — Storing and querying JSON documents.
• HeliosDB Geospatial Operations Guide — Spatial data types, indexes and queries.
• HeliosDB Lakehouse Integration User Guide — Working with lakehouse table formats.
• HeliosDB Multi-Cloud Federation User Guide — Querying data held in cloud object storage.
• Oracle 23ai Compatibility Guide — Oracle compatibility status and migration paths.

AI and machine learning

• Autonomous Database Operations Guide — Automated tuning and maintenance features.
• HeliosDB AI Schema Architect User Guide — Generating schema proposals from natural-language descriptions.
• HeliosDB Advanced ML Integration Guide — Integrating machine-learning models with the database.
• HeliosDB Tier 2/3 AI/ML Features User Guide — Learned query optimisation and other AI/ML features.
• HeliosDB Federated Learning User Guide — Training models across datasets without centralising the data.
• SQL-Native RAG User Guide — Retrieval-augmented generation from SQL.
• HeliosDB Multimodal Vector Search User Guide — Vector search across text, image, audio and video embeddings.
• Vector INSERT Examples - Quick Reference — Examples of inserting vector data.
• Conversational BI Production Deployment Runbook — Deploying conversational BI to production.
• Conversational BI Performance Optimization Guide — Tuning conversational BI workloads.

Migration guides

• Migrating from Oracle to HeliosDB — Moving Oracle schemas, PL/SQL and data.
• Migrating from MongoDB to HeliosDB — Moving MongoDB collections and queries.
• Migrating from Cassandra to HeliosDB — Moving Cassandra keyspaces and CQL workloads.