Multiple Data Sources

Overview

FastBee commercial edition supports multiple relational databases so the platform can adapt to different delivery environments and customer infrastructure. Common options include MySQL, PostgreSQL, DM, Kingbase, SQL Server, and Oracle.

Usage Guidance

• Use MySQL for quick evaluation and standard deployments.
• Confirm JDBC driver, connection URL, account permissions, character set, and time zone before switching databases.
• Keep initialization SQL and upgrade SQL aligned with the target database type.
• In production, enable backup, slow-query analysis, and connection-pool monitoring.

Delivery Checklist

1. Confirm the selected database version and driver compatibility.
2. Prepare initialization scripts and migration scripts for the target database.
3. Verify login, product management, device management, rules, alarms, and reports.
4. Check scheduled backup and restore procedures before launch.