Embarcadero InterBase 2020 Server Edition for Windows and Linux - Update 6

InterBase is one of the fastest native databases available, with a small lightweight footprint. InterBase leverages today's multi-core CPUs and multi-CPU systems, along with a unique...


InterBase is one of the fastest native databases available, with a small lightweight footprint. InterBase leverages today's multi-core CPUs and multi-CPU systems, along with a unique versioning approach and advanced disk I/O caching, to retrieve and update your data blazingly fast. InterBase is an SQL Standards compliant database. InterBase strictly follows SQL industry standards. InterBase supports unicode and is ideal for any character set globally. InterBase offers multiple join unicode, real-time event alerts, and our patent pending Change Views’ SQL-based change tracking.

Change Views. Change Views speeds up applications and lowers network traffic and costs by identifying and fetching only the changes made to the database. Read the Change Views white paper

Multi-Generational Architecture. Connect with consistent database snapshots, ensure readers don’t block writers from making changes and increases scalability.

Event Alerts. InterBase Events enable a real time alert to connected clients when a change is committed. This saves on CPU intensive database polling and increases database scalability.

Customizable. Easily customize InterBase with custom field types, stored procedures, custom exceptions, and Triggers. Customization helps automate database logic, data transformation, and easy maintenance.

Generators. Generators allow you to fetch sequential numbers that are typically used for Primary Keys. InterBase will not assign duplicate keys. Generators enable InterBase to produce key values centrally in the database.


Multi-platform support. Runs on Windows, Linux, Mac OS X, Android and iOS. InterBase also supports heterogeneous OS connectivity across all supported platforms.

Cross-Language Support. InterBase supports Java, C, C++, .NET, Delphi, PHP and Ruby and integrates closely with RAD Studio IDEs. Visual Studio developers can work with InterBase through ADO.NET or ODBC connectors.

Server Data Storage. Commercial grade data storage on both server and clients powering online and offline application capabilities. InterBase Server, Developer and Trial editions are suitable for installed servers.

Client Data Storage. InterBase ToGo and IBLite versions can be used as standalone embedded databases with local storage. Local storage reduces the need for network traffic to reduce costs, improve app speed and user experience.

Single on disk format. InterBase’s single file format allows you to deploy your applications anywhere. A unified on-disk format allows fast support and testing directly from your development machine.


Small footprint. In its smallest distribution InterBase is only a few megabytes. The small on-disk footprint and small in-memory requirements makes it ideal for any device requiring a commercial grade embeddable database engine.

Fast Install. InterBase Server installs complete in seconds with an embeddable installer to allow for silent install of server and client drivers. When it comes to InterBase ToGo, no installation is required! Just deploy the InterBase libraries along with your application.

Faster Data. InterBase’s Change Views improves data speed and scalability by dramatically reducing the amount of data moved, lowering data costs, network traffic, server CPU demand and disk I/O.

Write-Ahead Logging. Journaling provides the security of immediate write of changes to disk with the benefits of a full in-memory database system. Enable Journaling through a single line of SQL without any changes in your application.

Admin Free

Admin-Free. InterBase will just run and run and run! Even with the hardest working databases processing 10,000+ transactions each second, it could be years before you need to backup and restore the latest InterBase database server. InterBase servers are so good at being admin free, MARS Rover used a copy on Mars (it is too far to send a DBA!).

Rapid crash recovery. InterBase was one of the first ACID compliant databases on the market, and this foundation means it will get back up and running very quickly following any server crash. In fact, InterBase is so good at this, it has been deployed in tanks, helicopters and medical equipment globally where time to recover is critical following any system reboots.

Disaster Recovery. InterBase also offers a range or fail over capabilities including Incremental Backups, Journals, Point-in-time recovery and database shadowing.


Cyber attacks against databases and loss of data can be costly, lead to loss of customers’ trust (and business), regulatory action and even large fines. InterBase provides over-the-wire and at-rest encryption, separate security login, and role-based user security. InterBase encryption adds very little overhead to database speed and performance, while still maintaining full on disk encryption.

Cross-Platform Encryption. InterBase supports encryption over-the-wire between server and clients, and data-at-rest (both DES and AES 256bit encryption). InterBase encryption is built-in as part of its cross platform single file format.

Separate Security login. Data visibility is defined by a specialist login to the database (SYSDSO) with column level granularity that ensures even developers cannot bypass encryption and view and search for sensitive data.

Reduced Risk. Built-in granular column level encryption drastically reduces the risk of data breaches through requirement changes and product refactoring as your data layer (and not your application) is managing data visibility.

Role based User Security. Define User Security Roles that match to job roles (Accountant, Accounts Manager, Sales, HR, etc.) to easily add or remove access to both data and data changes tracking across your system.

Encrypted Backups. InterBase also supports a backup-specific encryption key that allows an encrypted backup to be created and answers the needs of those requiring command line backups to be run via scheduling.

