Anyone using Lisp for a MySQL-backended web app?

Question

I keep hearing that Lisp is a really productive language, and I'm enjoying SICP. Still, I'm missing something useful that would let me replace PHP for server-side database interaction in web applications.

Is there something like PHP's PDO library for Lisp or Arc or Scheme or one of the dialects?

Answer 1

newLisp has support for mysql5 and if you look at the mysql5 function calls, you'll see that it's close to PDO.

Answer 2

Since nobody has mentioned it, you can try Postmodern, which is an interface to PostgreSQL. It aims for a tighter integration with PostgreSQL and so doesn't pretend to portability between databases.

I've put it together with hunchentoot and cl-who and built a pretty nice website.

Answer 3

newLISP - http://www.newlisp.org/ - has support for MySQL, but I haven't used it (newLISP).

Answer 4

If you're happy with SQL as part of your life, CL-SQL provides a mapping into CLOS objects. It appears to be more mature than Elephant.

I'm using it on my own website.