Comparing IBLite, ToGo, and InterBase Server Edition
From InterBase
Go Up to ToGo Quick Start
InterBase offers the following editions:
- IBLite
- InterBase ToGo
- InterBase Server
- InterBase Desktop
- InterBase Developer
Below you can see a comparison of the different editions available on InterBase.
| Attribute Description | IBLite | InterBase ToGo | InterBase Desktop | InterBase Server | InterBase Developer* |
|---|---|---|---|---|---|
| Platforms |   
|
|
 |
|
|
| Licensing of CPU Cores | 1 | 4 | 4 | 8 | 8 |
| Maximum simultaneous users | 1 | 1 | 1 | 1 to Unlimited | 20 |
| Number of connections per user | 1 | 8 | 8 | 4 | 4 |
| Access local database from clients on remote systems |  |
| |||
| Connect to server hosting database on remote systems | |
|
|
|
|
| TCP listening server | |
| |||
| Strong (256bit AES) database and column encryption | No encryption | |
|
|
No Strong Encryption |
| Strong network (SSL) encryption | No encryption | |
|
|
No Strong Encryption |
| Able to import add-on licenses | |
| |||
| Database file size limitation | 100MB | No limit | No limit | No limit | No limit |
| Simultaneous Transactions per Connection | 1** | No limits | No limits | No limits | No limits |
| Change Views | |
|
|
| |
| Services API Enabled | |
|
|
| |
| OTW/SSL Support | |
|
|
| |
| Metadata Updates (ddl operations) | |
|
|
|
|
| External Table Access | |
|
|
|
|
| Performance Monitoring | |
|
| ||
| Journaling and Journal Archives | |
| |||
| Requires a server restart every 48 hours | | ||||
| Available connectivity drivers from RAD Studio (FireDAC and IBX) | |
|
|
|
|
| Point-in-time-recovery of data, with database restoration based on
timestamp for greater recovery flexibility between physical backups |
|
| |||
| Available for deployment | |
|
|
|
|
| Zero-install, embedded database as a library, just link to access database | |
|
|||
| Tablespace support | |
|
| ||
| Embedded InterBase available for Android 64-bit and macOS 64-bit | |
|
|||
| Other connectivity drivers: ODBC, JDBC, ADO.NET, PHP+ | |
|
| ||
| Command line tools for development, administration and validation | |
|
|
* The Developer edition contains much of the functionality of the Server edition and it is meant for development purposes only. The deployment to production requires a license, for more information refer to the VAR Program
**Note: Technically two transactions are allowed. However, one of them is intended so that some drivers use it for metadata queries (for example, in FireDAC).