MySQL vs SQLite
MySQL
mysql.com
SQLite
sqlite.orgSide by side
| Figure | MySQL | SQLite |
|---|---|---|
| Price from | Free | $12.50/mo |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | Yes |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| iOS | — | Yes |
| Android | — | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 18 | 16 |
| Spec score · Database Software | 9.5 (#1) | 9.4 (#2) |
| Spec score · Sql Databases | 8.9 (#2) | 8.7 (#4) |
| Spec score · Relational Databases | 8.9 (#4) | 8.6 (#6) |
| Spec score · Transaction Data Store Software | 8.9 (#5) | 8.7 (#8) |
| Free plan | Yes | Yes |
| Support | MySQL Enterprise technical support provides 24x7 direct access to MySQL support engineers. | SQLite offers a free public forum as well as paid private email and technical support options. |
| Supported systems | MySQL Community Edition is available on over 20 platforms and operating systems including Linux, Unix, Mac and Windows. | Official support covers Android, BSD variants, iOS, Linux, macOS, Solaris, VxWorks and Windows. |
| Transactions | MySQL is transaction-safe and ACID compliant with commit, rollback, crash recovery and row-level locking. | SQLite transactions are atomic, consistent, isolated, and durable even after system crashes and power failures. |
Plans
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
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.