[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Guile-PG 0.33 available

From: Thien-Thi Nguyen
Subject: Guile-PG 0.33 available
Date: Sun, 20 May 2007 17:29:21 +0200

release notes:

  yeah, SQL is ugly.  life goes on...

  oops, forgot to mention in NEWS: dist includes html docs.


README excerpt:

  Guile-PG is a collection of modules for Guile allowing access to
  the PostgreSQL RDBMS from Scheme programs.
  The low-level module `(database postgres)' provides an almost
  one-to-one correspondence with the PostgreSQL "libpq" C library
  interface.  Other higher-level modules, typically named
  `(database postgres-FOO)', provide abstractions and convenience
  This is alpha code (pre 1.0 release).  It has bugs, and the
  interfaces may change from version to version.

NEWS excerpt:

  - 0.33 | 2007-05-20
    - Bugfix: `pgtable-manager' handles mixed-case table names
        Previously, `pgtable-manager' (and `pgtable-worker') would
        render the table name in an SQL command to `pg-exec' without
        quoting.  PostgreSQL would case-smash it, and subsequently not
        recognize the table, causing an error.  For example:
        (define w (pgtable-worker CONN "oOpAcK" ...))
        (w #:drop)
        before: => DROP TABLE oOpAcK; => FATAL (no relation "oopack").
           now: => DROP TABLE "oOpAcK"; => OK.
    - New type converters in module (database postgres-types)
        int  decimal  numeric  varchar  character  bytea
    - New support for special constructs in (database postgres-qcons)
        (in/set A B...) => A IN ( B, ... )
        (between A B C) => ( A BETWEEN B AND C )
        (any--OP A B)   => ( A OP ANY B )
        (all--OP A B)   => ( A OP ALL B )
        For the latter two, OP is a comparison operator, e.g `='.
        Parentheses and commas are added automatically.
    - Tested against PostgreSQL 7.4.17

tarball, prettified source, etc, in dir:

reply via email to

[Prev in Thread] Current Thread [Next in Thread]