Posted By: David Faust
The past year saw great strides in the c-treeRTG Ready-to-Go products. As a result of FairCom’s continuous development of this technology—and our strong commitment to future releases—the latest version of c-treeRTG BTRV Edition is available to power-up your Btrieve applications while adding SQL support.
The first release of c-treeRTG BTRV Edition focused on frequently-used Btrieve features. This release expands support for more of the features your applications need, such as new opcodes—including extended opcodes, collating sequences, on-the-fly CREATE indices, and support for exporting BTRV data dictionary files to c-treeACE format. In addition, the ALT and EXTTYPE_KEY Btrieve Key Flags are now supported, improving compatibility with existing Btrieve applications.
c-treeRTG V2 replaces Btrieve file handling with an enterprise-class data management system. With ACID transactions, real-time backups, and automatic recovery, it improves the performance, reliability, and data integrity of your application. Moreover, industry-standard SQL interfaces unlock your data to modern applications.
The Power of SQL in Btrieve
c-treeRTG V2 offers more than high-performance file handling: it provides the c-treeACE SQL database engine. Now you can take advantage of a full relational database without converting or duplicating your Btrieve data. By avoiding the overhead imposed by hybrid SQL implementations, c-treeRTG gives you direct, efficient access to your data.
c-treeRTG V2 unlocks the value of your Btrieve data with relational access through SQL, ODBC, JDBC, ADO.NET, etc. c-treeRTG makes your Btrieve data accessible to reporting programs, Business Intelligence tools, and analytical tools.
SQL Indices Improve Performance
c-treeRTG V2 allows you to create a SQL index on your Btrieve tables by executing CREATE INDEX on imported tables or using the graphical c-treeACE SQL Explorer.
This feature is useful on Btrieve indices that do not lend themselves to SQL conversion, which can cause slow query performance. You can create a SQL index on desired fields to speed up these SQL queries. It is not necessary to replace every Btrieve index, simply replace those that are needed for performance.
As another benefit, the index returns rows sorted in logical order as opposed to binary order as is the case for Btrieve indices.
SQL Explorer Lets You Manage Your Data
You will want to monitor and manage your sqlized data—and that means seeing it the way it appears to SQL applications. c-treeRTG V2 includes the graphical SQL Explorer tools to view and manipulate your data, providing comprehensive management capabilities. These tools, now available in c-treeRTG, also allow you to execute SQL statements and SQL scripts, including options for viewing the execution plans.
SQL Access Leverages the Value of Your Data
With SQL access, c-treeRTG V2 makes your data available to the industry’s latest reporting applications, Business Intelligence tools, and web-based languages such as PHP. The insights you gain once you have access to your data may be the most valuable benefit of all.
The Power of PHP7 Data Objects
PHP has become the language of choice for database-driven web pages and websites. In version 2, c-treeRTG improves its PHP connectivity by adding support for PHP7 and PHP Data Objects (PDO). PDO gives you an abstraction layer so your applications use the same functions regardless of the underlying database. Developers using PDO do not have to concern themselves with database-specific commands so they can focus on application coding and logic.
FairCom c-treeACE PHP offers native PDO support by including a driver to access the c-treeACE Server. Developers who have an existing PHP application that uses PDO can upgrade their application to c-treeRTG by simply changing the driver—no re-coding should be required. Finally you have database independence!
The Power of Connection
c-treeRTG V2 integrates with your legacy applications and connects them to the modern world, so it empowers your applications in two ways:
- Integration with Your Application – c-treeRTG connects your Btrieve application to the robust FairCom client/server technology. This release brings you increased stability, high availability, and scalability by adding ACID transactions, real-time backups, and automatic restores.
- Integration with Other Applications – c-treeRTG makes SQL interfaces available for your Btrieve data. This release connects your data to the world of reporting and analytical tools.
Not only does c-treeRTG V2 connect you to other applications, it is your gateway to a wide array of supported platforms. By moving to c-treeRTG, your Btrieve application can easily support additional platforms such as Unix, Linux, and Mac OS X.
With connected data, the possibilities are countless.