| sqlayinmysql(1) | SqLay Suite | sqlayinmysql(1) |
sqlayinmysql - a MySQL database driver for sqlay.
libsqlayinmysql.so
[sqlaytool] [options] mysql:datasource
sqlayinmysql is the MySQL driver for sqlay. It supports DML read-write and DDL. It interpretes a datasource feeded in the form of a mysql: URL allowing to connect to a MySQL server.
It has been developped initially with MySQL 4.0.4, is now tested mainly with 4.0.16, but is known to work with MySQL 3.23.x.
The driver is loaded by giving as argument to the sqlaytool front-end executable a mysql: URL.
The mysql: prefix could be replaced by a colon alone (:) if the tool has been compiled with this driver as default driver or if it is the current value of the environmen variable SQLAYDRIVER.
The driver detects table names, field names, commonly used datatypes with their length and precision, null and not null flags, unique and non-unique indexes, primary keys and - for InnoDB tables - foreign keys, a count of data by table or view, some grants (see below).
It does not detect comments on tables, nor default values.
Also it could not detect views nor comments on columns, inexisting in MySQL up to 4.0.X.
As for the grants, only part of the grants on tables are detected, only if logged in as user having select right on mysql.db: insert, select, update, delete or all. Create, alter, drop, reference, index and grant are not detected for themseleves but are taken into account (except for the grant privilege) to set the 'All' flag.
Also, those grants are not checked for consistency with connection possibility,...
Server connection, database wide, host and column based permissions are not checked.
As other input drivers for sqlay, the only connection available for now is a shared connection.
Pls understand that this is an alpha release and none of the executables is securized against buffer overflows, and so on. It is also not thread safe.
See the NOTE above for important security warnings.
E. Lurquin <sqlay@hitud.net>
sqlayin(1), sqlay(1), sqlsc(1), sqlds(1), mysql(1), mysqlaccess(1)
| sqlayinmysql 0.8 | Dec 2008 | sqlayinmysql(1) |