What are the best practices for functional programming and database interaction?

Question

I know that in pure object-oriented languages like Java it usually makes sense to use ORMs like Hibernate. But what would I do when writing a CRUD-type functionality in Clojure or Common LISP?

Passing around SQL as the first-order functions? But isn't having SQL in HTML-generating code very ugly?

Thanks,

Olek

Answer 1

Common Lisp is not a self-consciously FP language. Clojure can just use Hibernate.

For Common Lisp: databases. Here's a persistent object one. And here is the first part of a tutorial that uses it with Hutchentoot, a CL webserver and dynamic webpage toolkit. SQL in CL can look like this (which looks longer than it really is, because the SQL is horizontally formatted and the CL isn't). And if you like, this guy is working on a web framework (using CLSQL and Elephant, already linked-to) that aims at tersity, with an eye on the arc challenge.

EDIT: a recent answer expands on this.

Answer 2

an alternative set of Common Lisp tools is described in another answer