Disaster Recovery

Your app and business runs on data, making database Disaster Recovery a critical feature. Interbase supports effective Disaster Recovery planning through live backups, incremental dumps, multi-threaded restore, write-ahead logging, and point in time recovery. The database can either be backed up via command line, through our admin tools, via code using the backup API’s or via the ODBC driver GUI.

Live Backups InterBase’s multi-versioning architecture enables backup snapshots to be taken while users are still connected and changing the database.

Distinguished Data Dumps. Distinguished Data Dumps quickly create a read-only copy of your database. In a DR scenario, switching the database to read/write is faster than waiting for a restore. First time setups create a complete copy of the database, while subsequent runs update the copy with only the changes to the primary database.

Fast Restores. InterBase restores using multiple threads on multiple processors to ensure the fastest possible restoration of the database and Indexes.

Write-Ahead Logging. InterBase’s Journaling provides the security of immediate write of changes to disk, with the benefits of a full in memory database system. Enable Journaling with a single line of SQL.

Point-in-Time Recovery. Quickly revert the database to any second in time using journal archives. Journal Archives can be stored “off device” to provide a fast way to recover even if the backup hasn’t run.


InterBase’s Change Views reduces development time, network costs, and server CPU demand associated with other replication methods that rely on traditional change tracking methods. As a result, development teams benefit from cost savings, time savings, and improved user experience.

Log-less replication. InterBase’s Change Views eliminates common scalability issues associated with log tables and timestamp fields.

Secure Data Change Subscriptions. Once a device is granted rights and subscribed to specific tables or columns of data, it tracks what is changing at field level for that subscription. This simple model enables access to data changes to be securely managed and easily scaled out with less code to develop, refactor, build and test.

The Most Secure Change Tracking on the Market. Change Views not only makes it easy to identify what has changed, it controls who can track those changes and prevents others from even guessing at data changes.

Easily Fetch Data Deltas. Change Views provides just the field level delta of what has changed, allowing developers to give detailed analysis back to the end user while lowering data movement costs. Change View data can be queried via SQL before syncing to ensure you never end up with a surprise data bill.

What's new in InterBase 2020

InterBase is a powerful, zero-administration, small-footprint database engine that can power your server and even run on your mobile devices as an embedded database. The InterBase 2020 release adds a number of new features, including tablespaces support for InterBase, allowing for better performance on servers with multiple data storage options.

Database Tablespaces

Tablespaces support is the top new feature added in the InterBase 2020 release.

Tablespaces allow for better performance and more balanced and optimized use of the hardware. Tablespaces allow a database object definition to specify a storage location in a particular logical file collection. This is especially beneficial for disk technologies, allowing you to better mix the use of fast SSDs and large HDDs. This is a key difference, since prior to InterBase 2020, all of the files for a database had to be mapped to the same storage. A database administrator can leverage tablespace characteristics to optimize runtime database performance.

New OS Platforms Support

InterBase 2020 expands the OS platform support. Embedded InterBase (IBLite and IBToGo) is now available for Android 64-bit and macOS 64-bit. This allows RAD Studio developers to build InterBase enabled 64-bit Delphi applications and target both the Google Play Store and macOS App Store. The full list of supported InterBase 2020 IBLite and IBToGo platforms include Windows, macOS, Linux, Android and iOS. Supported platforms for InterBase 2020 Server Edition include Windows with macOS and Linux support coming later.

Enhanced Performance Monitoring

Performance Monitoring of index usage in InterBase 2020 gives you current statistics on what indexes are in use in the database, and how active they are for various queries (optimization, order by clause etc.). This expands on what we already provide in terms of monitoring statistics for various other entities like tables, stored procedures, triggers, attachments, transactions etc.

Data Dictionary DDL

Database tools can greatly benefit from a standard DDL syntax they can use to apply various descriptions to document the user's database schema.

New ALTER DESCRIPTION syntax allows you to describe any database entity (for e.g. table, index, stored procedure, generator etc.) in a standard (and independent) way without needing to embed the description as part of the entity definition.

SQL Optimizations

Transform inequality operators and not operators to their opposite representation for index based retrieval. Inequality operators, such as , >, >= can be transformed and optimized. For e.g. Conditions of the form NOT A>0 can now get transformed to A <= 0

More Features

Security Enhancements - OpenSSL upgrade

InterBase 2020 uses OpenSSL 1.0.2s across all platforms to avail recent vulnerability fixes from OpenSSL project.

IBConsole Improvements

InterBase 2020 comes with an enhanced IBConsole GUI for Windows. It supports the latest feature set including Tablespaces and Data Dictionary modifications and includes enhanced support for InterBase’s patented Change ViewsTM functionality. InterBase 64-bit Edition now includes a 64-bit native IBConsole application, that will allow larger datasets to be retrieved in the query window.

Additional Information