Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #38296

Re: Improve reduce functions of SQLite3 request

Show all headers | View raw

On Wed, 6 Feb 2013 09:18:58 +0000 (UTC), Steffen Mutter
<steffen@webanimations.de> declaimed the following in
gmane.comp.python.general:

> Actually I am fixing bugs and think about the user managment and
> permission handling and privacy of data.
> 
> Just give you a peek:
> referees need to be kept safe. 
> But they need to be planned and stored in the DB.
> How to handle this?
> I think I use GnuPG. 
> Every referee and referee-date-planner needs a private and public key so
> only these persons can see it, the planner every referee he dates and
> the referee only these games he is planned for.
> 
>  You see: a lot of work to do - after fixing some bugs and get the
> <select id="team" size=7 multiple> to work, that will be a big task... 

	If this is meant to be a web-based system, you probably should be
looking into using some sort of framework: Django, Zope/Plone, etc.
These often have at least two classes of users (controlling what
operations they are permitted to perform), if not more, with session
management controls.

	Most of these frameworks use some form of object-relational mapper
(ORM) to go between Python code objects (each table is a class, and each
record is an object instance, to put it is very general terms) and the
database itself.

	Problem with going that route is that you really need to normalize
the database (as soon as you said you just dump everything into one
table I shuddered), since a lot of the capability is tied to using
foreign key linkages to filter data.

	You shouldn't need the public key cryptography system since the
application itself should be able to control visibility of the data
using some privilege table and a log-in identifier. Using PKCS to
encrypt data would mean the creator of that data would be unable to edit
it, as they'd need the private key to decrypt it for editing. Not to
mention you'd need to have a way of transmitting the keys to the
appropriate people. If you kept the keys on the database, you'd then
need a secure way to ensure the proper key for the user was picked --
anything that secure could be used to control the direct access to the
data itself without encrypting it.

-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
        wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-03 09:46 +0000
  Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-03 13:11 -0500
    Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-04 14:30 +0000
      Re: Improve reduce functions of SQLite3 request Dave Angel <davea@davea.name> - 2013-02-04 10:30 -0500
      Re: Improve reduce functions of SQLite3 request Peter Otten <__peter__@web.de> - 2013-02-04 17:29 +0100
      Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-04 15:45 -0500
        Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-04 22:05 +0000
          Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-04 18:47 -0500
            Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-06 09:18 +0000
              Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-06 12:26 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-06 23:33 +0000
                Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-07 00:40 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-07 11:33 +0000
                Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-07 13:03 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-07 22:54 +0000
                Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-08 12:17 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-08 19:59 +0000

csiph-web