Lightweight embedded database for WizIIOT deployments
A built-in alternative data store providing low-overhead database capability for simplified configurations.
What it is
H2 Embedded Database Server is a platform database component that runs as an embedded service within WizIIOT, offering an alternative to external SQL Server installations. It provides TCP network access and a web console for database management, making it suitable for smaller deployments, testing, or situations where a lightweight embedded database meets your needs. Configuration is handled through platform settings with automatic lifecycle management.
Key benefits
Reduced Deployment Complexity
Eliminate the need for a separate SQL Server instance. The database runs embedded within the platform, requiring less infrastructure setup and ongoing maintenance overhead.
Lower Resource Footprint
Consume less system memory and CPU compared to full-scale database servers. Ideal for edge nodes, testing environments, or smaller installations.
Automatic Lifecycle Management
The platform handles database startup, health monitoring, and graceful shutdown. No manual database service administration required.
Web-Based Management Console
Access database administration and queries through an integrated web interface (a configurable port) for convenient monitoring and troubleshooting without external tools.
Capabilities
- Embedded H2 database engine for platform data storage
- Network-accessible TCP server (a configurable port) for multi-client access
- Integrated web console for database administration and monitoring
- Automatic health checking and failover (60-second polling cycle)
- Data-driven logging configuration managed through platform settings
- Support for database profiles including SQL Server, MySQL, PostgreSQL, and Oracle fallback
- Secure configuration via encrypted connection credentials