pg-dot-lisp

Introduction

pg-dot-lisp is a socket-level interface to the PostgreSQL object-relational DBMS. It implements the client part of the frontend/backend protocol, rather than providing an FFI wrapper around the libpq library.

Features:

• automatic coercion from a range of SQL types to the appropriate Common Lisp types;
• large object (BLOB) support;
• errors signaled by the database backend are mapped into the Common Lisp condition system;
• is able to use a TCP or a Unix socket to connect to the backend;
• works with CMUCL, SBCL, CLISP, OpenMCL, ECL, ABCL, Allegro CL, Lispworks and MCL ;
• available in Debian as the cl-pg package.

Licence: pg-dot-lisp is distributed under the terms of the GNU LGPL.

Sample code:

   (with-pg-connection (conn "testdb" "login" :host "dbhost" :password "secret")
      (with-pg-transaction conn
         (when (member "test_date" (pg-tables conn) :test #'string=)
            (pg-exec "DROP TABLE test_date"))
         (pg-exec conn "CREATE TABLE test_date(a timestamp, b abstime, c time, d date)")
         (pg-exec conn "INSERT INTO test_date VALUES "
                       "(current_timestamp, 'now', 'now', 'now')")))
 

Mailing Lists

• pg-announce
  for announcements.
• pg-devel
  for development discussion.
• pg-cvs
  CVS log feed.

Download

You can browse the CVS repository, or download a cvs snapshot in tarfile format. To checkout from CVS:

export CVSROOT=:pserver:anonymous@common-lisp.net:/project/pg/cvsroot
cvs login 
(Enter anonymous when prompted for the password)
cvs checkout pg