From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.54) id 1FJCKl-0001rU-T7 for garchives@archives.gentoo.org; Tue, 14 Mar 2006 16:25:20 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5.20060308/8.13.5) with SMTP id k2EGOckj012374; Tue, 14 Mar 2006 16:24:38 GMT Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.204]) by robin.gentoo.org (8.13.5.20060308/8.13.5) with ESMTP id k2EGObDC032114 for ; Tue, 14 Mar 2006 16:24:38 GMT Received: by nproxy.gmail.com with SMTP id l37so1123183nfc for ; Tue, 14 Mar 2006 08:24:37 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=oOHhjGG7fou10gDpg7D1W5b9CTEYlwkkbPd9hMHoygERXl9p+RAbON27/3JA95BXvd1rzXs37R5YsmbzVs/kvGiSpbvRVGc70Z9K9/FPvWNJHPLL92BDqkYzV7njily2CDcgIkWkL0lADWGoVX8FPCcIOLIoYBQS4Qa568TCr7A= Received: by 10.49.12.14 with SMTP id p14mr1389857nfi; Tue, 14 Mar 2006 08:24:37 -0800 (PST) Received: by 10.49.29.4 with HTTP; Tue, 14 Mar 2006 08:24:37 -0800 (PST) Message-ID: Date: Tue, 14 Mar 2006 18:24:37 +0200 From: tvali To: gentoo-portage-dev@lists.gentoo.org Subject: Re: [gentoo-portage-dev] Few things, which imho would make portage better In-Reply-To: <4416E6F1.8090904@gebeco.de> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-portage-dev@gentoo.org Reply-to: gentoo-portage-dev@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <4416A4C1.6090903@gentoo.org> <4416D6C6.8000502@gentoo.org> <4416E6F1.8090904@gebeco.de> X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id k2EGObDC032114 Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by robin.gentoo.org id k2EGOcm3012374 X-Archives-Salt: 2d5a1c2e-76a3-420c-9546-2d098b330d87 X-Archives-Hash: 470eb6b9ddf259d706d09c7a22dd5581 I didnt think of case Item1, Item2, Item3. I thought of cases, for example, where i use Id field as TableName and IdInThatTable, where TableName shows, which table this IdInThatTable points and so on. I dont use, too, Item1/2/3 :) I just use tables sometimes in a more generalized form, where it's hard to say from table name or fields, what it is supposed to contain, as it contains different things in different cases -- therefore allowing me to make more functionality to general datastructures rather than writing specific tables with specific functions. Anyway, this is an example -- i just think that normalizing makes it so that there is 1 way to do things, but i like to rethink any specific case (and in some cases, normalized table just appears best to me, but not because it's normalized). Nothing more. Anyway, i think that this is not a topic to discuss in this list :) I think that db-app otimizations was best argument ever possible on side of normalization -- others are those, which will appear to me, too, but i havent much thought about which db's are optimized to which structures -- and this seems so that as normalization is in, any engines probably really are optimized for that. 2006/3/14, Johannes Fahrenkrug : > tvali wrote: > > >I will consider what you sayd about db app design. > > > >Anyway, i usually try to keep tables more dynamic and look at task at > >hand, trying to make tables specially for it. When i tested > >normalizing, i got about 60 tables where i had 5 without normalizing. > > > > > I'm not a Gentoo dev, but a programmer who deals with software and db > design issues every day. > Normalizing your data structures keeps them - and the apps that use the= m > - flexible. > > Of course a table with fields like "customernr, customername, item1, > item2, item3" is easier to create and smaller > than one table for the customers and one for items. But what if there's > a 4th and a 5th item? You have to change > your table and every place in your app that uses it (which should only > be one). > > I assume you're also not too fond of design patterns because some > require you to create 5 classes for something you could do with one ;-)= ... > > - Johannes. > > > -- > gentoo-portage-dev@gentoo.org mailing list > > -- tvali (e-mail: "qtvali@gmail.com"; msn: "qtvali@gmail.com"; icq: "317-492-912") =DChe eesti internetifirma lehel kohtasin tsitaati: If you don't do it excellently, dont do it at all. Because if it's not excellent, it won't be profitable or fun, and if you're not in business for fun or profit, what the hell are you doing here? Robert Townsend --=20 gentoo-portage-dev@gentoo.org mailing list