[toronto-lisp] Fwd: [tpm] [Fwd: The Upcoming Dynamic Language Smack Down]

[Brian Connoy]

"I wonder if the Lisp world has something similar, that integrates very tightly with Lisp."



Unless I misunderstand your question, LispWorks Enterprise boasts something called "Common SQL".  As usual, I know little about it.     8^/



19.1.1 Overview

Common SQL is designed to provide both embedded and transparent access to relational databases from the LispWorks environment. That is, SQL/relational data can be directly manipulated from within Lisp, and also used as necessary when instantiating or accessing particular Lisp objects.

The SQL interface allows the following:
*               Direct use of standard SQL statements as strings
*               Mixed symbolic SQL and Common Lisp expressions
*               Implicit SQL invocation when instantiating or accessing CLOS objects

The SQL interface provides these features through two complementary layers:
*               A functional SQL interface
*               An object-oriented SQL interface

The functional interface provides users with Lisp functions which map onto standard SQL DML and DDL commands. Special iteration constructs which utilize these functions are also provided. The object-oriented interface allows users to manipulate database views as CLOS classes via def-view-class<lw-1112.htm#47877>. The two interfaces may be flexibly combined in accordance with system requirements and user preference. For example, a select query can be used to initialize slots in a CLOS instance; conversely, accessing a CLOS slot may trigger an implicit functional query.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/toronto-lisp/attachments/20101210/bcc937cb/attachment.html>