From: Marc Battyani
Subject: postgresql + LW
Date: Sun, 07 Jan 2001 17:28:20 +0000
Message-ID: <93aa07$djq$1@reader1.fr.uu.net>

Has anybody managed to use postgresql with LW under FreeBSD (or Linux, it
should be similar)

I have LW Entreprise edition but it only works with oracle8. (oracle 8.16
does not work under FreeBSD)

I will look at SQL-ODBC / UncommonSQL / MaiSQL ... but I would appreciate
feedback on these with LW and FreeBSD.

Marc Battyani

• Re: postgresql + LW Craig Brozefsky
• Re: postgresql + LW Cor Gest jr
  • Re: postgresql + LW Marc Battyani
  • Re: postgresql + LW Eric Marsden

From: Craig Brozefsky
Subject: Re: postgresql + LW
Date: Sun, 07 Jan 2001 17:59:48 +0000
Message-ID: <87r92f5jl7.fsf@piracy.red-bean.com>

"Marc Battyani" <·············@fractalconcept.com> writes:

> I will look at SQL-ODBC / UncommonSQL / MaiSQL ... but I would appreciate
> feedback on these with LW and FreeBSD.

There was a port of UncommonSQL to Lispworks under windows that interfaced
with PostgreSQL.  I'm not sure if LW on FreeBSD is similiar enough
that it would be useful tho.  This port has not been folded into
MaiSQL yet, so you should prolly contact the author John Miller at
········@uop.com

You could also take the existing UncommonSQL support for Postgres and
patch the foreign function calls to work under LispWorks.

From: Cor Gest jr
Subject: Re: postgresql + LW
Date: Mon, 08 Jan 2001 04:08:34 +0000
Message-ID: <87d7dyd6t9.fsf@cleopatra.clsnet.nl>

There exsists an pg.el, made in Emacs Lisp
which is an simple Elisp interface to Postgresql

http://www.chez.com/emarsden/downloads/pg.el


cor

From: Marc Battyani
Subject: Re: postgresql + LW
Date: Mon, 08 Jan 2001 09:16:40 +0000
Message-ID: <93c1ie$e61$1@reader1.fr.uu.net>

"Cor Gest jr" <···@clsnet.nl> wrote

> There exsists an pg.el, made in Emacs Lisp
> which is an simple Elisp interface to Postgresql
>
> http://www.chez.com/emarsden/downloads/pg.el

Thanks, I didn't know about this one.
It is not in Common Lisp but there is a Common Lisp version at
http://www.chez.com/emarsden/downloads/pg.lisp
The use of sockets instead of libpq to connect to postgresql could be
interesting.

Marc

From: Eric Marsden
Subject: Re: postgresql + LW
Date: Mon, 08 Jan 2001 09:26:07 +0000
Message-ID: <wzisnmus8cw.fsf@mail.dotcom.fr>

>>>>> "cg" == Cor Gest <···@clsnet.nl> writes:

  cg> There exsists an pg.el, made in Emacs Lisp
  cg> which is an simple Elisp interface to Postgresql

yep, and now a Common Lisp version of the same. This code implements
the socket-level interface between the PostgreSQL postmaster and a
client, so you don't need to do any foreign linking with libpq. A
further advantage is that it preserves type information which is
discarded by libpq, and SQL data is automatically converted to
appropriate CL types.

Doesn't currently support large objects (but it should be easy to port
the elisp code). Tested with CMUCL, CLISP, ACLtrial; patches for LW
welcome. 

   <URL:http://www.chez.com/emarsden/downloads/pg.lisp>

-- 
Eric Marsden                          <URL:http://www.laas.fr/~emarsden/>