newLISP Fan Club

Forum => newLISP newS => Topic started by: Lutz on November 12, 2004, 09:19:09 AM

Title: SQLite 3 support
Post by: Lutz on November 12, 2004, 09:19:09 AM
SQLite 3 support has been added. For details see: http://www.newlisp.org/index.cgi?page=News



Lutz
Title:
Post by: HPW on November 12, 2004, 10:12:21 AM
Hello Lutz,



Sounds good. Could you post sqlite3.cgi with another extension, so that we can download it?
Title:
Post by: Lutz on November 12, 2004, 11:30:26 AM
Oops!  http://newlisp.org/downloads/development/sqlite3-cgi.txt



Lutz
Title:
Post by: HPW on April 25, 2005, 12:16:00 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.
Title:
Post by: Lutz on April 25, 2005, 02:39:53 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
Title:
Post by: HPW on April 25, 2005, 10:30:30 PM
Quote....a little more work ....


Sounds promising!

;-)



So keep on.

(I am thinking about similar for a neobook plugin)