Thought this might be of interest - add another program enhanced by Scheme...
-------- Original Message -------- Date: Sun, 10 Dec 2006 00:31:20 +0200 From: Volkan YAZICI yazicivo@ttnet.net.tr To: pgsql-announce@postgresql.org Subject: [ANNOUNCE] PL/scheme 0.9 Released Message-ID: 20061209223119.GA1338@alamut
Freelance Incorporation is pleased to announce the PL/scheme 0.9, the first initial release of the Scheme procedural language handler for PostgreSQL.
PL/scheme is a PostgreSQL procedural language handler for Scheme programming language released under BSD license. PL/scheme uses Guile in the background as its Scheme interpreter. You can find some of the supported features by PL/scheme in the below list.
o. Extensible native type support even for not created yet SQL data types. Domain, complex (ie. table's row) and pseudo (record) types are supported as well. o. [Nested] record and row types are supported both when returning a record type and as an argument to the procedure, o. IN, INOUT and OUT argument mode functionality, o. SPI functionality, o. Trigger support, o. Caching for non-volatile (and non-SRF) procedures per [top] transaction, o. Globally shared variables support, o. Support for both trusted and untrusted PL modes, o. and any available feature supported by Guile (fully R5RS compliancy, module system extension, full access to POSIX system calls, networking support, multiple threads, dynamic linking, foreign function call interface, powerful string processing, GOOPS framework, lots of builtin SRFIs and may others) are naturally shipped with PL/scheme too.
You can find more information about the project and installation in the website at
http://plscheme.projects.postgresql.org/
There's also an extensive WYSIWYG documentation about the shipped features along PL/scheme.
PL/scheme is evolved from the PL/parrot ideas of David Fetter, therefore so much thanks to him for his inspiration. Also, many thanks to Rob Browning, Ludovic Courtès and Dale P. Smith from #guile at irc.freenode.net for their kindly help.
Regards.