'''What:''' XDobry '''Where:''' http://www.xdobry.de/xosql '''Description:''' XOSql is [XOTcl] general wraper for many tcl sql interfaces. It was primary used to provide db independent sql access in projects [XOTclIDE] and [xdobry]. It do not try do implement new genaral low level access but reuse known tcl sql interfaces Updated: 01/2004. Contact: mailto:mail@xdobry.de ([Artur Trzewik]) Supported tcl sql interfaces: 1. [mysqltcl] 1. [tclodbc] 1. [PostgreSQL] throw pgtcl 1. [sqlite] Features: 1. introspection of connect parameters 1. schema queries (getTables) 1. tk connecting dialog 1. really oo interface. queries are XOTcl objects Sample interactive XOSql usage % package require XOTcl 1.1 % namespace import xotcl::* % package require xdobry::sql 0.55 % Sqlinterface loadInterface mysqltcl MySql % MySql create mysql ::mysql % mysql getconnectargs {hostname text localhost} {socket text {}} {port integer 3306} {user text {}} {password password {}} {dbank text {}} % mysql connect {user root dbank xotcllib} 1 % mysql getTables Component ComponentObject ComponentRequire Configmap ConfigmapChildren ConfigmapComponent Info Method Mysequence Object ObjectMethod Userlib % mysql query {select * from Component} ::mysql::__#0 % ::mysql::__#0 rows 436 % ::mysql::__#0 columnNames componentid name defcounter basedon timestamp versioninfo isclosed userid infoid % ::mysql::__# fetch 46 xdobry::FormServer 1 {} 20011017183902 {[import] 1.0} 1 1 {} % ::mysql::__#0 destroy % mysql disconnect 0