Frabit officially supports the following major versions for each supported database engine:
- MySQL - 5.7 and above
- ClickHouse - 21.0 and above
- MongoDB - 4.0 and above
- Redis - 6.0 and above
Frabit usually works fine with older database versions, we just won't support features specific to those older versions. We may add other open source databases in the future.
Feature Matrix
Change Mangement
| Feature | Batch Change | SQL Lint | State-based Migration | Schema Editor | Online Schema Change |
|---|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ✔️ | ||||
| MongoDB | ✔️ | ||||
| Redis | ✔️ |
SQL Editor
| Feature | Sheet Management | Query Mode |
|---|---|---|
| MySQL | ✔️ | ✔️ |
| ClickHouse | ✔️ | ✔️ |
| MongoDB | ✔️ | |
| Redis | ✔️ |
Data Security & Governance
| Feature | RBAC | Audit Log | Query and Export Control | Data Access Control | Data Masking |
|---|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ✔️ | ✔️ | ✔️ | ✔️ | |
| MongoDB | ✔️ | ✔️ | ✔️ | ✔️ | |
| Redis | ✔️ | ✔️ | ✔️ | ✔️ |
Disaster Recovery
| Feature | Local Backup and Restore | Ultimate Backup | Data Change Rollback | Point-in-time Recovery (PITR) |
|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ||||
| MongoDB | ||||
| Redis |
Anomaly Detection
| Feature | Connection Failure | Drift Detection | Backup Policy Violation | Backup Missing | Slow Query |
|---|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ✔️ | ✔️ | |||
| MongoDB | ✔️ | ||||
| Redis | ✔️ |