Appwrite vs ClickHouse vs MariaDB
Appwrite, ClickHouse, MariaDB compared on license, free-edition limits, deployment and project health. Change a project below to compare something else.
| Appwrite | ClickHouse | MariaDB | |
|---|---|---|---|
| Category | Backend & Databases | Backend & Databases | Backend & Databases |
| License | BSD 3-Clause LicenseOpen source (OSI) | Apache License 2.0Open source (OSI) | GNU General Public License v2.0Open source (OSI) |
| Free edition | Some features paywalled | Some features paywalled | Not confirmed |
| Deployment | Self-hosted · Cloud | Self-hosted · Cloud | Self-hosted · Cloud |
| Self-hosting setup | Needs a database | Single container | Single container |
| SSO / SAML | Paid | Not confirmed | Not confirmed |
| Role-based access control | Paid | Free | Free |
| Audit logs | Paid | Not confirmed | Free |
| Multi-user / teams | Free | Free | Not confirmed |
| Backups and restore | Not confirmed | Free | Free |
| API access | Free | Free | Not confirmed |
| Support SLA | Paid | Paid | Paid |
| GitHub stars | 58k | 50k | 8.4k |
| Last release | Oct 8, 2026 | Oct 12, 2026 | Sep 15, 2026 |
| Alternative to | Firebase | BigQuery, Snowflake | MySQL, Oracle Database |
In short
- Appwrite is licensed BSD 3-Clause License (open source (osi)). Free edition: some features paywalled.
- ClickHouse is licensed Apache License 2.0 (open source (osi)). Free edition: some features paywalled.
- MariaDB is licensed GNU General Public License v2.0 (open source (osi)). Free edition: not confirmed.
Each project page lists the official sources behind these answers. Where the official pages do not say, the table shows “Not confirmed”.