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.