Encrypt/decrypt database with wsSQlite /Lazarus

[kjteng]

Nice Unfortunately I don't have a license for SEE. So all we can do for now is to hope that we get everything right.

Some questions though:
- Is this change part of your file on github?
- Any chance for you to clone Zeos on Github and make the changes there?

Best regards,

Jan

- Yes. I have uploaded my latest file to github
- I have cloned it but not sure whether I have done it corrrectly. Can I upload it to https://github.com/marsupilami79/zeosli ... er/src/dbc ?

[aehimself]

No, you can not. What you can do is:
- Clone the WHOLE Zeos repository to your own GitHub profile (this is called forking)
- Clone your own clone of Zeos repository in your own GitHub profile to your local PC
- Make any modifications on your PC
- Once all done and accounted for, push the changes back to GitHub (which will go to your own clone of Zeos on your GitHub)
- Open a pull request against Jan's Github repo. This way he can extract the diffs only and apply it to SVN.

[aehimself]

It works !

Out of curiosity, does it work if you put this code in BeforeConnect / AfterConnect event handler?
That way encryption would be supported without having to change the code.

@Jan,
I seem to recall a discussion when you mentioned that pragma's aren't supported before we establish the connection - isn't that what happens here?
If yes, maybe we could make a new event handler called InitializeEncryption or similar which could be used for sending such commands the right place and time if needed.

[kjteng]

Hi aehimself:
Thanks for the pointer on the github procedures.
The pragma codes will not works if it is put in before connect or after connect. By trial and error, I found that wxSqlite decryption works only if the pragma statements are called after 'FPlainDriver.sqlite3_open(....)' but before the 'inherited open' (in procedure TZSQLiteConnection.Open;).
Regards

[kjteng]

I have updated and tested my amendment for the latest version of zeoslib (Merged revision(s) 7863 from branches/8.0-patches).
The modified file (ZDbcSqLite.pas) is available at :- https://github.com/kjteng/zeoslib/tree/main/ZDbcSqLite
The older version has been renamed to ZDbcSqLite2.pas