[ANN] YstokSQL 0.3 - Common Lisp ODBC interface
Hello,
This is the third release of YstokSQL, a Common Lisp library for
interfacing relational databases via ODBC. The implementation
is much inspired by LispWorkss(R) CommonSQL.
YstokSQL provides the functional CommonSQL interface almost in full
and a limited support of the object-oriented interface.
YstokSQL is distributed under a LLGPL style license.
The latest version is at
http://lisp.ystok.ru/ysql.html
YstokSQL is based on the following open-source implementations:
- SQL/ODBC module by Paul Meurer,
- MaiSQL package by Pierre R. Mai,
- UncommonSQL by OnShore Development.
- CLSQL maintained by Kevin M. Rosenberg.
YstokSQL was tested on LispWorks 4.2-4.4 for Windows against the following
ODBC drivers:
- MS Access (Jet 3.5-4.0),
- Oracle 8.1.7 and 10.1 (InstantClient 10.1 and 10.2),
- PostgreSQL 8.1 (http://pgfoundry.org/projects/psqlodbc/),
- SQLite3 driver 0.66 by Christian Werner
(http://www.ch-werner.de/sqliteodbc/),
- MS SQL Server.
Compatibility with Allegro CL, CMUCL, Corman Lisp, and MCL is also
possible thanks to Paul Meurer's FFC code.
Release 0.3 major features:
--------------------------------
- Object-oriented interface in its simplest.
- The desktop-mixin class covering several Jet database
subclasses: access-database, excel-database, etc.
- Coalescing SQL references to save space.
- sql-case-exp covering three operators CASE, COND and COALESCE
(analogous to ODBC IFNULL, Jet's Nz, Oracle's NV).
- SQL_NUMERIC and SQL_BIGINT types support.
Bug reports and suggestions are welcome.
--
Sincerely,
Dmitriy Ivanov
lisp.ystok.ru