Robert Marlow | 27 May 06:04 2005

Event based CLSQL?

Hi

Does CLSQL (in particular clsql-postgresql-socket) support non-blocking
sockets for use in event-based servers?

--

-- 
Robert Marlow <bobstopper@...>
Kevin Rosenberg | 27 May 08:26 2005
Picon

Re: Event based CLSQL?

Robert Marlow wrote:
> Does CLSQL (in particular clsql-postgresql-socket) support non-blocking
> sockets for use in event-based servers?

Not that I'm aware of. If it does, it'd be completely coincidental. No
attempt has been made to support event-based servers.

--

-- 
Kevin Rosenberg
kevin@...
Peter BARABAS | 27 May 11:39 2005
Picon

CONNECT vs. paths

Hello,

Is it intentional that CONNECT doesn't accept paths, only strings? E.g.

;;;; *db-filename* is #p"/home/z0d/projects/quotes/database/quotes.db"
(connect (list *db-filename*) :database-type :sqlite3)

doesn't work, I get a type error.

Thanks for your help.

--

-- 
'(Yours parenthetically),
peter barabas.

((call/cc call/cc) (call/cc call/cc))
Frederic Ferrere | 27 May 14:46 2005
Picon

CLSQL ODBC Install problem

Hello,

first, i apologize about my english :)

i have a littre problem with SBCL, CLSQL, ODBC to connect to a Microsoft 
SQL SERVER 2000.

Configuration :
- Redhat fedora core 3
- SBCL 0.8.18
- unixODBC 2.2.9
- freeTDS 0.62.3

I have downloaded :
- rt-20040621
- uffi-1.4.37
- clsql-3.1.15

Under sbcl :
(require :asdf)
(push #P"/my-home-dir/rt-20040621/" asdf:*central-registry*)
(push #P"/my-home-dir/uffi-1.4.37/" asdf:*central-registry*)
(push #P"/my-home-dir/clsql-3.1.15/" asdf:*central-registry*)
(asdf:operate 'asdf:load-op 'clsql)
(clsql:connect '("ip-address-sql-server-2000" "login" "password") 
:database-type :odbc)

Error message :
; loading system definition from
; #P"/my-home-dir/clsql-3.1.15/clsql-odbc.asd" into
(Continue reading)

Frederic Ferrere | 27 May 16:58 2005
Picon

Re: CLSQL ODBC Install problem

Hello,

i solved my problem : bad unixODBC configuration.

Thanks
--
F.F.
Kevin Rosenberg | 27 May 19:14 2005
Picon

Re: CLSQL ODBC Install problem

Frederic Ferrere wrote:
> i solved my problem : bad unixODBC configuration.

Yes, unixODBC requires system and user level configuration files. Glad
to hear you solved your problem.

--

-- 
Kevin Rosenberg
kevin@...
Kevin Rosenberg | 27 May 19:20 2005
Picon

Re: CONNECT vs. paths

Peter BARABAS wrote:
> Is it intentional that CONNECT doesn't accept paths, only strings? E.g.

Yes, http://clsql.b9.com/manual/sqlite3.html#id2624768 states that the
connection-spec requires a string.

> ;;;; *db-filename* is #p"/home/z0d/projects/quotes/database/quotes.db"
> (connect (list *db-filename*) :database-type :sqlite3)
> doesn't work, I get a type error.

That's to be expected.

That said, it's likely that CLSQL could be extended to accept a
pathname as well and the documentation updated to include this
functionality. The ease of this extension will depend upon how much
the connection-spec processing that is common amongst backends expects
a string in that position.

So, while pathnames may be a future extension, you're safest plan is
to convert the pathname to a namestring so that current and future
versions of CLSQL will work with your application.

--

-- 
Kevin Rosenberg
kevin@...

Gmane