Stack Overflow
Stack Overflow

Questions tagged [clsql]

A multi-platform SQL interface for Common Lisp.

A multi-platform SQL interface for Common Lisp.

CLSQL is a SQL database for Common Lisp interface maintained by Kevin M. Rosenberg. CLSQL uses the Universal Foreign Function Interface (UFFI) library for broad compatibility.

CLSQL is compatible with AllegroCL, Lispworks, SBCL, CMUCL, and OpenMCL. It has been tested with Microsoft Windows, Linux, Solaris, FreeBSD on a number of different CPU architectures.

Source: http://clsql.b9.com/

35 questions
0
votes
1 answer

CLSQL timestamp Column Type

I'm using CLSQL with MySQL. What combination of keywords do I have to pass to create-table in order to give it a column with the timestamp column type? (create-table [foo] `(([bar] timestamp))) is unrecognized (it just creates a varchar 255 column,…
Inaimathi
  • 13,853
  • 9
  • 49
  • 93
0
votes
1 answer

How to write a function that uses sqlite to connect to the database and query data in lisp

I have written this function: (defun load-db (filename) (with-open-file (in filename) (with-standard-io-syntax (setf *db* (read in))))) I have a database in local called xx.db, I want to use sqlite to connect it and something I can…
Yihong Theis
  • 1
  • 1
0
votes
1 answer

cl-dbi query mysql from sbcl with error - Illegal :UTF-8 character starting at position 18

Today try to use cl-dbi and do some query to mysql. But it failed with following error: debugger invoked on a BABEL-ENCODINGS:INVALID-UTF8-STARTER-BYTE in thread #: Illegal :UTF-8 character starting at…
Amitabha
  • 1,693
  • 2
  • 25
  • 42
0
votes
1 answer

CLSQL trouble using MySQL as backend on windows

I'm using SBCL on Windows. I got an error When I attempted to connect MYSQL using CLSQL like this. (ql:quickload :clsql) (clsql:connect '("localhost" "database-name" "database-user-name" "password") :database-type :mysql) Couldn't load…
1ambda
  • 1,145
  • 8
  • 19
0
votes
2 answers

How to special the mysql sock path in clsql?

When I connected to mysql using clsql,the following error occurred While trying to connect to database localhost:3306/root/ using database-type MYSQL: Error 2002 / Can't connect to local MySQL server through socket…
user2151310
  • 1
1 2
3