Re: [sqlite] FTS4 - reversing the index to plain text

2012-09-04 Thread Pavel Hlavnicka
Simon, Dan thanks for your answers. Now it's clear the plain text can be (nearly) rebuilt and Dan's answer explains why the offsets() function has to access the original data. I was definitely evaluating the database encryption but it has some significant drawbacks. Encryption by using

Re: [sqlite] FTS4 - reversing the index to plain text

2012-09-04 Thread Simon Slavin
On 4 Sep 2012, at 3:37pm, Dan Kennedy wrote: > On 09/04/2012 07:51 PM, Pavel Hlavnicka wrote: >> Dear all, >> >> we are using sqlite FTS4 to build a fulltext index on data which >> should not be available to the user without a decryption inside the >> application. FTS4

Re: [sqlite] FTS4 - reversing the index to plain text

2012-09-04 Thread Dan Kennedy
On 09/04/2012 07:51 PM, Pavel Hlavnicka wrote: Dear all, we are using sqlite FTS4 to build a fulltext index on data which should not be available to the user without a decryption inside the application. FTS4 matches perfectly - we can use either contentless database or compress/uncompress

[sqlite] FTS4 - reversing the index to plain text

2012-09-04 Thread Pavel Hlavnicka
Dear all, we are using sqlite FTS4 to build a fulltext index on data which should not be available to the user without a decryption inside the application. FTS4 matches perfectly - we can use either contentless database or compress/uncompress parameters to encrypt the plain text data. My