HeliosDB Full extends standard SQL with Change Data Capture (CDC) commands (CDC streams are planned), GPU commands (no effect in the public release build; NVIDIA CUDA builds on request), and multi-region and autoscaling commands that are planned with Full clustering. All commands are sent through standard PostgreSQL protocol clients (psql, JDBC, etc.).
Key Capabilities
Capability
Description
Protocol
Standard SQL
Full SQL query support
PostgreSQL wire protocol
GPU Operations
Enable/disable GPU acceleration (CUDA builds on request)
SET/SHOW commands
Multi-Region
Configure regions, consistency (planned)
SET/SHOW commands
Autoscaling
Control compute scaling (planned)
SET/SHOW commands
CDC
Recent change events today (SHOW CDC EVENTS); streams to external systems planned
SHOW; CREATE/ALTER/DROP planned
SQL Extensions
GPU Operations
Command
Description
SET gpu_enabled = true/false
Enable/disable GPU acceleration
SET gpu_memory_limit = '4GB'
Set GPU memory limit
SHOW gpu_status
Display GPU configuration
SHOW gpu_devices
List available GPU devices
Multi-Region Management
Command
Description
SHOW REGIONS
Display all regions
SHOW REGION STATE
Current region configuration
SET preferred_region = 'region'
Set preferred region
SET consistency_level = 'level'
Set consistency (eventual/strong/quorum)
Autoscaling Management
Command
Description
SHOW AUTOSCALE STATE
Current autoscaling metrics
SET autoscale_enabled = true/false
Enable/disable autoscaling
SET autoscale_target_cu = N
Set target compute units
SET autoscale_min_instances = N
Set minimum instances
SET autoscale_max_instances = N
Set maximum instances
SHOW COMPUTE NODES
List all compute nodes
Change Data Capture
CDC streams are planned: the current release does not accept these statements. SHOW CDC EVENTS [LIMIT n] reads the server’s in-memory log of recent INSERT, UPDATE and DELETE statements today.
Command
Description
SHOW CDC EVENTS [LIMIT n]
Recent change events (available)
CREATE CHANGE DATA CAPTURE ON table
Create CDC stream (planned)
SHOW CDC STREAMS
List active streams
SHOW CDC STREAM STATE name
Stream details
ALTER CDC STREAM name PAUSE/RESUME
Control stream
DROP CHANGE DATA CAPTURE name
Remove stream
Client Compatibility
HeliosDB’s SQL interface is compatible with standard PostgreSQL clients:
Client
Result
Notes
psql
Supported
Full compatibility
JDBC
Supported
PostgreSQL JDBC driver
Python (psycopg2)
Supported
Standard connection
Go (pgx)
Supported
Native driver
Node.js (pg)
Supported
PostgreSQL client
.NET (Npgsql)
Supported
ADO.NET provider
Quick Examples
Enable GPU Acceleration
SET gpu_enabled = true;
SET gpu_memory_limit ='8GB';
-- Queries will now use GPU when beneficial
SELECT region, SUM(sales), AVG(price)
FROM sales_data
GROUP BY region;
Configure Multi-Region (planned)
-- Planned with Full clustering; no effect today
SET preferred_region ='us-west-2';
SET consistency_level ='quorum';
-- Queries routed to preferred region
SELECT*FROM products;
Create CDC Stream (planned)
-- Planned syntax; today, run SHOW CDC EVENTS to see recent changes
