Re: [Chicken-users] status of chickenlib: build process and mysqlinterface usage sample

[Ed Watkeys]

klaus schilling said:
> gian paolo ciceri writes:
>  > -----BEGIN PGP SIGNED MESSAGE-----
>  > Hash: SHA1
>
>
> the technical director of the famous azienda at Milan
> writing financial software based on opensource components
> where I once applied unsuccessfully? So scheme is seen now
> suited for that sort of tasks and may compete with python?

I came to Scheme in general and Chicken in particular because I came to
see it as an almost-Lisp with too much syntax. I guess you can call me
Graham-ian. [http://paulgraham.com/] Of course others do not support this
view of Python. [http://www.prescod.net/python/IsPythonLisp.html]

> wopuld it be hard to provide a generalised sql interface on the lines
> of Perl's DBI/DBD architecture?
> and is the existing interface pure scheme or based on libmysql?
> perl offers for some sql engines both pure perl and lib*sql-based
> drivers, the former allowing to write client codes running on engines
> where the libraries aren't even available, the latter provide more speed.

I would very much like to see a standard interface for talking to
databases. You should check out what Johannes Grødem is doing with his
PostgreSQL interface. He has implemented a very Lisp-y interface that's
very un [JO]DBC-ish. Had has interface not been around, I probably would
have written one that was modeled on JDBC, ODBC, or Perl's DBI. I'm not
saying that's the right thing, but I think people coming from other
languages would find the availability of familiar interfaces nice. Is that
group of people worth considering? (I'm not being sarcastic: I don't
know.)

One area where I've been hassling Johannes is that his interface currently
cannot tell me how many rows were updated as a result of an INSERT,
DELETE, UPDATE, etc. If there were a standard for such things, this
problem would presumably be addressed.

Regards,
Ed

-- 
Watkeys Product Design * http://watkeys.com/
address@hidden * +1 215 694 4201