Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[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 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