Subject: Re: CL wrong step in the wrong direction?
From: rpw3@rpw3.org (Rob Warnock)
Date: Sat, 13 Sep 2003 07:05:03 -0500
Newsgroups: comp.lang.lisp
Message-ID: <Wr6dnbgWjIxymv6iXTWc-g@speakeasy.net>
thelifter <thelifter@gmx.net> wrote:
+---------------
| I will start a web-related project soon. I'm thinking about using
| CLISP, but I already know some drawbacks, e.g. if I need to program
| database access one day, I know it will not be easy, at least not as
| easy as from Java, where it is really a trivial task.
+---------------

Hey, dude, it's pretty trivial from Common Lisp, too!!
If you're using PostgreSQL, just grab Eric Marsden's "pg.lisp"
from <URL:http://www.chez.com/emarsden/downloads/> and you
can write stuff like this:

	 > (with-pg-connection (conn "my_data" "www")
	     (let* ((query "SELECT first, last, email FROM contact LIMIT 4")
		    (result (pg-exec conn query)))
	       (pg-result result :tuples)))

	 (("Joe" "Blow" "joeb@nowhere.com")
	  ("Betty" "Boop" NIL)
	  ("Sally" "Summers" "summergirl@example.domain")
	  ("Bart" "Ludd" NIL))
	 > 

If you're using MySQL or some other database, go look at
<URL:http://www.cliki.net/Database>. There's lots of free
stuff available...


-Rob

-----
Rob Warnock, PP-ASEL-IA		<rpw3@rpw3.org>
627 26th Avenue			<URL:http://rpw3.org/>
San Mateo, CA 94403		(650)572-2607