Go Back   FlashFXP Forums > >

Programming Need help with C/C++/Delphi? Ask here and make us all laugh.

Closed Thread
Thread Tools Rate Thread Display Modes
Old 06-27-2003, 12:04 AM   #1
Posts: n/a
Default TCL and MySQL

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.
Old 06-27-2003, 12:23 PM   #2
Junior Member
Join Date: Jan 2003
Posts: 29

cez is offline  
Old 07-05-2003, 07:16 AM   #3
FlashFXP Registered User
ioFTPD Administrator
darkone's Avatar
Join Date: Dec 2001
Posts: 2,230

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)
darkone is offline  
Old 07-05-2003, 08:24 AM   #4
Junior Member
Join Date: Apr 2003
Posts: 18


this one is nice too, i use it
r0ddy is offline  
Old 07-05-2003, 09:54 AM   #5
Junior Member
Join Date: May 2003
Posts: 25
Default re: r0ddy

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 =)
ViNcE is offline  
Old 07-05-2003, 04:11 PM   #6
Junior Member
FlashFXP Registered User
Join Date: Dec 2002
Posts: 14


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

VolVE is offline  
Old 07-05-2003, 05:11 PM   #7
Junior Member
Join Date: May 2003
Posts: 25

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
ViNcE is offline  
Closed Thread

curious, databases, interact, mysql, tcl

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 07:36 PM.

Parts of this site powered by vBulletin Mods & Addons from DragonByte Technologies Ltd. (Details)