Re: [sqlite] about encrypting

[Kees Nuyt]

On Tue, 18 Nov 2008 11:34:15 -0200, "perperino pomulo"
<[EMAIL PROTECTED]> wrote in General Discussion of SQLite
Database :

>Hello.
>First I want to apologise because my english is very poor.
>
>I have an aplication that contains an SQLite 2.1 database. This application
>was made in visual basic 6 and i use the ags_sqlite dll to manage the
>database. Now i need to encrypt the data base.
>The problem is that i have different tables with diferent data types so it
>is complicated to encrypt data before insert it into database. Beside of
>this i have a textbox in which the user can perform sqlite querys so what i
>need is to encript the database itself.

On-the-fly encryption is a payed-for version of sqlite.

http://www.hwaci.com/sw/sqlite/prosupport.html

Perhaps you will have to add or change a C-call in your vb6
wrapper. 

>Looking on the internet i see that more recentlys version of sqlite support
>onthefly encryption, then my question is if there are any way to implement
>it on visual basic 6.
>I'm testing this: http://tannertech.net/sqlite3vb/

Indeed I doubt that will work with SQLite 2.1. Conversion is
easy: sqlite2 your.db.v2 .dump | sqlite3 your.db.v3 ,
although it might be better do do it in another way, for
example in order to specify non-default 'sticky' PRAGMAs.

>the syntax is very similar to the ags's and works fine, but the problem is i
>don't know how to create an encrypted database and then how to open it.
>
>If somebody can bring me any idea i papreciate it. thanks.

HTH
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] about encrypting

[perperino pomulo]

Hello.
First I want to apologise because my english is very poor.

I have an aplication that contains an SQLite 2.1 database. This application
was made in visual basic 6 and i use the ags_sqlite dll to manage the
database. Now i need to encrypt the data base.
The problem is that i have different tables with diferent data types so it
is complicated to encrypt data before insert it into database. Beside of
this i have a textbox in which the user can perform sqlite querys so what i
need is to encript the database itself.
Looking on the internet i see that more recentlys version of sqlite support
onthefly encryption, then my question is if there are any way to implement
it on visual basic 6.
I'm testing this: http://tannertech.net/sqlite3vb/
the syntax is very similar to the ags's and works fine, but the problem is i
don't know how to create an encrypted database and then how to open it.

If somebody can bring me any idea i papreciate it. thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users