InterBase 2017 is now available for installation directly into RAD Studio via GetIt for use in Delphi and C++Builder applications across Windows, macOS, iOS, Android and also for Linux.

While a Linux InterBase Server Edition has been available for many years with InterBase, the introduction of the new Delphi Linux compiler in 10.2 Tokyo has ensured the addition of Linux as a new platform supported by ToGo.

Adding InterBase ToGo to the RAD Studio IDE

To install ToGo, just open GetIt in the RAD Studio IDE, (Tools > GetIt Package Manager) and search for InterBase.

From there you can install both the InterBase 2017 Developer Edition server and also the InterBase ToGo libraries.

InterBase Server enables multiple connections to the same database either locally or over a network. InterBase ToGo is a dynamically loaded version of the InterBase engine that runs in process for local connections and data storage or to act as a client driver for a remote conenction.

License and Video

Watch the video and see how to add InterBase ToGo into your Delphi and C++Builder applications.

Click the link here for a free trial license of InterBase ToGo.

If you are new to Database Development, then check out Cary Jensen’s latest FireDAC book that uses InterBase in a lot of the examples.

New book – Delphi in Depth: FireDAC

There has been a growing stream of Delphi books in the last year covering everything from cross-platform development with FireMonkey to coding best practices around OOP. The latest book to be released is by long time Delphi Author Cary Jensen, specifically looking at database development with the cross-platform enabled FireDAC.

If you have been developing with Delphi for any amount of time, then you will probably know about Cary Jensen.  For those who don’t, Cary has written more than twenty-five books on software development, including some of the most popular works on ClientDataSets. Cary is an Embarcadero MVP and has been providing training, consultancy, and software development services since 1998.

Cary’s latest book, Delphi in Depth: FireDAC is now out and available covering 17 chapters about using FireDAC, the blazingly fast multi-platform database components from Embarcadero.

In Cary’s own words from his blog – this is the NEW goto book for database development with Delphi – and from a quick scan – I completely agree!

 I felt that this book should be more than just a FireDAC book. It should be a book that deserves to be on the shelf of every Delphi database developer. For the new Delphi database developer who is unfamiliar with the “Delphi way” of doing things, this book contains discussions of and demonstrations of the essential techniques that every Delphi database developer needs to know. This includes concepts like the TDataSet interface, the current record, and how to read to and write from TFields. (Just a note here, this book assumes you are using Delphi XE6 or later.)

Spanning over 500 pages, the book is full of examples, tips and techniques for making your database applications scream!

The book starts with an overview of the Features of FireDAC, 8 pages of high-level notes about the breadth of FireDAC – everything from Cross platform support, to ArrayDML, to DataType mapping and using LocalSQL (a very cool feature of FireDAC).

The book then helps you get started in the IDE and your applications before moving into the more advanced topics.

The other topics… see Cary’s blog. It’s well detailed. There are  17 if them, but in summary:
Chapter 1: Overview of FireDAC
Chapter 2: Connecting to Data
Chapter 3: Configuring FireDAC
Chapter 4: Basic Data Access
Chapter 5: More Data Access
Chapter 6: Navigating and Editing Data
Chapter 7: Creating Indexes
Chapter 8: Searching Data
Chapter 9: Filtering Data
Chapter 10: Creating and Using Virtual Fields
Chapter 11: Persisting Data
Chapter 12: Understanding FDMemTables
Chapter 13: More FDMemTables: Cloned Cursors and Nested DataSets
Chapter 14: The SQL Command Preprocessor
Chapter 15: Array DML
Chapter 16: Using Cached Updates
Chapter 17: Understanding Local SQL

InterBase inside

The book uses the IoT Award winning InterBase for the examples. InterBase is the cross-platform SQL database for Windows, macOS, iOS, Android and Linux.

To download the latest developer edition of InterBase for free click here.

InterBase XE7 – Update 7

InterBase XE7 update 7 is now available for general release. This is part of the active support of previous editions, for the latest long term support version of InterBase, see InterBase 2017.

The update is available for both Windows and Linux server-based Editions of InterBase XE7 and InterBase ToGo.  For help choosing the right edition of InterBase – view InterBase Product Editions

For notes on previous InterBase XE7 updates please select the links below

• Update 6
• Update 5
• Update 4
• Update 3
• Update 2
• Update 1

What’s in InterBase XE7 – Update 7?

Update 7 is a back port of specific updates and fixes in InterBase 2017. See full list here, including

• Update of OpenSSL.
• Fixes to avoid database corruption in extreme case
• Enhancements to 64bit Linux Installer
• Backup speed improvements when a  Change Views are in place.

