Embarcadero InterBase 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, and support for popular database drivers for increased deployment flexibility.
InterBase is used by organisations to develop and deploy robust and secure database applications, this is a popular choice among developers and organisations that are looking for an efficient and reliable database management system.
Everything a SQL Database should be
Attacks on databases and data loss can be costly and lead to loss of customers’ trust (and business), regulatory action, and heavy fines. InterBase provides over-the-wire and at-rest encryption, separate security login, and role-based user security. InterBase maintains full on-disk encryption while adding negligible overhead to database speed and performance.
InterBase is one of the fastest native databases available, with a small, lightweight footprint. InterBase leverages today’s multicore CPUs and multi-CPU systems, combined with a unique versioning approach and advanced disk I/O caching, to retrieve and update your data blazingly fast.
Your app and business run on data, making database disaster recovery a critical feature. Interbase supports effective disaster recovery planning through live backups, incremental dumps, multithreaded restore, write-ahead logging, and point-in-time recovery. The database can be backed up via the command line, our admin tools, via code using the backup APIs, or the ODBC driver GUI.
InterBase’s Change Views feature reduces development time, network costs, and server CPU demand associated with other replication methods that rely on traditional change-tracking methods. As a result, development teams benefit from cost savings, time savings, and improved user experience.
InterBase is an SQL standards-compliant database. InterBase strictly follows SQL industry standards. It supports Unicode and is ideal for any character set globally. It offers multiple-join Unicode, real-time event alerts and our patent-pending Change Views’ SQL-based change tracking.
What’s new in 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.
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
ALTER DESCRIPTION Support
InterBase users prior to InterBase 2020 would execute a “UPDATE SET RDB$DESCRIPTION= WHERE =”, 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:
Interactive SQL Window
System requirements for InterBase
InterBase Developer Edition and Server Edition
Supported operating systems for InterBase:
Windows (64-bit and 32-bit)
Linux (64-bit and 32-bit)
macOS (64-bit and 32-bit)
Supported processor architecture
Windows, Linux, and macOS
- Intel x86 or Intel x86-64
Hard disk space
InterBase ToGo Edition
Supported operating systems
Windows (64-bit and 32-bit)
Linux (64-bit and 32-bit)
InterBase 2020 server is certified to work with a compatible InterBase 2020 client. Since there are no breaking API changes, earlier versions clients may also work with the current version of the server.
Interbase 2020 is offered in four editions to cover all needs; IBLite, ToGo Edition, Desktop Edition and Server Edition.
InterBase Server Edition is a cost-effective, zero administration, lightweight, but powerful, embeddable database for your business-critical applications. As your organisation 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 allows remote connections for increased flexibility. The 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 in InterBase
InterBase ToGo Edition is a full-featured embeddable database that runs in a stand-alone environment but allows deployment of applications which directly utilise 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, verion XE3 ToGo is an incredible solution for VARs, OEMs and ISVs.
Supported platforms: Windows, Mac OS X
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 features, including a 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
Do you want a zero-admin, ACID-compliant, lightweight and fast database that is run-time-royalty free? Would you like the flexibility to supercharge the database even after deployment with powerful extras, such as encryption and additional disk space? 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.
See the Feature Matrix for a more detailed comparison.
It is possible to buy support and maintenance with all Embarcadero products. Embarcadero support and help can be found at the following links:
Alfsoft provides technical first-line support to all Embarcadero customers. Please describe your problem as detailed as possible when contacting our support. Remember to always inform about your product version and your operating system (both platform and version). You find instructions for support here (https://www.alfasoft.com/en/support.html).