clsql, sqlite3 and prepared statements

Discussion of Common Lisp
Post Reply
sinnatagg
Posts: 29
Joined: Tue Apr 21, 2009 3:04 am

clsql, sqlite3 and prepared statements

Post by sinnatagg » Mon Oct 19, 2009 3: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
Posts: 613
Joined: Sun Jun 29, 2008 4:02 am
Location: Warsaw, Poland
Contact:

Re: clsql, sqlite3 and prepared statements

Post by ramarren » Mon Oct 19, 2009 10:35 pm

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

dmitry_vk
Posts: 96
Joined: Sat Jun 28, 2008 8:01 am
Location: Russia, Kazan
Contact:

Re: clsql, sqlite3 and prepared statements

Post by dmitry_vk » Mon Oct 19, 2009 10:35 pm

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.

Post Reply