[REBOL] REBOL 3 embedded host-kit extension for ODBC database access
From: christian:ensel:gmx at: 29-Sep-2010 13:26
Hi,
just published a REBOL 3 embedded host-kit extension for ODBC database
access.
Documentation along with the .r module and .c extension source code is
to be found at http://www.diefettenjahresindvorbei.de/odbc/odbc-docs.html
The R3 ODBC Extension allows easy access to databases and data sources
supporting ODBC.
The extension supports SQL statements SELECT and INSERT, UPDATE and
DELETE as well as catalog functions for tables, columns and types. It
supports statement parameters and is Unicode aware. It supports direct
and prepared execution of statements.
If you're used to the commercial REBOL/Command (or the nowadays freely
available REBOL/View) ODBC database access methods, you should have no
problems using the ODBC API presented here. There's next to no
differences in functionality, it differs mostly in that the extension
isn't used with ports, but with "ordinary" functions OPEN-DB, OPEN-SQL,
DO-SQL, CLOSE-SQL and CLOSE-DB. This may change when it's possible to
provide the extension as an asynchronous R3 device, since the ODBC
functions may be blocking.
For now, the API is implemented as an embedded host-kit extension (it
should easily be possible to provide it as an external dll) and is
available for the Windows platform. So far it has been tested with
MySQL, PostgreSQL and Intersystems Caché as well as the Microsoft Text
Driver. Of course it's supposed to work with any ODBC data source.
Cheers,
Christian
