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

REBOL 3 embedded host-kit extension for ODBC database access

 [1/5] 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

 [2/5] from: petr:krenzelok:seznam:cz at: 29-Sep-2010 13:45


This is great! First real R3 extension. Just few suggestions overall: - we should not really forget about using schemes/ports - aproach you used is really an old-school, non rebolish. Surely useable, but maybe I am just too much used to nice other-rebol-db-driver interfaces. As for ports and blocking argument - wasn't R2 ODBC eventually blocking too? - embedded extension is nice, but as well as for SQLite Robert did, I suggest to use DLL aproach, with tiny wrapper - you save novices from the need to set-up the compiler. Other than that, I am very surprised that somene actually finally produced something VERY usefull, along with nice docs. Just - wow, and thanks :-) -pekr- Dne 29.9.2010 13:26, Christian Ensel napsal(a):

 [3/5] from: semseddinm:bircom at: 29-Sep-2010 17:39


This is superb! Thanks a lot! Wed, 29 Sep 2010 14:45:46 +0300 tarihinde Petr Krenzelok <petr.krenzelok-seznam.cz> şöyle yazmış:

 [4/5] from: gregg:pointillistic at: 29-Sep-2010 10:11


Thanks Christian! -- Gregg

 [5/5] from: christian:ensel:gmx at: 30-Sep-2010 23:38


Hi, the ODBC interface is now availabe as DLL. That should make it more accessible. Visit http://www.diefettenjahresindvorbei.de/odbc/odbc-docs.html for details or download directly from http://www.diefettenjahresindvorbei.de/odbc/odbc.dll Cheers, Christian