Interbase 2020



Embarcadero InterBase 2020 is a full-featured, high performance, encryptable, multiplatform and scalable relational database for developers who are looking to embed a low-cost, zero admin, lightweight secure database into their cross-platform connected applications. With InterBase you get powerful access control, data change management, disaster recovery and journaling, as well as support for popular database drivers for increased deployment flexibility.




New Features


What's New in InterBase 2020

InterBase multifile database may be interpreted as occupying a single primary tablespace. This tablespace presents a single logical collection of database pages numbered by their sequence in this collection. Starting with InterBase 2020 users can define other named tablespaces that present independent logical collections of pages. For more information refer to Tablespace

InterBase users prior to InterBase 2020 would execute a "UPDATE <system_table> SET RDB$DESCRIPTION=<blob_text> WHERE <entity_name>=<user_entity>", for each entity type. This requires the user to know the database system schema in detail for each entity type. The new DDL syntax takes away this complexity, and provides a new "ALTER DESCRIPTION FOR" syntax that is standard across all database entities supported by InterBase.

InterBase 2020 introduces "TMP$INDICES" a new system table included as part of the Performance Monitoring system tables. This table tracks all loaded indices per table in the database with key metrics for monitoring.

InterBase 2020 introduces the following enhancements to the IBConsole tool:

Performance Monitor
A new Indices tab that shows a table with details about indices.

Interactive SQL Window
•    Closing the Interactive SQL Window on a read only transaction no longer prompts a commit or rollback dialog, transaction is commited and the window closes.
•    Enhanced support for the RECONNECT clause, it now supports CACHE, lc_ctype and DIALECT.
•    A new Show tab, this tab shows information from isql SHOW statements
•    InterBase 2020 features support (Tablespaces, Alter Description DDL)
•    Change Views subscription context and coloring of change status
•    Syntax highlighting of queries
•    64-bit IBConsole.exe binary with 64-bit Edition of InterBase
•    Server-wide Performance Monitoring enhancements
•    WISQL SHOW commands


What's New in InterBase 2017

Tracking and managing data changes to multiple destinations has never been easier; just subscribe and query with SQL! InterBase's lightweight, secure and powerful embeddable kernel providing developers easy to integrate features including user security, synchronisation and disaster recovery into their applications today making data as easy as Embed, Deploy, Relax!

-Change Views
-Linux 64bit & RHEL 7 and Ubuntu Support
-64 Bit transaction ID's
-Fast Backup Format
-Incremental Data Dumps
-InterBase for Linux 32-bit
-IBLite for Android, iOS, Windows and OS X
-InterBase ToGo for Android and iOSInterBase ToGo for Android and iOS
-Tight integration with RAD Studio, Delphi and C++Builder for seamless deployment
-New 64 bit ODBC driver allows easy deployment on 64 bit platforms


Special Offers

Please visit Embarcadero Special Offer page


Additional information about Interbase

Data Sheet (PDF)

Interbase FAQ

Features Matrix (PDF)

Tech. Requirements

InterBase Developer Edition and Server Edition

Supported operating systems:

        Windows (64-bit, 32-bit):
            Windows 10
            Windows 8, 8.1
            Windows 7
            Windows Vista
            Windows Server 2019
            Windows Server 2016
            Windows Server 2012, 2012 R2
            Windows Server 2008, 2008 R2

        Linux (64-bit/32-bit):
            RHEL 7
            RHEL 6
            SuSE 11.3
            Ubuntu 14
            Ubuntu 16

        macOS (64-bit/32-bit):
            High Sierra (10.13)
            Sierra (10.12)
            El Capitan (10.11)

            InterBase XE is the latest release.

Supported processor architecture:

        Windows, Linux, and macOS
            Intel x86 or Intel x86-64


Hard disk space:

        Installation files: ~250MB (~350MB for Japanese version).
        Space needed for install:
            ~46 MB for Client Only installation.
            ~117 MB for Server and Client installation.

InterBase ToGo Edition

Supported operating systems:

        Windows (64-bit, 32-bit):
            Windows 10
            Windows 8, 8.1
            Windows 7
            Windows Vista
            Windows Server 2016
            Windows Server 2012, 2012 R2
            Windows Server 2008, 2008 R2

        Linux (64-bit/32-bit):
            RHEL 7
            RHEL 6
            SuSE 11.3
            Ubuntu 14
            Ubuntu 16

            High Sierra (10.13)
            Sierra (10.12)
            El Capitan (10.11)

            Nougat (7.x)
            Marshmallow (6.x)
            Lollipop (5.x)
            Android (4.x)

            iOS 10
            iOS 9
            iOS 8
            iOS 7

Server/Client Compatibility

InterBase 2020 server is certified to work with a compatible InterBase 2020 client. Since there are no breaking API changes, earlier versions of InterBase clients may work with the current version of the server also.

IMPORTANT! Mixing InterBase client and server versions is not supported. It is strongly recommended that compatible client and server versions are used for local connections on Windows.


License options

Interbase 2020 is offered in four editions to cover all needs;, IBLite, ToGo Edition, Desktop Edition and Server Edition

Server Edition
InterBase Server Edition is a cost effective, zero administration, and lightweight but powerful embeddable database for your business critical applications. As your organization grows, InterBase Server scales with you. InterBase Server allows hundreds of simultaneous users to connect to a single database. You can start with 8 CPUs/cores and a single user but can add up to 32 cores and unlimited users. In addition to providing local RDBMS capabilities, the server edition also allows remote connections for increased flexibility. InterBase server provides AES data encryption and SSL communication for more security and access control. Perfect for Enterprises, ISVs, OEMs and VARs who need to embed a database into their applications.

Supported platforms: Windows, Mac OS X, Linux and Solaris

ToGo Edition
InterBase ToGo Edition is a full-featured embeddable database that runs in a stand-alone environment but allows deployment of applications which directly utilize the InterBase engine DLLs. With no separate database server process running, the database engine executes in the application process space providing an extremely small footprint. Together with other key features such as high security, zero administration and simple installation, InterBase XE3 ToGo is an incredible solution for VARs, OEMs and ISVs.

Supported platforms: Windows, Mac OS X

Desktop Edition
InterBase Desktop Edition provides you with a great embeddable solution for stand-alone single user applications. Desktop Edition offers SQL RDBMS capabilities for local connection from multiple applications and scales to 4 CPUs/Cores while providing you with all the InterBase features including small operational footprint, AES data encryption for more security, high availability and performance, and zero administration. Perfect for small to mid size ISVs, OEMs and VARs who need to embed a database into their applications.

Supported platforms: Windows

IBLite Edition
Do you want a zero-admin, ACID compliant, lightweight and fast database that is run-time-royalty free? Would you like the flexibility to super charge the database even after deployment with powerful extras, such as encryption and additional diskspace? Ideal for free applications, and those applications that want to offer encryption as an extra, IBLite is a binary compatible version of InterBase ToGo that can easily be upgraded by simply changing the license file! IBLite is available with Delphi and C++Builder (Professional with Mobile and above), RAD Studio (all editions) and Appmethod.



Embarcadero support and help can be found at following links:

Embarcadero Support
Interbase Resource Center

It is possible to buy support and mainteance to all Embarcadero products.