Downloading latest InterBase XE7

Embarcadero CodeCentral “Registered Users” can download the patch binaries (Server/Desktop/Developer/Trial) for Windows and Linux, and, ToGo Edition. You can find the downloads at http://cc.embarcadero.com/reg/interbase

For new users, the trial and developer editions are available for free at http://www.embarcadero.com/products/interbase/downloads

Embed, Deploy Relax – InterBase 2017

Here we are in early 2017 fulfilling the promises we made back in November 2016 to deliver a new version of our award-winning InterBase RDBMS. We referred to InterBase 2017 as Project BigBang during development because of the positive impact InterBase is delivering. We have been listening to you, our customers. This result is created by delivering some of the most sought after features, ISV’s and Fortune 100 customers have been asking for such as SQL Derived Table Support, and Server wide performance monitoring to enhance the ability of existing applications to use InterBase as a back-end RDBMS, and that’s just the beginning.

I want to say a big thank you to those who have been personally involved in the beta program, your input is invaluable and is shaping the future developments and direction, including already planned content for Update 1.

InterBase 2017 New Features

A highlighted summary of InterBase 2017 new features includes. Continue reading InterBase 2017 – Now available →

Disclaimer: The information included in this roadmap does not constitute, and should not be construed as, a promise or commitment by Embarcadero to develop, market or deliver any particular product, feature or function. The timing and content of Embarcadero’s future product releases could differ materially from the expectations discussed here. Embarcadero reserves the right to change its product plans or roadmap at any time.

Overview

It’s been a busy couple of years since the last public roadmap. In that time, the patent pending Change Views feature has delivered some massive competitive advantage win stories to customers using InterBase XE7 and InterBase was nominated for and won the prestigious IoTA (Internet of Things Award) for “Most Innovative Use of Data”.

Following on from the previous public roadmap InterBase has been on the rise, and here we are sharing the current plans for the next release of InterBase in 2017.

Features and Technologies Delivered in InterBase XE7

The major features delivered in XE7 can be seen in the InterBase XE7 DocWilki

In summary:

• Change Views
• 64bit Linux Server added
• Performance Improvements
• 64bit Transaction ID’s – Allowing systems with the highest demand to run even longer
• New ODS restore feature
• OpenSSL upgrades
• Enhanced Journal Archive Management
• Service API’s for Online Dump and Journal Operations.

Features and Technologies Expected in InterBase BigBang

This week (15-Nov-2016) at CodeRage the hood was taken off a number of things that have been worked on in the labs for project BigBang. This project will ultimately become the next release of InterBase and includes:

• A focus on SQL Features
  • Derived Tables
  • Common Table Expressions
  • Truncate Table – A fast way to delete data
  • Transaction Wait Time
  • Exclusive Isolation Levels
  • ISQL scripting enhancements
• Faster core engine
• Server-wide Performance Monitoring
• New Platform Support
  • Latest Mobile & Desktop
  • InterBase ToGo on Linux

Ideas for the future.

InterBase releases are based on a specific On Disk Structure (ODS). The ODS helps manage new features and tells the InterBase engine what the database can do and what performance benefits it can take account of. This is one of the reasons is important to backup and restore when upgrading. – But what has this to do with the future?

Making mid-cycle ODS changes is something that we have been very reluctant to do with InterBase in the past because a change to the ODS will prevent you from using the database on an early version. E.g. if Update 2 had a newer ODS, then you would not be able to move back to Update 1 if you wished to.  With the changes added for managing ODS in the restore in XE7, we are now comfortable that if we need to, we could move up an ODS during a release cycle. This may pave the way to new features mid-release.

Ideas under review for the future include

• Auditing
• Scale Out / Load Balancing
• Even Smarter, Faster Engine
• More SQL features
• Change Views 2.0
  • Change views working on Views
  • Option for Backup / Restore (rather than DataDump)
• Enhanced Tooling (e.g. IBConsole)
• Enhance Drivers for 3rd Party Tools (e.g. More ODBC, JDBC, ADO.Net enhancements)
• Coded functions (enabling UDF capabilities with ToGo where platforms do not allow external libraries, e.g. iOS)

InterBase – The Ultimate Embedded Database

InterBase is the ultra-fast, scalable award winning multi-platform embeddable SQL database with commercial grade data security, disaster recovery and change synchronization.

Join me on the 28th July to explore why OEM, ISV and VAR’s the world over are using InterBase to:

• Secure their application data
• Improve their product with commercial grade features
• Support best practice in data protection
• Lower their support demands
• Reduce their cost and improve profitability

Register Now