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
dEViAtE
Guest
 
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
cez
Junior Member
 
Join Date: Jan 2003
Posts: 29
Default

http://www.xdobry.de/mysqltcl/
cez is offline  
Old 07-05-2003, 07:16 AM   #3
darkone
Disabled
FlashFXP Registered User
ioFTPD Administrator
 
darkone's Avatar
 
Join Date: Dec 2001
Posts: 2,230
Default

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
r0ddy
Junior Member
 
Join Date: Apr 2003
Posts: 18
Default

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

this one is nice too, i use it
r0ddy is offline  
Old 07-05-2003, 09:54 AM   #5
ViNcE
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
VolVE
Junior Member
FlashFXP Registered User
 
Join Date: Dec 2002
Posts: 14
Default

ViNcE,

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

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

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

Tags
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 09:57 AM.

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