There is an update to SQLite addon: - new SQLite Browser application views and queries database schema and data - blobsize - optional transaction in apply (per Bill Lam) - strtbl (per David Mitchell) - double binding fix - lib location fix to allow spaces in folder names (per Yuvaraj Athur Raghuvir)
Open issues: - utf16 (per Bill Lam) Thanks to everyone for feedback! --- Oleg Kobchenko <[EMAIL PROTECTED]> wrote: > 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
