[Openmcl-devel] YAWRQ (Yet Another Wheel Reinvention Query): MySQL interface

[Ron Garret]

The problem I'm having with CLSQL seems to have nothing to do with the  
FFI.  The problem is that there seems to be a big disconnect between  
the docs and reality.  In particular, the docs say that you can call  
the CONNECT function with no arguments and expect it to fill in  
reasonable defaults.  But what happens to me is:

? (connect)
 > Error: The value NIL, derived from the initarg :HOSTNAME, can not  
be used to set the value of the slot COM.HACKINGHAT.CL-MYSQL- 
SYSTEM::HOSTNAME in #<COM.HACKINGHAT.CL-MYSQL-SYSTEM:CONNECTION-POOL  
#x3000414A614D>, because it is not of type BASE-STRING.
 > While executing: CCL::%SHARED-INITIALIZE, in process listener(1).
 > Type :POP to abort, :R for a list of available restarts.
 > Type :? for other options.
1 > ^D
? (connect :hostname "localhost")
 > Error: Incorrect keyword arguments in (:HOSTNAME "localhost") .
 > While executing: CONNECT, in process listener(1).
 > Type :POP to abort, :R for a list of available restarts.
 > Type :? for other options.
1 > ^D
? (connect :host "localhost")
 > Error: The value NIL, derived from the initarg :USERNAME, can not  
be used to set the value of the slot COM.HACKINGHAT.CL-MYSQL- 
SYSTEM::USERNAME in #<COM.HACKINGHAT.CL-MYSQL-SYSTEM:CONNECTION-POOL  
#x3000414A375D>, because it is not of type BASE-STRING.
 > While executing: CCL::%SHARED-INITIALIZE, in process listener(1).
 > Type :POP to abort, :R for a list of available restarts.
 > Type :? for other options.
1 > ^D

And so on (and on and on and on).

I've sent a message to Steve Knight asking about this as well but he  
hasn't responded yet.

rg


On Jul 19, 2009, at 5:19 PM, Jon S. Anthony wrote:

> On Sun, 2009-07-19 at 17:56 -0600, Gary Byers wrote:
>> If I understand correctly (and there's no reason to believe that I  
>> do),
>> CLSQL was originally written to depend on a portable FFI layer named
>> UFFI.
>
> Yes, that is true.
>
>
>> It may be the case that UFFI is no longer actively maintained.  CFFI
>> (which definitely is still being actively maintained) offers a  
>> "uffi-compat"
>> package which is intended to help port programs that depend on UFFI  
>> to
>> platforms that UFFI doesn't support (x86 versions of CCL may fall  
>> into
>> that category.)
>
> I believe that CLSQL folks (in particular Kevin Rosenberg)
> maintain/ensure that CFFI that comes with CLSQL works - at least to  
> the
> extent that CLSQL needs it.  IIRCC, I think he (KR) has mentioned this
> in a couple places (cll?).
>
>
>> This may be completely wrong, but I'm as sure as I can be (for  
>> someone
>> who doesn't pay enough attention to this stuff) that people use CLSQL
>> with CCL regularly and that it's "working".
>
> Yes, as I mentioned, I've used it for real stuff with CCL on both Mac
> and Linux X8664 (and Linux x8632 with ACL and CCL).
>
> /Jon
>
>
>>
>> On Sun, 19 Jul 2009, Ron Garret wrote:
>>
>>> There's CL-MYSQL, CLSQL, and a RYO (roll-your-own) that I did a long
>>> time ago.  None of them are working (the RYO comes closest at the
>>> moment), so I have my usual question: anyone have a MySQL  
>>> interface up
>>> and running that they like and can recommend before I just pick one
>>> and dive into trying to get it to work?
>>>
>>> Thanks,
>>> rg
>>>
>>> _______________________________________________
>>> Openmcl-devel mailing list
>>> Openmcl-devel at clozure.com
>>> http://clozure.com/mailman/listinfo/openmcl-devel
>>>
>>>
>> _______________________________________________
>> Openmcl-devel mailing list
>> Openmcl-devel at clozure.com
>> http://clozure.com/mailman/listinfo/openmcl-devel
>