DataController rc1.05

Stable, efficient, easy install.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1. Indexes / Primary keys

Only table with Primary keys were tested and validated no other indexes.

Primary Key is used on

JOIN / INNER JOIN / LEFT JOIN..., where Clauses

If you do not specify any Primary Key, the JOIN will

still work but you might face some performance issue.

2. Supported / Unsuppored MySQL Commands

Unsupported :

Alter commands are not supported.

You better of dropping the Table and Recreating it.

All non-MySQL functions unique to MySQL/Oracle/MSSQL.

If you need some commands that are unique to MySQL and not allowed in the remote database, you will need

to add a sub select around it... example :

select t1.FIELDS, CONCAT(t1.FIELDA,'t1.FIELDC')

as TESTCONCAT from

(select FIELDS, FIELDA, FIELDC from MSSQLTABLE) t1

Limit works but not implemented yet on remote system.

MySQL Will do the limit filtering, but will still have to read all data on the remote database.

Supported :

Pretty much All DML statements...

SubSelects, Multiple Sub Selects, Group By, Order By

CREATE TABLE .. AS SELECT ..

Will create the table locally in `MyISAM` or

the default MySQL Engine.

INSERT INTO TABLE ... SELECT ....

3. How to Connect to a Oracle Server?

create table `tablename` (

`fieldname` filedtype default values,

`fieldname` filedtype default values,

`fieldname` filedtype default values,

..

..

primary key(`fieldname`,`fieldname`)

) ENGINE=DataController CONNECTION="oracle://username:password@serveripaddress:1521/INSTANCENAME/Table"

#This will connect as USERNAME and will try to access USERNAME.Table

#The Primary Key is optimized for any dml, and also if you join an oracle table with a mysql or mssql table.

4. How to Connect to another MySQL Server?

create table `tablename` (

`fieldname` filedtype default values,

`fieldname` filedtype default values,

`fieldname` filedtype default values,

..

..

primary key(`fieldname`,`fieldname`)

) ENGINE=DataController CONNECTION="mysqlfed://username:password@serveripaddress:3306/DATABASENAME/Table"

#This will connect as USERNAME and will try to access DATABASENAME.Table

#The Primary Key is optimized for any dml, and also if you join an oracle table with a mysql or mssql table.

5. How to Connect to a MS SQL Server?

create table `tablename` (

`fieldname` filedtype default values,

`fieldname` filedtype default values,

`fieldname` filedtype default values,

..

..

primary key(`fieldname`,`fieldname`)

) ENGINE=DataController CONNECTION="mssql://username:password@serveripaddress:1433/DATABASENAME/Table"

#This will connect as USERNAME and will try to access [DATABASENAME].[dbo].[Table]

#If the schema is not [dbo], you can add another /schema/

before the Table just like this :

CONNECTION="mssql://username:password@serveripaddress:1433/DATABASENAME/Schema/Table"

#This will connect as USERNAME and will try to access [DATABASENAME].[Schema].[Table]

#The Primary Key is optimized for any dml, and also if you join an oracle table with a mysql or mssql table.

================================================================

Data Controller Is Under GNU GPLv2, Licence information is provided in theacesolutions.licence within the compressed file.

Data Controller design was based using verry small section of the Federated / CSV MySQL Engine as reference.

Data Controller uses 3rd Party Open Source Software under LGPL.

The three opensource projects are :

  MS SQL : FreeTDS available at http://www.freetds.org/

  Oracle : OCI Libraries http://orclib.sourceforge.net/

  Boost : Boost Libraries http://www.boost.org/

================================================================

##########################################################################
# This file only gives you the documentation on what is supported
# and how to connect to other Databases using the
# DataController Plugin
#
# Developers can suggest new code on launchpad
# http://www.launchpad.net/datacontroller
#
# Provided by TheAce Solutions visit us and make donations at
# http://www.theacesolutions.com/
# http://www.datacontroller.org/
##########################################################################