TCL and MySQL

[dEViAtE]

Is there any TCL libraries to interact with MySQL?

I'm not satisfied with the current DupeCheckers so i've decided to go about coding my own using TCL and MySQL. I'm just curious if there is any way for TCL to interact with MySQL databases?

Any help is appreciated. :)

[cez]

http://www.xdobry.de/mysqltcl/

[darkone]

Btw. it's possible to have persistent connection to mysql server using itcl:

- Create initialization routine, that establishes connection to server. Store connection to UNIQUE GLOBAL variable (a good name for variable is ie. dupescript_mysql, where as mysql is a bad name)
- Call initialization procedure from init.itcl (init.itcl does not exist in standard installation: Create it under scripts subdir)

** Note that you will have X persistent connections to mysqld, where X is equal to amount of TCL intepreters defined in ioftpd's config **

You can also cache all procedures of your script:

- Split your script into two files, where first file contains only procedures (library) and second contains calls to procedures
- Load library file from init.itcl

by splitting it into two files (first file contains procedures and second contains only calls to those procedures)

[r0ddy]

http://www.fastbase.co.nz/fbsql/index.html

this one is nice too, i use it

[ViNcE]

i used it to make a dupe database, with unixtime, release type and release name.

Bot works fine for !pre <release> command etc...
It's fast too.

I approve it =)

[VolVE]

ViNcE,

Care to release your code? It sounds exactly what I was about to write myself. :)

-VolVE

[ViNcE]

lol :) send me a pm or something, that's not ioFTPD stuff... so leave me a pm we will try to talk somewhere on IRC ;)

Buy Buy