by Otto » Wed Oct 16, 2024 12:22 pm
Hello friends,
For my DBF files, I'm testing an approach like this.
I initially wanted to use AES (fwrite()), but then I wouldn't have full-text search capabilities, and I think FTS wouldn't work even with TDE.
This type of encryption I use now isn't entirely secure, but since only we use this system, I think it's sufficiently secure.
If you use symmetric encryption based on a specific method, such as ASCII conversion followed by encryption with a code, you could transform the search term in the same way.
Here are the steps you should consider:
Preparation of the search term: Convert the search term into the same format you used for the data in the DBF file (e.g., ASCII conversion).
Application of the encryption: Apply the same encryption algorithm to the transformed search term. This will give you an encrypted search term.
Searching in the encrypted data: Then, search for the encrypted search term in the DBF files.
It’s important to note that this method only works if you apply the exact same transformation to both the stored data and the search terms.
Additionally, complex search operations (like substring searches) may be difficult since you can only look for exact matches.
Furthermore, this method could be vulnerable to attacks if the encryption algorithm or code becomes known.
Best regards,
Otto
********************************************************************
mod harbour - Vamos a la conquista de la Web
modharbour.org
https://www.facebook.com/groups/modharbour.club********************************************************************