Oh wow. This is good Oleg. Thanks. Yeah. We have to find a good common interface to connect to large databases. This is where my J system bottlenecks.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oleg Kobchenko Sent: Tuesday, September 26, 2006 2:43 AM To: General forum Subject: [Jgeneral] SQLite new addon SQLite Addon for J http://olegykj.sourceforge.net/ http://olegykj.sourceforge.net/addons/sqlite.htm J bindings to SQLite embedded engine. Contains direct library calls as well as array-based economical bulk API. Includes Win32, Linux binaries; on Mac OS X it comes standard. Picture Gallery: http://olegykj.sourceforge.net/jhp/ A new object-oriented database API is used, which has some enhancements over the dd interface: - connection is maintained in an object, so calling method__db leaves free additional left argument for passing vector or matrix (repeated rows) SQL parameters - state is maintained inside the object, so there is no need to pass statement handle, etc. arround. - errors are automatically processed and raised as a standard J signal with a meaningful message; necessary resouce unreleases are done. - parameter types are recognized automatically by the types of the arguments; for the only rare exception of BLOB vs string, a boolean vector indicator is used. - query limit indicator provides automatic pagination. It would be good to have some discussion on the proposed API format in order to adopt a better common J database interface. The existing odbc interface could then be adapted to the new format. In general, ODBC in general is increasingly getting outdated and needs replacement with a flexible set of direct interfaces to Oracle OCI, and other RDBMSes. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
