[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.
thi
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
procedures.
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:
http://www.gnuvola.org/software/guile-pg/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- Guile-PG 0.33 available,
Thien-Thi Nguyen <=