On Thu, Jun 28, 2012 at 7:12 AM, <a...@zator.com> wrote: > Hi: > > Assuming using SEE, do is there the ability to decide what I/O operations > are to be performed encrypted or with the plain (as is) content? >
Encryption is turned on and off at the database level. So either an entire database file is completely encrypted or none of it is. You cannot encrypt some rows and leave others plaintext. But you can use the ATTACH <http://www.sqlite.org/lang_attach.html> command to connect two or more database files to your database connection at the same time, so that they look to your application as if they are a single file, and some subset of those files can be encrypted while another subset is plaintext. So if you can arrange your schema such that encrypted content goes in one set of tables, and you put those tables in one database file, and your plaintext data goes in a separate set of tables and those tables go in a different database file, then you can have some content encrypted and other content not encrypted. > > I'm planning an application with only selected data encripted (in each row > of certain tables, there is a flag showing the encrypted/plain state). > > Thanks in advance. > > > > > ---- Mensaje original ---- > > De: Richard Hipp <d...@sqlite.org> > > Para: Paul Vercellotti <pverce...@yahoo.com>, General Discussion of > SQLite Database <sqlite-users@sqlite.org> > > Fecha: Wed, 27 Jun 2012 21:28:30 +0200 > > Asunto: Re: [sqlite] SQLite Encryption Extension Performance? > > > > > >SEE is a drop-in replacement for public-domain SQLite. In other words, it > >will read and write ordinary unencrypted database files, and it will do so > >with no speed penalty. > > > >For performance sensitive applications, what developers sometimes do is > >break up their content into sensitive and non-sensitive, storing each in > >separate databases, and only encrypt the sensitive content. SEE is able > to > >open both databases at once (using the ATTACH command) and do joins on > >tables between the two databases, even though only one of the two is > >encrypted. > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
