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

Groups > comp.lang.python > #38467

Re: Improve reduce functions of SQLite3 request

Show all headers | View raw

On Thu, 7 Feb 2013 22:54:03 +0000 (UTC), Steffen Mutter
<steffen@webanimations.de> declaimed the following in
gmane.comp.python.general:

> 
> I prefer a table, because it's easy to drop or backup whenever I want
> :-)
>

	Well... backing up the entire database is simple in SQLite3 -- just
make a copy of the file <G>

	And operations like:

	delete from <table> where season = "20122013"; 

doesn't seem that difficult.

	If you use separate tables you make it more difficult to generate
the SQL (as you have to create the SQL with the season specific table
name, instead of just using a "where ...." clause to restrict data), and
lose the potential to produce reports covering multiple seasons.
 

	<snip> 
> All this data shall be displayed according to the status the user has.
> 
> Complex, hm :-) ?
> 
> So, what would be nice is to diplay the data for the game, when you
> klick on the game-number. If you klick on a players name, its data would
> be nice to show: Games played in the actual seasion games played in
> life, goals scored , yellow cards, 2min punishmends and red cards and
> persons banned for lifetime won't show up at all :-)
>  BUT: only for those ersons who are allowed to see it: trainers
> responsible for the team 
> the player 
> the other players in the team
> 
	Have you considered defining "views" and "triggers" -- based upon
the user privileges you run queries using views that only expose the
permitted data (and use triggers to permit properly updating the
underlying tables when edited).

	Fuller DBMS would allow you to define access controls on individual
columns -- though it would mean you couldn't made the main database
connection until you know the access level of the user, as you'd connect
using a name/password specific to the level of the user (I'm not saying
each user has a database name/password, though that is an alternative --
it just means you'd have to do a lot of database administration each
time a user is created).
-- 
	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