Side by side
HSQLDB vs SQLite
Both stand on sql databases. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan Open source APILinuxMac+2
HSQLDB offers a broad relational database feature set with free software and optional paid support. Check its storage limits and license terms against your deployment needs.
Visit HSQLDB
Free plan Open source AndroidAPIiPhone+5
SQLite provides an embedded database with broad SQL capabilities and a simple single-file format. Its one-writer-per-file limit is important when evaluating it for write-heavy workloads.
Visit SQLiteThe facts
| HSQLDB | SQLite | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Yes | Yes |
| Runs on | API, Linux, Mac, Self-hosted, Windows | Android, API, iPhone, Linux, Mac, Self-hosted, Web, Windows |
| Lowest paid plan | Developer SupportWare: $100 a year | See the plans |
| Plans published | 11 | 10 |
| Maker | HSQLDB | SQLite |
| Website | hsqldb.org | sqlite.org |
| On sql databases | #1 of 23 | #2 of 23 |
HSQLDB: what it does well
- Supports embedded and server modes.
- Includes in-memory and disk-based tables.
- Supports lock-based and MVCC transactions.
- Database software is free under its licenses.
- Offers command-line and GUI query tools.
What to know first
- Memory tables are limited by available memory.
- TEXT tables are limited to 256GB each.
- CACHED table size defaults to 8TB.
- Paid subscriptions are required for listed priority support.
SQLite: what it does well
- A complete database is stored in one cross-platform file.
- Supports JSON and window functions.
- Transactions remain durable through crashes and power failures.
- Free for commercial and private use.
What to know first
- Only one writer can use a database file at a time.
- The project recommends it for content below a terabyte.
- Private email and technical support are paid options.
Alternatives to HSQLDB Alternatives to SQLite The whole list