This is a read-only archive of lispforum.com. The forum was locked to new users and posts and is preserved here as static HTML from a database snapshot taken on 2019-09-07.

clsql, sqlite3 and prepared statements

3 posts · 1715 views

sinnatagg

#1 Mon Oct 19, 2009 10:30 pm

Apparently there is no prepared statement support for SQLite3 in the clsql library. Has anybody managed to hack this in somehow ? Or is there some other library that lets you use prepared statements with SQLite3 ?

-andré

ramarren Administrator

#2 Tue Oct 20, 2009 5:35 am

Re: clsql, sqlite3 and prepared statements

There is cl-sqlite which uses prepared statements as primary query mechanism.

dmitry_vk

#3 Tue Oct 20, 2009 5:35 am

Re: clsql, sqlite3 and prepared statements

sinnatagg wrote:Apparently there is no prepared statement support for SQLite3 in the clsql library. Has anybody managed to hack this in somehow ? Or is there some other library that lets you use prepared statements with SQLite3 ?

You can use http://common-lisp.net/project/cl-sqlite/. I consider clsql to be a "toy" library - it is a _huge_ bottleneck for performance and for memory allocation.