InterBase

Welcome to InterBase!

Embed, Deploy, Relax!

DocWiki

For complete online documentation visit the InterBase DocWiki

The InterBase 2017 release introduces several new features and enhancements

  • Language Enhancements with derived table, common table expressions, truncate table and single line comment support
  • Server wide monitoring of all online databases through a single connection
  • Change Views now support ALTER TABLE without rebuilding subscriptions
  • Various performance enhancements around SMP, Indexing and Sweep
  • New ODS version 17, iSQL reconnect command, new transaction isolation levels and a host of further improvements
View Whats New in and migration to InterBase 2017

Derived Tables and Common Table Expressions

Simplify SQL and shorten long running or complex queries into logical easy to understand steps with this new performant language feature

View Details »

Change Views

The Change Views feature allows you to quickly answer the question, "What data has changed since I last viewed it?"

View Details »

InterBase Quick Start

This Quick Start takes you step-by-step through the process of creating and using a database.

View Details »

ToGo Quick Start

A detailed tutorial covering how to get started with ToGo for all platforms. The InterBase ToGo database engine is embedded in applications - it does not have to be installed on any server or end-user workstation and it does not require that InterBase be installed.

View Details »

White Papers and Resources

Simplifying Data Change Tracking with InterBase Change Views

This whitepaper examines the traditional approaches used by developers for tracking changes and the associated difficulties faced. In this context, the paper outlines the value of Change Views and why it represents a brand new paradigm for tracking and moving data changes.

Top 5 Mistakes in Mobilizing Enterprise Data, and how to avoid them!

Many businesses today are looking to identify opportunities to increase efficiency in their business processes and to expand opportunity by using apps on mobile devices. While this is positive, organizations must manage the initiative correctly in order to minimize risk of failure, as getting it wrong can cost much more than just the initial budget allocated for the project; in both time and money, it can severely damage an organization’s reputation.

Choosing an ISV database

When it comes to choosing the right database to support your application it can feel like a daunting task. To make life easier, read online topics to consider to help when choosing the right database for you and your customers.

User Guides

For a complete list of browsable user guides for current and previous editions of InterBase, visit User Guides on DocWiki

API Guide

The API Guide provides information on developing InterBase applications using the InterBase API interface; programming with the InterBase API; working with databases, transactions, dynamic SQL, blob data, arrays, conversions, and service; installing/licensing APIs; exporting XML; handling error conditions; and the InterBase API function reference.

Data Definition Guide

The Data Definition Guide covers how to design and build InterBase databases including: specifying datatypes; working with domains, tables, and indexes; working with procedures, triggers, and generators; encrypting databases and columns; and character sets and collation orders.

Developer's Guide

The Developer’s Guide includes information on how to develop InterBase database applications using Embarcadero development tools, JDBC, and ODBC including: connecting to databases; understanding datasets; working with tables, queries, stored procedures, cached updated and events; working with UDF and Blob filters; importing and exporting data; working with InterBase Services; and writing install wizards.

Embedded SQL Guide

The Embedded SQL Guide gives instructions on developing InterBase applications using embedded SQL including: application requirements, working with databases, transactions, data definition statements, data, dates and times, arrays, stored procedures and events; error handling; dynamic SQL; and preprocessing, compiling, and linking.

Language Reference

The Language Reference Guide discusses each of the InterBase elements including: the SQL statement and function reference; procedures and triggers; keywords; error codes and messages; system tables, temporary tables, and views; and character sets and collation orders.

Operations Guide

The Operations Guide gives detailed instructions on working with InterBase databases including: using IBConsole; configuring and operating the InterBase server; network configuration; performing backups and restores; using journaling and journal archiving; database security; and interactive queries.