Subject: Re: Problem with CLSQL on Mac
From: rpw3@rpw3.org (Rob Warnock)
Date: Fri, 09 Jun 2006 20:25:34 -0500
Newsgroups: comp.lang.lisp
Message-ID: <lMGdncUv78oTghfZnZ2dnUVZ_rednZ2d@speakeasy.net>
Jonathon McKitrick <j_mckitrick@bigfoot.com> wrote:
+---------------
| I finally got a working installation of postgresql and I'm trying to
| get CLSQL to work with it.
| It's currently not finding 'postgresql-loader' or any of the libraries
| it needs.
+---------------

Others have given you good suggestions, but just as another
data point and possible alternative...

I started using PostgreSQL with CMUCL about four years ago,
*not* with CLSQL, but using Eric Marsden's "PG" library
<http://www.cliki.net/Pg>:

    Pg is a socket-level interface to the PostgreSQL object-relational
    Database. The Library implements the client part of the
    frontend/backend protocol, so does not require interfacing with
    the "libpq" library. SQL types are converted to the equivalent
    Common Lisp types where possible. Supports large objects (BLOBs).

That is, it needs no FFI [other than whatever socket support your
Common Lisp has] or matching shared library versions, since it
speaks the PostgreSQL socket protocol directly.

I've been quite happy with it, and currently support several
(low-volume) web sites that use it behind a Lisp-based persistent
applications server.


-Rob

-----
Rob Warnock			<rpw3@rpw3.org>
627 26th Avenue			<URL:http://rpw3.org/>
San Mateo, CA 94403		(650)572-2607