Hello,
This is the fourth 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.71 by Christian Werner
(http://www.ch-werner.de/sqliteodbc/),
- MS SQL Server.
Compatibility with Allegro CL, CLISP, CMUCL, Corman Lisp, MCL,
and SBCL is also targetable.
Release 0.4 new features
--------------------------------
- Regression test suite.
- Set operations UNION, INTERSECT, EXCEPT.
- Database creation, destroying, and listing functions.
Bug reports and suggestions are welcome.
--
Sincerely,
Dmitriy Ivanov
lisp.ystok.ru
On Mon, 09 Oct 2006 12:14:23 -0700, Vagif Verdi wrote:
> What is the point of building CommonSQL clone that works only on
> Lispworks ?
Hmm, saving 2400 Euro by not buying the enterprise edition?
Saving countless hours of work by not having to port UFFI to
Windows?
Cheers, Ralf Mattes
On 9 Oct 2006 16:57:55 -0700, <···········@gmail.com> wrote:
> Agree on Ent.Edition.
> But author says that his library is heavily influenced by CLSQL
> (UncommonSQL).
> As far as I know CLSQL runs fine on lispworks.
I looked at this code briefly, and wanted it due to extensions for the
SELECT, etc. True, it doesn't work at all on cmucl, but if I had
lispworks, I would favor it over clsql.
--
Reply-To email is ignored.
--
Posted via a free Usenet account from http://www.teranews.com
Hello Vagif,
"Vagif Verdi" <···········@gmail.com> wrote:
VV> Agree on Ent.Edition.
VV> But author says that his library is heavily influenced by CLSQL
VV> (UncommonSQL).
VV> As far as I know CLSQL runs fine on lispworks.
To clarify, YstokSQL is not "heavily influenced" by CLSQL but CommonSQL. I
guess, both YstokSQL and CLSQL started approximately at the same epoch and
were influenced by the SQL/ODBC module by Paul Meurer. After SQL/ODBC was
orphaned, the first version YstokSQL was (quite) a rewrite of SQL/ODBC.
By that time, SQL/ODBC had already provided a FF-Compatibility library,
wrapper functions and macros for the foreign function interfaces of MCL,
LispWorks, ACL, CMUCL, and Corman Lisp. I also guess, UFFI has borrowed some
ideas of FFC. (Let Kevin correct me.)
YstokSQL retains most of the original FFC code, though small changes and
improvements were actually made on LispWorks. Rather than pursuing various
Lisp implementations, the main targets were the following:
- an all-embracing ODBC support,
- a better square bracket syntax.
--
Sincerely,
Dmitriy Ivanov
lisp.ystok.ru
On 2006-10-10, Dmitriy Ivanov <·············@m_aha.ru> wrote:
> To clarify, YstokSQL is not "heavily influenced" by CLSQL but CommonSQL. I
> guess, both YstokSQL and CLSQL started approximately at the same epoch and
> were influenced by the SQL/ODBC module by Paul Meurer. After SQL/ODBC was
> orphaned, the first version YstokSQL was (quite) a rewrite of SQL/ODBC.
CLSQL was only limitedly influenced by SQL/ODBC. I incorporated its
ODBC backend (ported to UFFI) after CLSQL was running with MySQL,
PostgreSQL, and SQLite backends for quite some time. The high-level
interface of CLSQL was not influenced by SQL/ODBC.
> By that time, SQL/ODBC had already provided a FF-Compatibility library,
> wrapper functions and macros for the foreign function interfaces of MCL,
> LispWorks, ACL, CMUCL, and Corman Lisp. I also guess, UFFI has borrowed some
> ideas of FFC. (Let Kevin correct me.)
UFFI was written and used by CLSQL for a number of years before I
learned of the existence of SQL/ODBC and FFC.
Minor points, but noted anyway for those interested in the history of
Lisp/SQL interfaces.
--
Kevin Rosenberg
·····@hypershots.com
On 2006-10-09, Ralf Mattes <··@mh-freiburg.de> wrote:
> [...]
> Saving countless hours of work by not having to port UFFI to
> Windows?
Hi Ralf,
UFFI and CLSQL runs on Windows under Allegro and
Lispworks. Additionlly, CLSQL runs on Windows using CFFI-UFFI-COMPAT.
--
Kevin Rosenberg
·····@hypershots.com