FBSQL

fbsql (or "fastbase sql", by Peter Campbell) is a Tcl extension that provides an interface to MySQL.

fbsql's last release was in 2003. More up-to-date bindings can be found in tdbc and mysqltcl.

Description

fbsql uses the Tcl Object interface.

Silas: Windows version requires libmysql.dll, that you have to put in the same directory of fbsql.dll, which is possible to download from fbsql oficial website.

with Win32 binaries, .c source "should also compile on Unix platforms with some minor modifications". Solaris tarball provided. (An attempt to use FBSQL met with frustration... I can't get the fbsql.dll at http://www.fastbase.co.nz/fbsql/index.html to load into ActiveTcl 8.4.5. --Chris Nelson 2004-01-29)


On FreeBSD 7, if MySQL and TCL are installed through a port, use this as Makefile (replace tcl8.6 by your TCL version folder):

# path to libmysqlclient.a :
MYSQLLIBDIR = /usr/local/lib/mysql
# path to header files of mysql:
MYSQLINCDIR = /usr/local/include/mysql
# path to header files of mysql:
TCLINCDIR = /usr/local/include/tcl8.6
# a different compiler :
CC = gcc
PIC = -fPIC
INCLUDES = -I/usr/local/include -I$(MYSQLINCDIR) -I$(TCLINCDIR)
CFLAGS += -Wall $(PIC) $(INCLUDES)

# For Solaris8 :
LDFLAGS =  -lz -G -L $(MYSQLLIBDIR) -l mysqlclient

all:    fbsql.so

fbsql.so: fbsql.o
       $(LD) -o $@  $<  $(LDFLAGS)

clean:
       -rm -f core *.o

clobber: clean
       -rm -f fbsql.so

=============FBSQL.SO FREEBSD 4.9 USE THIS MAKEFILE============
#changed by bertholdo
#needs tcl8.3
# path to libmysqlclient.a :
MYSQLLIBDIR = /usr/local/lib/mysql
# path to header files of mysql:
MYSQLINCDIR = /usr/local/include/mysql
# don´t forget mysql-3.22.26a.tar.gz for example from www.sunfreeware.com :
#MYSQLINCDIR2 = /home/users/wbo/projects/Tools/mysql-3.22.26a/include
# a different compiler :
CC = gcc
PIC = -fPIC
INCLUDES = -I/usr/local/include/tcl8.3/ -I/usr/local/include -I$(MYSQLINCDIR) -I$(MYSQLINCDIR2)
CFLAGS += -Wall $(PIC) $(INCLUDES)

# For Solaris8 :
LDFLAGS =  -G -L $(MYSQLLIBDIR) -l mysqlclient 

all:    fbsql.so 

fbsql.so: fbsql.o
       $(LD) -o $@  $<  $(LDFLAGS)

clean:
       -rm -f core *.o

clobber: clean
       -rm -f fbsql.s