InterBase 2020 Lite/ToGo Edition

ISV, OEM, VAR Licensing

ISVs, OEMs, and VARs may want to embed InterBase with their applications, requiring a "silent install". This is possible by setting up a VAR agreement. Please contact Embarcadero Sales for more information on ISV, OEM and VAR licensing.

• Click here for Sales contact phone numbers
  
  
• Click here to contact Sales online
  
  

Non-OEM customers can buy InterBase licenses online

, buy InterBase licenses from an Embarcadero reseller partner

, or Contact sales

.

Trial Licensing
An InterBase Server Trial License allows you to test-drive and develop with InterBase for 90 days using up to 8 CPUs and 20 simultaneous users.

Download a 90-day free license of InterBase for Windows, Linux, Solaris
or Mac OS X >

Get the InterBase XE7 ToGo trial and experience InterBase as a mobile embedded database and how easy it is to distribute as part of your Android and iOS apps that you create with RAD Studio (Delphi and C++Builder).

Get a 30-day license of InterBase XE7 ToGo for Android and iOS in the RAD Studio trial >

Developer Edition Licensing
InterBase Developer Edition allows software developers to freely develop InterBase applications before they deploy them. All the functionality of InterBase Server Edition is included with Developer Edition.

Download the free, non-expiring InterBase Developer Edition for Windows, Linux, Solaris or Mac OS X >

Additional InterBase Licensing Information
You must purchase a Desktop license for each Desktop edition you plan to deploy.
You must purchase a ToGo license for each ToGo edition you plan to deploy.

An InterBase Server License activates the InterBase Server software and a license for 1 User connection or for the number of users based on the volume license purchased.
InterBase Server Edition licenses include support for up to 8 CPU cores. To add support for more than 8 cores on a single machine, additional licenses are required.

To purchase additional simultaneous user licenses to an existing InterBase Server installation, additional Simultaneous User Licenses can be purchased in the same quantities listed above to allow additional users to connect.

Each Simultaneous User License consists of a license certificate with a serial number. Entering and registering the serial number using the InterBase License Manager will add additional simultaneous user connections to the InterBase Server.

InterBase 2020 Released by Embarcadero
Marco Cantu
14 Nov 2019



Today, Embarcadero is announcing the release of a new version of its InterBase Relational Database Management System (RDBMS), called 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.

Technically this feature 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.

Selective tablespaces including active data can be backed up and restored as needed to minimize backup/restore time.

New OS Platform 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 currently in beta and 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" 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.

Additional Information
For more info, see the InterBase product page at: InterBase: Ultra-Fast Embeddable Database - Embarcadero