Tech Info

RDDs
 
 
 
 

Replaceable Database Drivers

FlagShip fully supports the Replaceable Database Driver (RDD) architecture. This means, you may use another RDD  (e.g. own or from 3rd parties) instead, or in coexistence with the FlagShip standard database driver named DBFIDX.

The advantages of the default DBFIDX are:

• it is extremly stable and robust, optimized for the multiuser & multitasking use
• it supports data integrity checking (index vs. database), which 
• avoids any possible "index file corrupted" errors in your application.

However, there may be reasons why the use of other RDDs is desired. This may be the case if you need to use other index or locking structure (e.g. .cdx indices with FoxPro locking, .ntx for Clipper locking etc) or with very different database structure like SQL or ISAM. However, FlagShip provides you with the mechanism, but does not include other RDDs (or database engines), similarly as FoxPro, dBase etc. does not.

A full description of user defined RDDs is available in the FlagShip manual, an example of user defined RDDs is in the /usr/FSsrc/system/smallrdd directory on your system.

Free 3rd party RDDs available for FlagShip:

• FmySQL is a free toolkit for mySQL databases by Tore Van Grembergen available in source code (for Linux or for Windows), see also description here. 

 
• SQLmy is a free toolkit for mySQL databases by Alejandro Fernandez Herrero available in source code, see also description here on Web or on the ftp server.  Available also in extended, commercial version including support.

 
• Informix SQL: the free toolkit SQLifx-v0.06.tgz is available in source code by Alejandro Fernandez Herrero . See additional description here.

 
• PostgreSQL: a free toolkit "sqlkit_pg.tgz" by Thomas E. Griffin, see also short description here. Available also in the FlagShip distribution, see the /usr/FSsrc/tools/sqlkit directory.

 
• JustLogic SQL: a free toolkit "sqlkit_jlt98.tgz" by Thomas E. Griffin, see also short description here. Available also in the FlagShip distribution, see the /usr/FSsrc/tools/sqlkit directory.

 
• SolidServer SQL: a free toolkit "sqlkit_sol.tgz" by Thomas E. Griffin, see also short description here. Available also in the FlagShip distribution, see the /usr/FSsrc/tools/sqlkit directory.

 
• MS Cobol ISAM database: a free toolkit "rddcobol.tgz" by Oscar A. Carriles, see also short description here. Available also in the FlagShip distribution, see the /usr/FSsrc/tools/rddcobol directory.

 
• For an access of .cdx or .ntx indexes, .fpt memo fields and DOS locking algorithm, there is a RDDcb4 package available in the FlagShip distribution in the /usr/FSsrc/system directory. To be able to use it, you will need CodeBase by Sequiter, see details in the accompanying README file and in the support FAQs.

Please note: all the above packages are distributed "as is" by the author almost under the GNU General Public License or own license conditions (see details in README.* in the package). Although the packages are for free including source, you may obtain an additional support on paid basis directly from the author.

• FS-DBI (FlagShip Database Interface) is a library that provides access to different Relational Databases. Currently the PostgreSQL (7.2+) is available. Contact Inso Informatica for further information.


• Interbase RDD is also available from Inso Informatica including support.


• The RqRddFire by Ricardo Delamar Roque is an easy-to-use full RDD for FirebirdSS. Supports connect/disconnect directly to multiple databases on diferent machines, embedded converter to dbf <÷> fb, result sets and much more, see further details. Licensed per server, no user or connection limits. You may download (new 1.0.5 release) and test the free demo version.

• SQLmy commercial is an extended version of SQLmy, available by AllControl / Alejandro Fernández Herrero - see detailed description here

Refer also to general tools and add-ons for FlagShip

Last updated: 16-Feb-2008.