SQLite 3 support

Lutz · Post by **Lutz** » Fri Nov 12, 2004 5:19 pm

SQLite 3 support has been added. For details see: http://www.newlisp.org/index.cgi?page=News

Lutz

HPW · Post by **HPW** » Fri Nov 12, 2004 6:12 pm

Hello Lutz,

Sounds good. Could you post sqlite3.cgi with another extension, so that we can download it?

Lutz · Post by **Lutz** » Fri Nov 12, 2004 7:30 pm

Oops! http://newlisp.org/downloads/developmen ... e3-cgi.txt

Lutz

HPW · Post by **HPW** » Mon Apr 25, 2005 7:16 pm

Any plans to add blob support to the SQLite 3 modul?

Export Blob-field to binary file
Import binary File to Blob-field
Export Blob-field to memory
Import memory to Blob-field

PS: The last link is no more valid and can be deleted.

Lutz · Post by **Lutz** » Mon Apr 25, 2005 9:39 pm

BLOB handling is prepared but not finished yet. If you add the line:

(import library "sqlite3_column_blob" "cdecl")

in the section where the import are made, you will get BLOBs handled like 'C' strings, this means the blob received will stop at the first binary zero encountered. To receive BLOBs with embedded zeros a little more work has to be done in sqlite3.lsp. I will put it on my list of things to do.

Lutz

HPW · Post by **HPW** » Tue Apr 26, 2005 5:30 am

....a little more work ....

Sounds promising!
;-)

So keep on.
(I am thinking about similar for a neobook plugin)