Ideally something that will work with Oracle, MS SQL Server, MySQL and Posgress.
+4
A:
At the moment there's no open-source library that supports all the SQL backends you mention. CLSQL comes quite close (lacking only support for MS SQL). The alternatives are:
- CL-RDBMS (which supports Oracle, Postgres through Postmodern and SQLite3)
- Postmodern (only Postgres).
If you can use a commercial Lisp, you can give a try to CommonSQL included with Lispworks, which supports all the databases you mentioned.
CLSQL looks like the most popular open source library at the moment. Unfortunately, it seems to suffer from bit rot, and the developers had to make some compromises to support all those platforms.
If the RDB backend is not a constraint, then I recommend Postmodern. It is very well documented and has a clean API (and a nice small language compiled to SQL). Also, it is well maintained and small enough to keep being understandable and extensible. It focuses only on Postgres, not trying to be all things for all people.
Ryszard Szopa
2008-09-23 19:43:18
it's wrong. see http://www.cliki.net/SQL
Attila Lendvai
2008-09-23 19:54:12
I guess you were right. But if CLSQL supported MS SQL *I* would be right :-) Anyway, I edited my answer.
Ryszard Szopa
2008-09-23 20:14:06
Isn't MS SQL reachable by ODBC? CL-SQL is supposed to support ODBC.
Nowhere man
2008-09-24 12:24:03
They don't say anything about MS SQL in CLSQL's documentation.
Ryszard Szopa
2008-09-24 23:40:18
+8
A:
if you mean common lisp by lisp, then there's cl-rdbms. it is heavily tested on postgres (uses postmodern as the backend lib), it has a toy sqlite backend and it also has an OCI based oracle backend. it supports abstracting away the different sql dialects, has an sql quasi-quote syntax extension installable on e.g. the [] characters.
i'm not sure if it's the best, and i'm biased anyway... :) but we ended up rolling our own lib after using clsql for a while, which is i think the most widely used sql lib for cl.
see cliki page about sql for a further reference.
Attila Lendvai
2008-09-23 19:52:59
+1
A:
Allegro Common Lisp has an ODBC library and a MySQL-specific library, both exhaustively documented. I've used the MySQL one; no surprises.
Rich
2008-10-23 05:37:21