Another version of the MySQL FFI is finished and ready for takeoff. Some big changes in this version. First of all, MySQL connection pooling has been implemented, and should be mostly thread-safe. I've also done up some higher-level functions for retrieving data from the database. Again, this release is not perfect, but it is getting much closer.

Click here to download the tar file
Here is the documentation

I am currently working on a set of macros as a sort of object-relational layer between the DB and scheme. Obviously this not a true object relational... anything, because there are no real (native) objects in scheme. More info forthcoming.

I'm building a web server in scheme.

I have decided to describe this project as my personal Charging at Windmills because of the sheer Quixotic nature of it all.

I've also decided to embrace my inner Don Quixote, for a few simple reasons:

1. If I can really build a kick ass killer-app webserver in scheme I will show the world; Google, Thoughtworks, and Amazon will all be falling all over themselves to hire me
2. I will end up building some useful libraries for Gambit Scheme
3. I'll be able to erase the sheer suffering caused by such monstrosities as PHP, J2EE, et all. (I pick on those 2 because I know them the best, but others are not exempt).
4. It's fun, and I am leaning more about HTTP, functional programming, threads, C programming, parsing and all sorts of great stuff.

Note that while points 1 and 3 have me firmly pointing my lance in the direction of the Netherlands (tilting at windmills, see?), points 2 and 4 are reasonable, observe:

Version 0.2 of my MySQL FFI for Gambit Scheme is available. The source is more documented, and there is FINALLY a semi-reasonable test suite. There is still a lot of work to be done, but it is getting to the point where there is at least a reasonable baseline.

Update: See this entry for the latest version!

Download it. Make comments, suggestions, bugreports. Even stuff like "I won't use it because of x, y and z" are helpful.

Enjoy the fruits of my pie-in-the-sky labours.

by the by, the webserver code is unreleaseable, but available at:
svn://panda-ba.sanriowasteland.net/zengarden/trunk

It isn't perfect, but here it is, a Gambit MySQL FFI. This is very cool, it lets you talk to mysql through gambit. All you have to do is build it (with 'make install') and you can load the library with (load "mysql-ffi.o1")

You will need to have the mysql client libraries and include file installed somewhere in order to build it, but for those of you on Win32 and Cygwin, I've packaged up a binary as well.

Documentation comes later. Use the source!

Update: See this entry for the latest version!

Source File

Cygwin Gambit Library (binary - statically linked against mysqlclient 5.0)