SQLite 3 support

[Lutz]

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



Lutz

[HPW]

Hello Lutz,



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

[Lutz]

Oops!  http://newlisp.org/downloads/development/sqlite3-cgi.txt">http://newlisp.org/downloads/developmen ... e3-cgi.txt">http://newlisp.org/downloads/development/sqlite3-cgi.txt



Lutz

[HPW]

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]

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]

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

Sounds promising!

;-)



So keep on.

(I am thinking about similar for a neobook plugin)