InterBase

Welcome to InterBase!

Embed, Deploy, Relax!

DocWiki

For complete online documentation visit the InterBase DocWiki

The InterBase XE7 release introduces several new features and enhancements

  • Change Views allows you to look at the data that changed since last viewed
  • Linux 32-bit and 64-bit kits are now available
  • Various performance enhancements including SMP performance, dump enhancements, and improved Read Committed Transaction Processing
  • New ODS version 16 supporting Change Views and the new Index Managers.
View Whats New in InterBase XE7

Change Views

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

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 »

InterBase Quick Start

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

View Details »

InterBase VAR License Portal

This comprehensive quick start steps through the process of getting started with InterBase as a Value Added Retailer.

View Details »

White Papers

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.

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.