You are not logged in.
Pages: 1
with wxsqlite it works but i need a DB Explorer
Thanks
i need encryption in Delphi Win64, so i need the external DLL.
For the 64bit variant I have to take the SQLite DLL from https://github.com/utelle/wxsqlite3/releases, right?
Is there a database viewer that supports this encryption?
Is it included in main repository?
thank you @ab, for your explanations. I would have to check that again. But I think we exceed the 16 MB limit also not. And the files are rarely changed.
What are the difficults to support GridFS? Aside from that, who programmed it.
Any news on this project? Win64 Support,...Does it make sense to update to the latest version of SpiderMonkey?
Thanks
according to my first post,
This code should work, but it does not.
Can someone take a look on this, please.
thanks
var
sql : TSQLDatabase;
blob : TSQLBlobStream;
memory : TMemoryStream;
begin
sql := TSQLDatabase.Create('d:\temp\test.db');
try
sql.Execute('CREATE TABLE IF NOT EXISTS "files" ("UID" INTEGER PRIMARY KEY AUTOINCREMENT, "Filename" TEXT NOT NULL, "File" BLOB);');
memory := TMemoryStream.Create;
memory.LoadFromFile('d:\temp\v\DOCUMENT_2013-20280_2013_05_14_11_14_31.XML');
memory.Position := 0;
sql.Execute('INSERT INTO files (Filename) VALUES ("'+StringToUTF8('DOCUMENT_2013-20280_2013_05_14_11_14_31.XML')+'")');
blob := sql.Blob('main','files','File',0,true); <------------ cannot open value of type null extended_errcode=1
blob.CopyFrom(memory,memory.Size);
memory.Free;
blob.Free;
finally
sql.Destroy;
end;
Your path is not correct.
Try 'd:\temp\test.db' instead of 'test.db'.
dosn't work.
https://www.sqlite.org/c3ref/blob_open.html say the dbname is called 'main', but it also does not work
But why do you use sql.Blob() ?
Use a regular SELECT statement with ColumnBlob() on the TSQLDatabase.
It would be much faster and safer.
sorry, i can't find some example or documentation to read / write binary blobs
Can't obtain Blob direct from SQLite
Which DBName is correct?
var
sql : TSQLDatabase;
blob : TSQLBlobStream;
memory : TMemoryStream;
begin
sql := TSQLDatabase.Create('d:\temp\test.db');
try
sql.Execute('CREATE TABLE IF NOT EXISTS "files" ("UID" INTEGER PRIMARY KEY AUTOINCREMENT, "Filename" TEXT NOT NULL, "File" BLOB);');
memory := TMemoryStream.Create;
memory.LoadFromFile('d:\temp\v\DOCUMENT_2013-20280_2013_05_14_11_14_31.XML');
memory.Position := 0;
sql.Execute('INSERT INTO files (Filename) VALUES ("'+UTF8Encode('DOCUMENT_2013-20280_2013_05_14_11_14_31.XML')+'")');
blob := sql.Blob('test.db','files','File',0,true); <------------ no such table test.db.files extended_errcode=1
blob.CopyFrom(memory,memory.Size);
memory.Free;
blob.Free;
finally
sql.Destroy;
end;
+1 for GridFS please
Any contribution is welcome!
:-)
i do my best.
I have to look also for PDF/A-3 support.
Could it be difficult to integrate the full XMP support?
Pages: 1