Clementson's Blog

Bits and pieces (mostly Lisp-related) that I collect from the ether.

June 2004
Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30
May  Jul

CLSQL - Part 1

Sunday, June 6, 2004

After testing ACL's MySql support the other day, I received some email that suggested that I try out CLSQL as well. I knew that there were a number of different Lisp database libraries out there but I had never gotten around to trying out any single one of them seriously. Based on the recommendations I had received, I decided to have a look at CLSQL, and, on closer examination, it did seem to have a lot going for it:

So, given all these advantages, I decided to give CLSQL a try and try out support for MySQL and SQLite. I had some initial setup problems on MS Windows but a few email exchanges with Kevin Rosenberg got my problems sorted out. Basically, this is what I had to do to get CLSQL running on Windows2000 with MySQL and SQLite: After setting up and running CLSQL as shown above, I got the following test results (only summaries are presented):
******************************************************************************
***     CLSQL Test Suite begun at 2004-06-06 19:02:25
***     International Allegro CL Enterprise Edition
***     7.0.beta [Windows] (Jun 4, 2004 9:49) on x86
***     Database MYSQL backend.
******************************************************************************
Doing 202 pending tests of 202 tests total.
[snipped detail]
No tests failed.
Tests skipped:
   FDDL/VIEW/1          views not supported
   FDDL/VIEW/3          views not supported
   FDDL/VIEW/4          views not supported
   FDML/QUERY/5         not supported by mysql
   FDML/QUERY/7         not supported by mysql
   FDML/QUERY/8         not supported by mysql
   FDML/SELECT/1        fancy math not supported
   FDML/SELECT/5        subqueries not supported
   FDML/SELECT/10       subqueries not supported
   FDML/SELECT/11       boolean where not supported
   FDML/SELECT/22       not supported by mysql
   FDML/SELECT/26       string table aliases not supported on all mysql versions
   FDML/SELECT/32       subqueries not supported
   FDML/SELECT/33       subqueries not supported
   OODML/SELECT/5       boolean where not supported
****************************************************************************** *** CLSQL Test Suite begun at 2004-06-06 19:03:04 *** International Allegro CL Enterprise Edition *** 7.0.beta [Windows] (Jun 4, 2004 9:49) on x86 *** Database SQLITE backend. ****************************************************************************** Doing 210 pending tests of 210 tests total. [snipped detail] No tests failed. Tests skipped: FDDL/VIEW/4 not supported by sqlite FDML/SELECT/1 fancy math not supported FDML/SELECT/10 not supported by sqlite FDML/SELECT/11 boolean where not supported FDML/SELECT/21 not supported by sqlite FDML/SELECT/32 not supported by sqlite FDML/SELECT/33 not supported by sqlite OODML/SELECT/5 boolean where not supported

No tests failed for either MySQL or SQLite. There were a number of skipped tests for both databases - this is indicative of a feature that is not supported by that particular database. Surprisingly, SQLite had fewer skipped tests than MySQL.

Part 2 will discuss some of my experiences using CLSQL.

emacs Copyright © 2005 by Bill Clementson