Re: [sqlite] How to : encrypt the data of database table.

[Michael Stephenson]

Have a look at:

http://sqlcipher.net

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ashokkumar Gupta
Sent: Wednesday, September 14, 2011 1:53 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to : encrypt the data of database table.

Hi All,

Does sqlite has encryption feature or not. If yes, how to do it and if No,
then is there any work around by which we can have that feature ??

Regards,
Ashokkumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to : encrypt the data of database table.

[Robert Myers]

I added some functions to do that. I have ENCCOL, DECCOL, SIGCOL
(signature creation), CHECKSIG

Inserts and selects look something like this:
INSERT INTO TABLE x(col1) VALUES(ENCCOL(1))
SELECT DECCOL(col1) FROM x;

Nothing I want in an index can be encrypted, which is where SIGCOL comes
in, I can sign the columns and make sure that the signature is valid.
The code is far from portable, it's Windows specific, using the keys
associated with the account and APIs like CryptProtectData so the
databases themselves can't be transferred between machines.

There is also a (non-free) encryption version which we may be moving to
in the future. http://www.hwaci.com/sw/sqlite/see.html

On 9/14/2011 12:53 PM, Ashokkumar Gupta wrote:
> Hi All,
>
> Does sqlite has encryption feature or not. If yes, how to do it and if No,
> then is there any work around by which we can have that feature ??
>
> Regards,
> Ashokkumar
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to : encrypt the data of database table.

[Simon Slavin]

On 14 Sep 2011, at 6:53pm, Ashokkumar Gupta wrote:

> Does sqlite has encryption feature or not. If yes, how to do it and if No,
> then is there any work around by which we can have that feature ??

The free version of SQLite has no encryption feature.  There's a version with 
encryption which works exactly the same way, but you have to pay a one-time 
license fee for it.  You can find details at



You can do all your programming and testing with the free version, then change 
to the encryption version at the last moment without having to chance any of 
your programming (apart from putting in the password somewhere !).

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to : encrypt the data of database table.

[Ashokkumar Gupta]

Hi All,

Does sqlite has encryption feature or not. If yes, how to do it and if No,
then is there any work around by which we can have that feature ??

Regards,
Ashokkumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users