DataController rc1.05
This release is one of the stable version with an easy installation procedure.
README provide the information on how to create tables and what is supported basically.
Linux and Windows Requirements (Installation Packages or RPM's) :
MySQL-server-
MySQL-shared-
mysqlclient
oracle-
oracle-
boost
boost-devel
Windows:
Please read COMPILE.windows.txt from the tar ball release.
Linux :
- Compiling and Installations
1. sh install.sh clean # Will clean any dependencies
2. sh install.sh build # Build the MySQL Plugin
3. sh install.sh install # Will check for the completion of the Build and Copy Appropriates files
Once step 1,2,3 have been completed, restart MySQL and execute the following command :
mysql -u root
mysql> INSTALL PLUGIN datacontroller SONAME 'libdatacontrol
mysql> exit;
Milestone information
- Project:
- DataController
- Series:
- mysql5.1
- Version:
- rc1.05
- Released:
- Registrant:
- Francis Lavalliere
- Release registered:
- Active:
- Yes. Drivers can target bugs and blueprints to this milestone.
Activities
- Assigned to you:
- No blueprints or bugs assigned to you.
- Assignees:
- No users assigned to blueprints and bugs.
- Blueprints:
- No blueprints are targeted to this milestone.
- Bugs:
- No bugs are targeted to this milestone.
Download files for this release
Release notes
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(
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`
) ENGINE=
#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`
) ENGINE=
#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`
) ENGINE=
#This will connect as USERNAME and will try to access [DATABASENAME]
#If the schema is not [dbo], you can add another /schema/
before the Table just like this :
CONNECTION=
#This will connect as USERNAME and will try to access [DATABASENAME]
#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
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://
Oracle : OCI Libraries http://
Boost : Boost Libraries http://
=======
#######
# 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://
#
# Provided by TheAce Solutions visit us and make donations at
# http://
# http://
#######
Changelog
0 blueprints and 0 bugs targeted
There are no feature specifications or bug tasks targeted to this milestone. The project's maintainer, driver, or bug supervisor can target specifications and bug tasks to this milestone to track the things that are expected to be completed for the release.