openGauss vs SQLite
openGauss
opengauss.org
SQLite
sqlite.orgSide by side
| Figure | openGauss | SQLite |
|---|---|---|
| Price from | Free | $12.50/mo |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | Yes |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | — | Yes |
| Linux | Yes | Yes |
| iOS | — | Yes |
| Android | — | Yes |
| API | — | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 16 |
| Spec score · Relational Databases | 7.5 (#25) | 8.6 (#6) |
| Deployment | The official site describes standalone and standalone high-availability deployment; HA supports one primary and at least one standby, with up to four standbys. | The project says SQLite is embedded in billions of applications and is the world's most widely deployed database engine. |
| Platforms | The download page lists AArch64 and x86_64 packages for openEuler versions and CentOS 7.6, and lists Windows JDBC, ODBC, Python-psycopg2, and libpq drivers. | The project lists Android, BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows as supported platforms. |
| Product | openGauss is an enterprise-level, open-source multimodal relational database management system. | SQLite is an in-process, self-contained, serverless, zero-configuration transactional SQL database engine. |
| Security | Documented security features include full-encryption computing, access control, encryption authentication, database auditing, dynamic data masking, transparent encryption, and tamper-resistant ledger databases. | The security guidance says SQLite is extensively fuzz-tested and recommends defensive settings and lower input limits for applications accepting untrusted SQL. |
| Support | The site directs users to FAQs and a community forum, and says LTS releases receive three years of community support. | SQLite offers a free public forum as well as paid private email and technical support options. |
Plans
SQLite
- Public ForumFree
- SQLiteFree
- SQLite Consortium Membership$150 a year
- Technical Support$885 a year
- Annual Maintenance Subscription$1,500 a year
- Annual Maintenance Subscription$1,500 a year
- CEROD$2,000, paid once
- CEROD$2,000, paid once
- SQLite Encryption Extension (SEE)$2,000, paid once
- SQLite Encryption Extension (SEE)$2,000, paid once
In their own words
SQLite
SQLite is a transactional SQL database engine that runs within an application, without a separate server process or configuration. Each complete database resides in a single disk file that works across platforms. Its SQL features include partial indexes, indexes on expressions, JSON, common table expressions, and window functions. Transactions are atomic, consistent, isolated, and durable, including after system crashes and power failures. A database file can have unlimited simultaneous readers, but only one writer at a time. The project recommends SQLite for device-local storage with low writer concurrency and less than a terabyte of content. SQLite is free for commercial or private use, with source code in the public domain. Downloads include source and precompiled binaries for Android, Linux, Mac OS X, and Windows, along with WebAssembly and JavaScript bundles for web applications. A free public forum is available, alongside paid private email and technical support options. The maker is based in Charlotte, North Carolina, and was founded in 2000.