* Guile-PG 0.33 available
@ 2007-05-20 15:29 Thien-Thi Nguyen
0 siblings, 0 replies; only message in thread
From: Thien-Thi Nguyen @ 2007-05-20 15:29 UTC (permalink / raw)
To: guile-sources; +Cc: guile-user
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/
_______________________________________________
Guile-user mailing list
Guile-user@gnu.org
http://lists.gnu.org/mailman/listinfo/guile-user
^ permalink raw reply [flat|nested] only message in thread
only message in thread, other threads:[~2007-05-20 15:29 UTC | newest]
Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2007-05-20 15:29 Guile-PG 0.33 available Thien-Thi Nguyen
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).