From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Thien-Thi Nguyen Newsgroups: gmane.lisp.guile.user,gmane.lisp.guile.sources Subject: Guile-PG 0.33 available Date: Sun, 20 May 2007 17:29:21 +0200 Message-ID: NNTP-Posting-Host: lo.gmane.org X-Trace: sea.gmane.org 1179674996 14486 80.91.229.12 (20 May 2007 15:29:56 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Sun, 20 May 2007 15:29:56 +0000 (UTC) Cc: guile-user@gnu.org To: guile-sources@gnu.org Original-X-From: guile-user-bounces+guile-user=m.gmane.org@gnu.org Sun May 20 17:29:54 2007 Return-path: Envelope-to: guile-user@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1HpnLy-0007K3-6o for guile-user@m.gmane.org; Sun, 20 May 2007 17:29:50 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HpnLx-0001KC-BU for guile-user@m.gmane.org; Sun, 20 May 2007 11:29:49 -0400 Original-Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1HpnLq-0001Iy-0H for guile-user@gnu.org; Sun, 20 May 2007 11:29:42 -0400 Original-Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1HpnLo-0001IJ-IK for guile-user@gnu.org; Sun, 20 May 2007 11:29:41 -0400 Original-Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1HpnLm-0001Hi-0Z; Sun, 20 May 2007 11:29:38 -0400 Original-Received: from smtp-out4.libero.it ([212.52.84.46]) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1HpnLl-0004UF-EX; Sun, 20 May 2007 11:29:37 -0400 Original-Received: from localhost (172.31.0.51) by smtp-out4.libero.it (7.3.120) id 4611FF5202EAFF25; Sun, 20 May 2007 17:29:07 +0200 X-Scanned: with antispam and antivirus automated system at libero.it Original-Received: from smtp-out4.libero.it ([172.31.0.40]) by localhost (asav-out10.libero.it [192.168.32.38]) (amavisd-new, port 10024) with ESMTP id NykdMcFNegi2; Sun, 20 May 2007 17:29:07 +0200 (CEST) Original-Received: from ambire.localdomain (151.21.38.222) by smtp-out4.libero.it (7.3.120) id 4611FEBC040A6AF5; Sun, 20 May 2007 17:29:07 +0200 Original-Received: from ttn by ambire.localdomain with local (Exim 4.63) (envelope-from ) id 1HpnLV-0005dB-HQ; Sun, 20 May 2007 17:29:21 +0200 X-detected-kernel: Linux 2.4-2.6 X-BeenThere: guile-user@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: General Guile related discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: guile-user-bounces+guile-user=m.gmane.org@gnu.org Errors-To: guile-user-bounces+guile-user=m.gmane.org@gnu.org Xref: news.gmane.org gmane.lisp.guile.user:5956 gmane.lisp.guile.sources:279 Archived-At: 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