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