Big Black Friday / Cyber Monday Super-Deal Shop Early

RAD Studio 12.2 Now Available! Learn more

Ready to take your apps to the next level? Upgrade to Enterprise today. Contact sales

See What's New in RAD Studio 12.2 Athens Watch the Replay

Delphi 12 and C++Builder 12 Community Editions Released! Learn more

InterBase 2020 Update 6, released! Learn more

Discover The Getit Page

Deep discounts available on InterBase 2020 for OEM or VARs – Contact sales

Renew your Update Subscription license now Read more

InterBase Version History

Ultrafast, scalable, embeddable SQL database with
commercial-grade data security, disaster recovery and change synchronization

What's new in InterBase 2020 Update 1

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. On top of this, InterBase 2020 Update 1 adds Linux support for Server and Developer Editions, Tablespace support for the OnlineDump technology, and updates to IBConsole


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.

InterBase 2020 Update 1 adds Tablespace support for the OnlineDump technology

Visit Embarcadero docwiki for a full list of 2020 and of 2020 Update 1 new features

Database Tablespace

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 and Linux.

Visit Embarcadero docwiki for a full list of 2020 and of 2020 Update 1 new features

New OS platforms support

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.

Visit Embarcadero docwiki for a full list of 2020 and of 2020 Update 1 new features

Enhanced Performance Monitoring

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.

Visit Embarcadero docwiki for a full list of 2020 and of 2020 Update 1 new features

Data Dictionary DDL

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

Visit Embarcadero docwiki for a full list of 2020 and of 2020 Update 1 new features

SQL Optimizations

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.

Visit Embarcadero docwiki for a full list of 2020 and of 2020 Update 1 new features

Security Enhancements - OpenSSL upgrade


Older Versions