Skip to content
HeliosDB HeliosDB Full

WASM Procedures: Conclusion

Documentation Home > User Guides > Features > Conclusion

Conclusion

The planned HeliosDB WASM Procedures bring the following to database stored procedures:

Key Capabilities

  1. True Polyglot Procedures - Write database procedures in 4 languages (Rust, JavaScript/TypeScript, Python, Go)
  2. Sub-10ms Execution - Typical operations complete in under 10 ms inside a fully sandboxed runtime
  3. Capability-Based Security - Fine-grained permission control at the database level
  4. Universal WASM Compatibility - Run procedures across any platform without modification

Operations

The planned design includes:

  • Monitoring: Real-time metrics, profiling, and debugging tools
  • Security: Capability-based isolation with resource limits
  • SDKs: SDKs for 4 programming languages (the Go SDK is published today)

Performance Benefits

Execution Speed:

  • 8-10x faster than traditional PL/pgSQL procedures
  • Sub-10ms execution for typical operations
  • AOT compilation for instant startup

Resource Efficiency:

  • 4-5x lower memory usage
  • Instance pooling reduces overhead by 50%
  • Efficient module caching

Scalability:

  • Thousands of concurrent executions
  • Zero-downtime updates
  • Horizontal scaling support

Security Advantages

Sandboxed Execution:

  • 100% memory isolation
  • Capability-based permission system
  • Resource limits (CPU, memory, fuel)
  • System call filtering

13 Capability Types:

  • Fine-grained control over database access
  • Network isolation options
  • File system restrictions
  • Cryptographic operations control

Developer Experience

Language Flexibility:

  • Use Rust for high-performance computation
  • Use Python for data science and ML
  • Use JavaScript for JSON processing
  • Use Go for concurrent operations

Modern Tooling:

  • Full IDE support with autocomplete
  • Type safety and compile-time checks
  • Unit testing outside the database
  • CI/CD integration

Easy Migration:

  • Gradual migration from legacy procedures
  • A/B testing support
  • Shadow mode for validation

Get Started

1. Choose Your Language

Pick the language that best fits your use case:

  • Rust - Maximum performance and safety
  • JavaScript/TypeScript - Familiar syntax and JSON handling
  • Python - Data science and ML workloads
  • Go - Concurrent operations and simplicity

2. Follow the Quick Start

Complete the Quick Start Guide in 20 minutes:

  1. Install SDK and tools
  2. Write your first procedure
  3. Deploy to HeliosDB
  4. Call from applications

3. Explore Use Cases

Learn from real-world examples in the Use Cases section:

  • Real-time fraud detection
  • Multi-model data processing
  • Geospatial analytics
  • Machine learning inference
  • And more…

4. Join the Community

Ask questions and follow progress on the planned feature in the HeliosDB community on Discord.

Resources

Documentation

Related guides:

Document Information

Total Word Count: 19,500+ Code Examples: 75+ Use Cases: 8 Supported Languages: 4

Summary

The planned design for WASM procedures aims at:

  • Language choice: write each procedure in the language that suits the task
  • Isolation: sandboxed execution with resource limits
  • Capability-based security: procedures get only the permissions they are granted
  • Portability: WASM is a W3C standard

Navigation: ← API Reference | Index | Documentation Home