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): > 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 > > > > > -- To unsubscribe from the list, just send an email to lists at rebol.com with unsubscribe as the subject.
