AW: db encryption and multiuser question

[Tiemo Hollmann TB]

Hi Trevor,
yes, I have to do search and filter sqls on the datas, so there would only
be the external encryption, but I don't know yet, if I could use one of the
tools, like sqlite-crypt, or as Eric was pointing, Rev still has do some
work on sqlite, before you could use encryption.
Tiemo

> -----Ursprüngliche Nachricht-----
> Von: use-revolution-bounces at lists.runrev.com [mailto:use-revolution-
> bounces at lists.runrev.com] Im Auftrag von Trevor DeVore
> Gesendet: Dienstag, 5. Februar 2008 16:10
> An: How to use Revolution
> Betreff: Re: db encryption and multiuser question
> 
> On Feb 5, 2008, at 5:21 AM, Tiemo Hollmann TB wrote:
> 
> > 1. I have read a few times that you can't / should not use sqlite
> > for a
> > multiuser environment, instead you should take a "bigger" db as
> > valentine.
> > My question is, are there any hard facts to not use sqlite in a
> > multi user
> > environment? What would happen if my customers would read my db with
> > multiple users - just a little slow down or wouldn't it work at all?
> > Does
> > this point affect only if you have write statements on the db or
> > also if you
> > only have a read db?
> 
> <http://sqlite.org/whentouse.html>
> 
> Scroll down to "Situations Where Another RDBMS May Work Better" and
> look at "Client/Server Applications". If you have many users trying to
> write to the database file then you should probably look for a
> different solution. Multiple reads won't corrupt your database though.
> 
> > 2. What about encryption (just read Victoras answer). ... My
> > question: Is this because
> > I am not a db specialist and for any advanced "specialist" it
> > wouldn't be
> > any problem to get my datas out of my db with structure and "sence"
> > and
> > everybody should encrypt his data to avoid dumping or is it really
> > "only" a
> > question of securing private datas?
> 
> As Eric said your data is not safe as anyone could open the database
> and take a peak or perform a dump of the data. You can encrypt the
> data in Rev before storing in the database and then decrypt it when
> pulling the data out but be aware that you lose the ability to perform
> searches on that data using SQL. I believe encryption at the database
> level is really needed if you want to search the data.
> 
> Regards,
> 
> --
> Trevor DeVore
> Blue Mango Learning Systems
> www.bluemangolearning.com    -    www.screensteps.com
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution