Embarcadero InterBase 2020 Update 1 (x86/x64)

Embarcadero (a division of Idera, Inc.), a provider of cross-platform application developer productivity tools, announced InterBase 2020 Update 1, the latest release of its flagship database management system including support for tablespaces.

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

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.

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.

INTB-3809 IBConsole Database Online Dump with tablespaces not working when targeting a named InterBase instance (not default)
IBB-16 INTB-3789 Backup of primary tablespace gives an error
INTB-3785 Cannot restore database backup coming from ODS 18 to ODS
SF Case 784575 INTB-3775 InterBase server crash on attach database
INTB-3769 Change Views query with LEFT OUTER JOIN returning with SQLIND_INSERT set for generated RHS table record
IBP-127INTB-3758 Starting IBMGR changes service name to include XE7
INTB-3755 InterBase hangs when performing an online dump
SF Case 770527 INTB-3753 Restore of PRIMARY tablespace not possible
SF Case 774492 INTB-3752 InterBase crashes on receiving WM_DEVICECHANGE message on Windows
INTB-3742 IBConsole WISQL data grid font not changing as per Edit | Font selection
INTB-3743 Install launcher on Windows has wrong URL to "Setup Information" and Readme
INTB-3746 InterBase 2020 PDF documentation is still 2017 version
SF Case 766141 INTB-3732 IBServer crash on update online dump
SF Case 766570 INTB-3738 Derived table using ROWS key word delivers wrong result set
INTB-3719 InterBase server hangs when connecting to a database file following a failed drop database operation on the same database
SF Case 761090 INTB-3718 Customer reports InterBase crash dump is not getting delivered on server crash
INTB-3716 "partner index description not found" error when foreign key table resides in another tablespace
SF Case 764447 INTB-3713 Server crash on using sample UDF BLOB_LINECOUNT
SF Case 670588 INTB-3503 Installanywhere installer configures Guardian service startup to manual
InterBase is a light, ultra-fast, embeddable SQL database with commercial grade data security, disaster recovery and change synchronization. The solution leverages multi-core CPUs and multi-CPU systems, along with a unique versioning approach and advanced disk I/O caching to retrieve and update data quickly. With a small footprint and fast install, it is ideal for use in mission-critical contexts such as patient management, railways, medical labs, multi-national POS, CRM, and emergency response systems.
Embarcadero Webinar: InterBase 2020

Embarcadero builds tools that solve productivity problems for application developers. The company’s products allow users to design, build and run applications from a single code base across all platforms. Ninety of the Fortune 100 companies and a community of more than three million C++ and Delphi users worldwide rely on Embarcadero’s award-winning products to deliver critical enterprise applications. Embarcadero is a division of Idera, Inc.

Product: Embarcadero InterBase
Version: 2020 Update 1 (version 14.1.0.220) *
Supported Architectures: 64bit / 32bit
Website Home Page : http://www.embarcadero.com

Language: english
System Requirements: PC **
Supported Operating Systems: **
Size: 395.4 mb

Keygen activates:
InterBase 2020 Server
InterBase 2020 Server Edition is a cost effective, zero administration, and lightweight but powerful embeddable database for your business critical applications. As your organization grows, InterBase 2020 Server scales with you. InterBase 2020 Server allows hundreds of simultaneous users to connect to a single database. Every base InterBase Server Edition license includes support for up to 8 CPU cores and 1 user. You can add Additional CPU licenses (8 cores each) for up to a total of 32 cores and you can add Additional Simultaneous User Licenses for 1 to 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.
InterBase 2020 ToGo Edition
InterBase 2020 ToGo Edition is a full-featured, multi-device embeddable database for Windows, Linux and macOS 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 2020 ToGo is an incredible solution for VARs, OEMs and ISVs.

InterBase Developer, Desktop and Server Edition (only Windows)
Supported operating systems:
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
Supported processor architecture: 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 (only Windows)
Supported operating systems:
Windows 10
Windows 8, 8.1
Windows 7
Windows Vista
Windows Server 2016
Windows Server 2012, 2012 R2
Windows Server 2008, 2008 R2