Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #38150
| From | Dennis Lee Bieber <wlfraed@ix.netcom.com> |
|---|---|
| Subject | Re: Improve reduce functions of SQLite3 request |
| Date | 2013-02-04 18:47 -0500 |
| Organization | > Bestiaria Support Staff < |
| References | <kelbl0$1jv$1@nerdhammel.gnuher.de> <mailman.1317.1359915110.2939.python-list@python.org> <keogmb$dml$1@nerdhammel.gnuher.de> <mailman.1331.1360010737.2939.python-list@python.org> <kepbak$ne$1@nerdhammel.gnuher.de> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.1340.1360021639.2939.python-list@python.org> (permalink) |
On Mon, 4 Feb 2013 22:05:08 +0000 (UTC), Steffen Mutter
<steffen@webanimations.de> declaimed the following in
gmane.comp.python.general:
> There's much more stuff in the table of the database, but these ones
> does not matter, the table Runde20122013 stores all the data needed for
> gameplay during this season and is made to handle ALL leagues in germany
> and if you enter another federation name as 'dhb' it could handle even
> more...
> Jutst to explain: the numbers define the team(s) of the club in a
> special category (male/female, youth E,D,C,B,A adults, senior), playing
> in a league.
Which does, to me, imply an unnormalized database. The
"team/category" should be a separate field.
club(*ID*, name)
team(*ID*, /club/, category)
{where *..* is primary key, /../ is a foreign key}
and league should probably be another table (and "club" may have a
/league/ entry).
Yes, that would imply using JOINs to get a full identifier, and
maybe more complex GROUP BY terms...
> Woha!
> Why didn't I get this out by myself?
Well, I only got the idea after someone else mentioned using min();
but I don't recall if they had GROUP BY in that suggestion. GROUP BY
ensures the min() only applies when the "nr" is the same.
--
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
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