Zeoslib Portal

Hi Mark,

I hope this is ok for the knowledge base. If so please move it there.

Thank you, Eike

Encryption support in SQLite with Zeos DBC components ChangeLog Version 1.0 - 08/08/2008 > First version of this article Overview As you may know SQLite supports transparent database file encrpytion. For this to work you need a commercial, but plattform independent SQLite plugin, available here: ht...

Hi Mark,

sorry for my late reply, but I got a son on February 27 So I was a little bit busy...

You can do with my "tutorial" whatever you want. Add it to the Knowledge Base if you think it is good enough. I clean it up a little and tell you when it's done.

Best regards, Eike

Thank you for your suggestions in the other thread! The documentation is for me, too - so at least it was a kind of self-interest .

And as I know from me daily work: The better the documentation, the better the patch and the faster it gets applied...

Best regards, Eike

Hi Mark, I've created a patch and a description how it works, see here: http://zeos.firmos.at/viewtopic.php?t=1674 I think the patch can be integrated in the main version, because it does not break any functionality and it works with and without encryption support in SQLite. But you should have a lo...

Hello everybody, as you may know SQLite supports transparent database file encrpytion. For this to work you need a commercial, but plattform independent SQLite plugin, available here: http://www.hwaci.com/sw/sqlite/prosupport.html#compress For Windows there is also a free SQLite3 version with encryp...

Hi Mark, I have it. The problem was my bad knowledge of Interface-Programming. I can call the GetPlainDriver like this: ZConnection1->Connected = true; IZSQLiteConnection *C; ZConnection1->DbcConnection->QueryInterface( Sysutils::StringToGUID("{A4B797A9-7CF7-4DE9-A5BB-693DD32D07D2}"), (voi...

Hi Mark, the encryption in SQLite is transparent, that means there are hooks in the library which need to be implemented for working encrpytion. If the hooks are implemented it's works (almost) without any required user actions. That means the SQLite library behaves as if there is no encryption. But...

Hi again,

so, TZConnection->DbcConnection is of Type "_di_IZConnection". How can I cast/convert this in C++ to "TZSQLiteConnection" (this has GetPlainDriver)? The usual ways "dynamic_cast", "static_cast", ... do not work.

Thank you!
Best regards, Eike

Hi Mark, at first: Thank you for your reply! :) TZConnection.DbcConnection.GetPlainDriver is a protected (or private) function and I can't access it without modifying the source code of ZeosLib. What I want to do is simple: I want to use SQLite3 as backend for my application to store some private us...

Hi, is it possible to directly acces the functions of the plain dbc driver over the ZConnection component? I have a ZConnection connected to a SQLite3 database and I need to call a function of the plain TZSQLitePlainDriver. Is this possible and how can I do it? I'm using BDS 2006. Thank you very muc...