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. InterBase 2020 Update 1 added a number of new features, including tablespaces support for InterBase server, new OS platform support for embedded versions, enhanced performance monitoring, SQL optimizations and more. 

InterBase 2020 Update 1

Today Embarcadero is releasing InterBase 2020 Update 1, which adds the following features: 

  • Linux support for InterBase 2020 Server and Developer Editions
  • Tablespaces support for the OnlineDump technology
  • Updated IBConsole support for Backup, Dump, and Restore operations of databases that use tablespaces
  • Performances improvements and fixes for defects reported by customers

Here are some additional links:

The installers for different platforms are available for download on the following trial and developer edition download pages:

This release continues to extend the power of InterBase 2020, along with continuing to focus on its reliability and stability.

Moreover, RAD Studio developers already have an InterBase developer edition license and also the ability to distributing IBLite or IBToGo with their mobile applications, depending if they are on the Professional or Enterprise edition

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” by the SQL optimizer to use index retrieval for better performance.

Security Enhancements

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 Views 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.

Phased Delivery

InterBase 2020 embedded versions and InterBase Server Edition for Windows are immediately available. Server editions for Linux and macOS will follow shortly.