Re: [sqlite] encrypted file
Sorry for my mistake. I was creating database using sqlite3 API and trying to open it with sqlite command line client version 2.7 Thanks a lot. Lloyd. On Wed, 2006-10-25 at 11:51 +0530, Lloyd wrote: > Thanks for your informative reply. > > I would like to know, whether I can open a database which is created > using the sqlite API from a program, using the sqlite command line > client? > > [I tried it using sqlite and it shown the > following error- > > Unable to open database "/root/userdb": file is encrypted or is not a > database . > > How can I open the database using sqlite command line? ] > > Thank you very much. > > Lloyd. > > > > > On Tue, 2006-10-24 at 11:02 +, [EMAIL PROTECTED] wrote: > > Lloyd <[EMAIL PROTECTED]> wrote: > > > Hi List, > > > Whether the data base which we create through the program will be in > > > encrypted form? > > > > The public-domain version of SQLite does not encrypt the data. > > But commerical extensions that encrypt the data are available. > > See, for example, http://www.hwaci.com/sw/sqlite/prosupport.html#crypto > > > > > > > > If yes, how can I see the result in sqlite? (How can use select > > > statements on this database?) > > > > > > My application creates a database and to analyze the results in the > > > database, it will be easy for me to use the interface provided by the > > > sqlite. How can I open the database in SQLite ? > > > > > > > When a database is encrypted you must supply the encryption key > > before reading or modifying the database. You can do this in > > several ways. There is a pragma: > > > >PRAGMA key=? > > > > If the database is being loaded using an ATTACH statement then > > you specify the key in the USING clause of the ATTACH: > > > >ATTACH DATABASE 'encrypted.db' AS e2 USING :key > > > > Or you can use the C/C++ API: > > > >sqlite3_key(db, zKey); > > > > Once the key is established, the database content is automatically > > decrypted as it is read from the disk and reencrypted as it is > > written back to the disk. > > > > If you use the command-line client, there is a special option > > to specify the key: > > > >sqlite3 -key 'hello' database.db > > > > > > After that the command-line client works just like it normally > > does. > > > > None of the above works in the public domain version of SQLite. > > You have to purchase a license for a version of SQLite that > > supports encryption in order to use these features. > > > > -- > > D. Richard Hipp <[EMAIL PROTECTED]> > > > > > > - > > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] encrypted file
Thanks for your informative reply. I would like to know, whether I can open a database which is created using the sqlite API from a program, using the sqlite command line client? [I tried it using sqlite and it shown the following error- Unable to open database "/root/userdb": file is encrypted or is not a database . How can I open the database using sqlite command line? ] Thank you very much. Lloyd. On Tue, 2006-10-24 at 11:02 +, [EMAIL PROTECTED] wrote: > Lloyd <[EMAIL PROTECTED]> wrote: > > Hi List, > > Whether the data base which we create through the program will be in > > encrypted form? > > The public-domain version of SQLite does not encrypt the data. > But commerical extensions that encrypt the data are available. > See, for example, http://www.hwaci.com/sw/sqlite/prosupport.html#crypto > > > > > If yes, how can I see the result in sqlite? (How can use select > > statements on this database?) > > > > My application creates a database and to analyze the results in the > > database, it will be easy for me to use the interface provided by the > > sqlite. How can I open the database in SQLite ? > > > > When a database is encrypted you must supply the encryption key > before reading or modifying the database. You can do this in > several ways. There is a pragma: > >PRAGMA key=? > > If the database is being loaded using an ATTACH statement then > you specify the key in the USING clause of the ATTACH: > >ATTACH DATABASE 'encrypted.db' AS e2 USING :key > > Or you can use the C/C++ API: > >sqlite3_key(db, zKey); > > Once the key is established, the database content is automatically > decrypted as it is read from the disk and reencrypted as it is > written back to the disk. > > If you use the command-line client, there is a special option > to specify the key: > >sqlite3 -key 'hello' database.db > > > After that the command-line client works just like it normally > does. > > None of the above works in the public domain version of SQLite. > You have to purchase a license for a version of SQLite that > supports encryption in order to use these features. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] encrypted file
Lloyd <[EMAIL PROTECTED]> wrote: > Hi List, > Whether the data base which we create through the program will be in > encrypted form? The public-domain version of SQLite does not encrypt the data. But commerical extensions that encrypt the data are available. See, for example, http://www.hwaci.com/sw/sqlite/prosupport.html#crypto > > If yes, how can I see the result in sqlite? (How can use select > statements on this database?) > > My application creates a database and to analyze the results in the > database, it will be easy for me to use the interface provided by the > sqlite. How can I open the database in SQLite ? > When a database is encrypted you must supply the encryption key before reading or modifying the database. You can do this in several ways. There is a pragma: PRAGMA key=? If the database is being loaded using an ATTACH statement then you specify the key in the USING clause of the ATTACH: ATTACH DATABASE 'encrypted.db' AS e2 USING :key Or you can use the C/C++ API: sqlite3_key(db, zKey); Once the key is established, the database content is automatically decrypted as it is read from the disk and reencrypted as it is written back to the disk. If you use the command-line client, there is a special option to specify the key: sqlite3 -key 'hello' database.db After that the command-line client works just like it normally does. None of the above works in the public domain version of SQLite. You have to purchase a license for a version of SQLite that supports encryption in order to use these features. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] encrypted file
Hi List, Whether the data base which we create through the program will be in encrypted form? If yes, how can I see the result in sqlite? (How can use select statements on this database?) My application creates a database and to analyze the results in the database, it will be easy for me to use the interface provided by the sqlite. How can I open the database in SQLite ? Thanks, Lloyd. __ Scanned and protected by Email scanner - To unsubscribe, send email to [EMAIL PROTECTED] -
