Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
DatabaseNews

Introducing InterBase for .NET – A Super-Secure Embedded Data Warehouse For .NET Users

0006

Hello everyone and welcome to InterBase RDBMS! This is the first blog post of a series that introduces the InterBase multiplatform database to .NET developers. The idea is to present InterBase to the .NET community, ranging from an overview of what InterBase is, installation and configuration, connecting to InterBase from .NET and how to deploy InterBase – not only in the client/server model, but also embedded in your app.

A Brief History

InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies, an Idera Inc. company.

InterBase was one of the first enterprise-grade relational databases ever produced. Since its inception it is based on a superior versioning architecture still unmatched by many popular databases. It was also the first DBMS to implement Multi-Version Concurrency Control (MVCC). MVCC is referred to as Multi-Generational Architecture in InterBase.

To make a long story short, InterBase was invented in the 80s by Jim Starkey, than sold to the (famous by that time) dBase product owner Ashton-Tate, which in turn become part of Borland circa 91. Fast forward, the Borland dev tools division become part of Embarcadero in 2008, and – finally – Embarcadero become part of Idera Group in 2015, and here we are!

Read this article to know the latest updates on the dot NET framework or any upcoming successors and its features.

InterBase Versions

InterBase remains in continuous development since his inception, and each new release brings a set of new features, but always aligned with the mission to maintain 100% backward compatibility and provide no-friction migrations.

Curious fact:
– Around the 2000s Borland decided to open-source the InterBase database, giving birth to Firebird, the open-source incarnation of InterBase 6.0. Right after that Borland made a turnaround and began releasing new commercial versions of InterBase. Today InterBase and Firebird are very different databases and not compatible between each other anymore, as InterBase introduced many new features that are not present in Firebird.

Below there is a table showing the InterBase versions after 6.x, as well the official support status for each one:

Product Active Passive De-Supported
InterBase 2020 December 2019
InterBase 2017 March 2017 December 2019
InterBase XE7 December 2014 June 2017 December 2019
InterBase XE3 September 2012 April 2015 March 2017
InterBase XE September 2010 September 2013 December 2014
InterBase SMP 2009 September 2008 September 2010 September 2013
InterBase 2007 November 2006 November 2009 January 2013
InterBase 7.5 November 2003 December 2006 November 2008
InterBase 7.1 November 2002 December 2006 June 2007
InterBase 6.x March 2001 December 2006 June 2007

* source: https://docwiki.embarcadero.com/Support/en/Supported_Versions

InterBase Editions

InterBase offers the following editions:

  • IBLite = free/embedded with some limitations
  • InterBase ToGo = embedded with no limitations
  • InterBase Server = full client/server that scales up to 32 cores
  • InterBase Desktop = similar features from the Server edition but localhost only
  • InterBase Developer = free/similar features from the Server edition but for development only

Below you can see a comparison of the different editions available on InterBase.

Attribute Description IBLite InterBase ToGo InterBase Desktop InterBase Server InterBase Developer
Platforms windows-android-2418766linux-7965920ios-apple-7544554 windows-android-2418766linux-7965920ios-apple-7544554
win-icon-7511506
win-icon-7511506 linux-7965920 win-icon-7511506 linux-7965920
Licensing of CPU Cores 1 4 4 8 8
Maximum simultaneous users 1 1 1 1 to Unlimited 20
Number of connections per user 1 8 8 4 4
Access local database from clients on remote systems
20px-check-4242780
20px-check-4242780
Connect to server hosting database on remote systems
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
TCP listening server
20px-check-4242780
20px-check-4242780
Strong (256bit AES) database and column encryption No encryption
20px-check-4242780
20px-check-4242780
20px-check-4242780
No Strong Encryption
Strong network (SSL) encryption No encryption
20px-check-4242780
20px-check-4242780
20px-check-4242780
No Strong Encryption
Able to import add-on licenses
20px-check-4242780
20px-check-4242780
Database file size limitation 100MB No limit No limit No limit No limit
Simultaneous Transactions per Connection 1 No limits No limits No limits No limits
Change Views
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
Services API Enabled
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
OTW/SSL Support
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
Metadata Updates (ddl operations)
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
External Table Access
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
Performance Monitoring
20px-check-4242780
20px-check-4242780
20px-check-4242780
Journaling and Journal Archives
20px-check-4242780
20px-check-4242780
Requires a server restart every 48 hours
20px-check-4242780
Available connectivity drivers from RAD Studio (FireDAC and IBX)
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
Point-in-time-recovery of data, with database restoration based on timestamp for greater recovery flexibility between physical backups
20px-check-4242780
20px-check-4242780
Available for deployment
20px-check-4242780
20px-check-4242780
20px-check-4242780
20px-check-4242780
Zero-install, embedded database as a library, just link to access database
20px-check-4242780
20px-check-4242780
Tablespace support
20px-check-4242780
20px-check-4242780
20px-check-4242780
Embedded InterBase available for Android 64-bit and macOS 64-bit
20px-check-4242780
20px-check-4242780
Other connectivity drivers: ODBC, JDBC, ADO.NET, PHP+
20px-check-4242780
20px-check-4242780
20px-check-4242780
Command line tools for development, administration and validation
20px-check-4242780
20px-check-4242780
20px-check-4242780

Core InterBase Features

InterBase has an interesting list of features that we’ll explore along the upcoming posts in detail, but I’d like to highlight here the ones that for me sets InterBase apart from other options in the market.

  • Single on-Disk Format 
    • InterBase single-file format allows you to deploy your applications anywhere. A unified on-disk format allows fast support and testing directly from your development machine. No changes in the metadata or the database at all when moving between platforms.

  • Security: 
    • InterBase supports encryption over the wire between server and clients, and data at rest (both DES and AES 256-bit encryption). InterBase encryption is built in as part of its cross-platform single file format.
    • Built-in granular column-level encryption drastically reduces risk of data breaches through requirement changes and product refactoring as your data layer (and not your application) manages data visibility.
    • InterBase also supports a backup-specific encryption key that allows an encrypted backup to be created and answers the needs of those requiring command-line backups to be run via scheduling
  • Admin-Free Operation
    • InterBase will just run and run and run! Even with the hardest working databases processing 10,000+ transactions each second, it could be years before you need to backup and restore the latest InterBase database server. InterBase servers are so good at being admin-free, the Mars rover used a copy on Mars (it is too far to send a DBA!).
    • InterBase also offers a range of failover capabilities, including incremental backups, journals, point-in-time recovery, and database shadowing.
  • Log-less Replication
    • InterBase Change Views eliminates common scalability issues associated with log tables and time-stamp fields.
    • Change Views not only makes it easy to identify what has changed, it controls who can track those changes and prevents others from even guessing at data changes.

Success Stories

To wrap up this first post I’d like to share some of success cases we have recorded recently with InterBase. There are many others but I do think the ones below will give you an interesting perspective of what InterBase can do for you:

Resources

Do you want to try Embarcadero’s Cross-Platform Development Framework? InterBase is an ultrafast, scalable, embeddable SQL database with commercial grade data security, disaster recovery, and change synchronization. Request a free full trial here.


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

About author

Lead Software Consultant, LatAm

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES