Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.020 X-Spam-Evidence: '*H*': 0.96; '*S*': 0.00; 'resulting': 0.04; '(even': 0.05; 'debug': 0.07; 'duplicate': 0.07; 'file)': 0.09; 'subject:into': 0.09; 'cc:addr:python-list': 0.11; '-tkc': 0.16; 'from:addr:python.list': 0.16; 'from:addr:tim.thechases.com': 0.16; 'from:name:tim chase': 0.16; "he'd": 0.16; 'inability': 0.16; 'wrote:': 0.18; 'separate': 0.22; 'cc:addr:python.org': 0.22; 'choices': 0.24; 'cc:2**0': 0.24; 'cc:no real name:2**0': 0.24; 'tables': 0.26; 'least': 0.26; 'header:In-Reply-To:1': 0.27; 'especially': 0.30; 'subject:Database': 0.31; 'table,': 0.31; 'file': 0.32; '(including': 0.33; 'table': 0.34; 'but': 0.35; 'there': 0.35; 'method': 0.36; 'charset:us-ascii': 0.36; 'wrong': 0.37; 'easily': 0.37; 'being': 0.38; 'files': 0.38; 'that,': 0.38; 'does': 0.39; 'future': 0.60; 'issues,': 0.61; 'new': 0.61; 'field': 0.63; 'skip:n 10': 0.64; 'email addr:yahoo.com': 0.64; 'more': 0.64; 'difficulty': 0.68; 'to:addr:yahoo.com': 0.81; 'exceeding': 0.84; 'pain': 0.84; 'received:50.22': 0.84; 'either:': 0.91 Date: Tue, 12 Nov 2013 05:30:05 -0600 From: Tim Chase To: rurpy@yahoo.com Subject: Re: To whoever hacked into my Database In-Reply-To: <8f193b45-ea99-4072-a646-51b32651cd9c@googlegroups.com> References: <527a5f79$1@news.synserver.de> <1ac21a4c-179e-40aa-a552-85b5e2a74b3d@googlegroups.com> <8f193b45-ea99-4072-a646-51b32651cd9c@googlegroups.com> X-Mailer: Claws Mail 3.8.1 (GTK+ 2.24.10; x86_64-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - boston.accountservergroup.com X-AntiAbuse: Original Domain - python.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - tim.thechases.com X-Get-Message-Sender-Via: boston.accountservergroup.com: authenticated_id: tim@thechases.com Cc: python-list@python.org X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 32 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1384255722 news.xs4all.nl 15919 [2001:888:2000:d::a6]:51692 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:59185 On 2013-11-11 22:24, rurpy@yahoo.com wrote: > And your suggestion is not necessarily best either: why a 1:M > relationship? why not a M:M relationship? There may be duplicate > file downloads resulting in your suggestion being non-normalized. You think that, after rejecting the addition of *one* new table for 1:M relationships, he'd go for adding *two* new tables for an N:M relationship? > But I think he is being perfectly reasonable in rejecting a > separate table if he feels it does not meet *his* needs (even if he > is wrong in your opinion.) However, the needs that he *describes* call for at least one more table, on pain of future problems, inter alia: - non-atomic updates - growth to an unknown number of files, exceeding the size of his one CHAR/VARCHAR field - difficulty querying which files were used (including the inability to easily summarize/group by file) - inability to maintain metadata for each file (a case for your N:M suggestion) Knowing these things and Nikos' historical inability to debug issues, it' worthwhile to get him to use a method that will result in less pain. Especially when you know from his description that his choices *WILL* cause him future pain. -tkc