Skip to content
HeliosDB HeliosDB Full

HeliosDB Tutorials

HeliosDB Tutorials

Learn by doing - Hands-on tutorials for every skill level

Tutorial Levels

Basic (6 tutorials) - 10-15 minutes each

Perfect for getting started with HeliosDB fundamentals.

  1. Basic CRUD Operations ⭐ START HERE

    • Create, read, update, delete
    • Transactions and rollbacks
    • Basic data types

  2. SHOW Commands & Introspection 🆕

    • 100+ SHOW commands for database exploration
    • Storage internals, caches, protocols
    • FLUSH commands for cache management

Intermediate (12 tutorials) - 15-20 minutes each

Deep dive into HeliosDB’s enterprise features.

  1. EXPLAIN Plans & Query Analysis 🆕

    • 7 output formats (Text, JSON, YAML, XML, HTML, GraphViz, Mermaid)
    • Feature detection, “Why Not” analysis
    • Optimizer decisions with reasoning

  2. Redis Protocol 🆕

    • 104+ commands: Strings, Hashes, Lists, Sets, Sorted Sets
    • Streams, Geo, HLL, Bitmaps, Lua scripting
    • BullMQ-compatible queues, Pub/Sub, ACL

  3. CDC Events & Storage Tiering 🆕

    • Change Data Capture on INSERT/UPDATE/DELETE
    • Hot/warm/cold storage tiering
    • CDC connectors and Redis Streams bridge

  4. Multi-Protocol Access 🆕

    • 14 protocol adapters simultaneously
    • Protocol auto-detection
    • REST admin API (16 endpoints)

  5. MongoDB Protocol & AI Commands 🆕

    • Wire-compatible mongosh access (CRUD, aggregation, transactions)
    • AI commands: vectorSearch, nlQuery, schemaAnalyze, indexRecommend
    • GridFS, change streams, cross-protocol queries

Advanced (9 tutorials) - 20-30 minutes each

Cutting-edge features for advanced users.

  1. Security, Compliance & Multi-Tenancy 🆕

    • RBAC, RLS, compliance (GDPR/HIPAA/SOC2)
    • Multi-tenancy, encryption key rotation
    • Audit logging, threat detection

  2. AI/ML, Vector Search & RAG 🆕

    • HNSW/IVF vector indexes, embeddings
    • RAG pipelines, NL2SQL
    • Cluster, federation, WASM, lineage

How to Use These Tutorials

Prerequisites

  • Docker installed (Get Docker)
  • Basic SQL knowledge (helpful but not required)
  • 5 minutes to complete Quickstart

Tutorial Format

Each tutorial follows this structure:

  1. Time Estimate - How long it takes
  2. What You’ll Learn - Key takeaways
  3. Prerequisites - What you need
  4. Setup - Environment preparation
  5. Step-by-Step Guide - Hands-on walkthrough
  6. Troubleshooting - Common issues
  7. Next Steps - Where to go next
  8. Complete Code - Full working example

Running Examples

All tutorial code is tested and runnable:

The SQL in each tutorial runs as-is against any HeliosDB Full instance; connect with psql (or any PostgreSQL client) and paste the statements.

Learning Paths

Path 1: Application Developer

Goal: Build apps with HeliosDB

  1. Basic CRUD Operations

Time: ~2 hours

Path 2: Database Administrator

Goal: Deploy and manage HeliosDB in production

Time: ~3 hours

Path 3: Oracle Migrator

Goal: Migrate from Oracle to HeliosDB

  1. Migration Guide: Oracle → HeliosDB

Time: ~1.5 hours

Path 4: ML/AI Developer

Goal: Build AI-powered applications

Time: ~1.5 hours

Path 5: Data Engineer

Goal: Build real-time data pipelines

Time: ~1.5 hours

Get Help

Contributing Tutorials

Want to write a tutorial? We’d love your help!

  1. Email your tutorial idea to support@heliosdb.com
  2. Follow the Tutorial Template
  3. Send the draft to the same address for review

Tutorial Quality Standards:

  • All code must be tested and runnable
  • Clear step-by-step instructions
  • Troubleshooting section
  • Time estimate accurate (±20%)
  • Screenshots/diagrams where helpful

Happy Learning!

Start with the Quickstart Guide or dive into Tutorial 01: Basic CRUD.