Page 1 of 1

clsql, sqlite3 and prepared statements

Posted: Mon Oct 19, 2009 3:30 pm
by sinnatagg
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é

Re: clsql, sqlite3 and prepared statements

Posted: Mon Oct 19, 2009 10:35 pm
by ramarren
There is cl-sqlite which uses prepared statements as primary query mechanism.

Re: clsql, sqlite3 and prepared statements

Posted: Mon Oct 19, 2009 10:35 pm
by dmitry_vk
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.