On Tue 19 Apr 2005 09:48, Andreas Bernauer <email@example.com> writes:
>> I'm considering scsh and sunet to do some web developing, but I
>> can't find MySQL bindings for it.
> As far as I know, there are no MySQL bindings for scsh. However,
> there is a binding to ODBC, with which you should be able to connect
> to a MySQL server. As far as I know there are some things you have to
> do manually. See http://www.scsh.net/download/cvs.html how to get
> access to scsh-odbc.
That would be a possible solution. However, I really can't recommend
using the ODBC bindings for serious web projects.
Apart from the fact that the bindings are currently in a poor
condition and will be cleaned up by one of my students soon, there is
still the "blocking call problem": Calling an ODBC function will stop
the whole scsh process (thus, also the SUnet server) until the ODBC
call returns. In case of complex SQL queries the web server will be
unreachable for the time the query is being processed. This is
problem is inherent to all FFI calls and has not been solved yet.
However, if you don't expect much traffic you may decide to simply
ignore this problem. That's what one of my co-workers did when he
wrote a web-based learning program for the medical faculty. For this
project he used the ODBC bindings to connect to some rotten MS SQL
> However, if you don't have to use MySQL and if I remember correctly,
> there are bindings to some other database, whose name I forgot. Eric
> (the author of scsh-odbc) may know more about this.
The CVS repository contains bindings to Sleepycat's Berkeley DB (see
the module scsh-bdb). The code has been tested and should quite
stable. The only thing that kept me from releasing scsh-bdb is my
laziness when it comes to writing documentation.
"Excuse me --- Di Du Du Duuuuh Di Dii --- Huh Weeeheeee" (Albert King)