cl-rdbms

cl-rdbms abstracts away differences between various SQL databases and provides an advanced compiler for its sexp SQL syntax. It does not try to support object-relational mapping, see cl-perec for that. It also has a cleaner API than some of the other SQL libraries, although YMMV.

For a quick impression check out the showcase with a few selected examples. For more examples see the htmlized tests or the test suite of cl-perec

• Transaction API is mature with nested transaction support and after/before commit/rollback hooks
• Type management support (e.g. to help properly handle the NIL/false situation)
• The sexp SQL compiler compiles to CLOS based AST nodes and has means to abstract away types
• The sexp SQL compiler can compile the static parts of the SQL AST to constant strings at compile time
• Supports changing the SQL schema with special support for handling destructive operations (using conditions)
• At the time of writing the following backends exist:
  • Postmodern for PostgreSQL's socket interface (this is our primary backend)
  • OCI interface for Oracle (using CFFI)
  • Sqlite3 preliminary, interface for Sqlite (using CFFI)

• alexandria
• iterate
• cl-def
• metabang-bind
• defclass-star
• arnesi (scheduled for removal in favour of the smaller alexandria, but the logging code is still used from it)
• The Postmodern backend needs the cl-postgres package available from the Postmodern repo

  darcs get --partial http://common-lisp.net/project/postmodern/darcs/postmodern

  or you can get the branch we use:

  darcs get --partial http://common-lisp.net/project/cl-dwim/darcs/postmodern

  At the time of writing there are two patches that are not yet in the official: it uses local-time for time related datatypes and it's using ironclad for generating the hash for the connection.
• The Oracle OCI backend needs the OCI .so/.dll (installed by the Oracle client package)

• cl-rdbms-devel for any discussion about cl-rdbms

Attila Lendvai

Tamás Borbély

Levente Mészáros

You can browse the cl-rdbms darcs repository or get the tree with

darcs get --partial http://common-lisp.net/project/cl-rdbms/darcs/cl-rdbms

Public Domain / BSD