[clean-list] RE: MySQL

Corrin Lakeland lakeland@cs.otago.ac.nz
Mon, 27 Jan 2003 10:16:11 +1300


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 25 Jan 2003 00:02, Erik Zuurbier wrote:
> Christian, you wrote
>
> >Dear Clean-Experts, can anyone tell me where I can get information how to
> > access a MySQL Database from Clean?
>
> This question has not been answered sofar. But I am affraid I have to
> disappoint you altogether.

I have used clean to access a PostgreSQL database, and the same technique 
could be used to access MySQL.  I used Clean's interface to C to transfer 
data, and used Postgres' C libraries to access the database. It did seem 
wasteful in that data got parsed and copied multiple times, but if 
performance is not an issue then you shouldn't need to worry about this.

An alternative approach is to use MySQL's TCP libraries and communicate that 
way. I haven't tried this at all.

Corrin
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE+NFAbi5A0ZsG8x8cRAkBzAJ9F+yMTqEi3hPJBjz/syISy/MvUewCfbsJj
Ae9m4fEmp5Xmb9c46/P9PVo=
=CDIh
-----END PGP SIGNATURE-----