Transbase® Developer Support
Transbase® supports a range of standard interfaces, allowing existing applications to be easily ported to Transbase®. They also allow the use of Transbase® in many popular development environments.
Drivers for the popular ODBC and OLEDB interfaces not only provide direct access through these interfaces, but also allow the use of the ADO interface, which may be e.g. used in Visual Basic or Delphi applications. These interfaces enable the use of a number of popular database tools, especially in the Microsoft world.
The ADO.NET driver also provides .NET applications immediate access to Transbase®, directly supporting the data access structures and methods provided in the .Net framework.
The Transbase® JDBC driver allows you to easily build platform-independent applications in Java. The Hibernate framework is also supported.
There are interfaces available for the integration of Transbase® into Web Applications, which are created using PHP. These open, standardized interfaces make it easy to integrate the Transbase® Database System into many common development environments.
The application developer can choose from a variety of different programming interfaces.
Transbase® Call Interface (TCI)
The Transbase® Call Interface (TCI) is designed for C and C ++ programs and provides object-oriented access to database objects. It is available on all platforms supported by Transbase. As a proprietary Transbase® interface, it provides the most complete and direct access to all Transbase® features.
>>>>> Transbase® V. 8.1 available on even more platforms
As part of the change in the system architecture, the portability of Transbase® has again been significantly improved. Transbase® is now LSB 4.1 compliant.
As new platforms are available:
- Raspberry Pi
The following server platforms are supported:
- all Linux derivatives
- all BSD derivatives
- all Windows derivatives
- all Solaris derivatives
- Red Hat Enterprise Linux
Transbase® supports the currently established SQL standard [SQL 2 intermediate level] as well as some optional features from newer SQL standard versions. Because of the product features described, application developers can freely use any features defined by the SQL standard or easily port SQL applications from other database systems to Transbase®. This provides optimal investment protection for applications.
Transbase® can also use specific language extensions that go beyond the SQL-2 standard. The query language will be significantly enriched and thus facilitates the dynamic query generation in the application.
The WITH clause allows the definition of subtotals that can be used multiple times in the main query. This not only increases the clarity and comprehensibility of the query, but also improves the execution times in the rule.
Through iterative queries that are formulated using the CONNECT BY construct, many recursive evaluations can be formulated directly as SQL queries that would otherwise require an iterative evaluation by the application program or the definition of stored procedures.
With the help of the windowing functions, advanced aggregations can be formulated over a dynamically varying section of the result set of a query, such as moving averages.
>>>>> Transbase® V. 8.1 with important SQL-Enhancements
With Transbase® V. 8.1 we implemented some important SQL Enhancements and enabled them for all Transbase® operating modes:
- The INSERT statement has been enhanced with options that enhance its practical use.
- The INSERT OR IGNORE, INSERT OR UPDATE and INSERT OR REPLACE clauses are used to selectively treat tuples to be inserted with key collisions.
- The clause RETURNING (...) can be appended to the INSERT statement and returns a cursor over the inserted records. This is to return values generated during the INSERT, e.g. key values generated by AUTO_INCREMENT or DEFAULT values such as CURRENTDATE.
- As a new index type is now a SOUNDX available that summarizes different language variants, such. Müller, Miller and Muller.
- In general, indexing has been enabled for any functions, i. a secondary index may now be e.g. be defined by the sum of two fields or by functions on values.
- A new SQL function LAST_UPDATE returns the ID or timestamp of the last successful (committed) transaction.
Evaluate the new version of Transbase® for 60 days without obligation. Also visit our regular webinars.