Path: csiph.com!usenet.pasdenom.info!gegeweb.org!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <joel.goldstick@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.006
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; '(except': 0.07; 'intermediate': 0.07; 'table.': 0.07; 'forms,': 0.09; 'properly.': 0.09; 'sql,': 0.09; 'statements': 0.09; 'subject:into': 0.09; 'subject:string': 0.09; 'subject:How': 0.10; 'cc:addr:python- list': 0.11; 'python': 0.11; 'stored': 0.12; 'thread': 0.14; 'personally,': 0.16; 'stuff,': 0.16; 'subject:already': 0.16; 'thread,': 0.16; 'code.': 0.18; 'pointed': 0.19; 'cc:addr:python.org': 0.22; 'this?': 0.23; 'stopping': 0.24; 'people,': 0.24; 'question': 0.24; 'cc:2**0': 0.24; 'second': 0.26; 'values': 0.27; 'header:In-Reply-To:1': 0.27; 'quickly': 0.29; 'related': 0.29; 'subject:list': 0.30; 'message- id:@mail.gmail.com': 0.30; 'extending': 0.31; 'ok.': 0.31; 'this.': 0.32; 'stuff': 0.32; 'another': 0.32; 'table': 0.34; 'no,': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'there': 0.35; 'in.': 0.36; 'doing': 0.36; 'possible': 0.36; 'so,': 0.37; 'step': 0.37; 'being': 0.38; 'handle': 0.38; 'bad': 0.39; 'how': 0.40; 'even': 0.60; 'read': 0.60; 'break': 0.61; 'field.': 0.61; 'first': 0.61; 'complete': 0.62; 'more': 0.64; 'taking': 0.65; 'here': 0.66; 'skill': 0.68; 'lack': 0.78; 'column.': 0.84; 'good,': 0.91; 'joel': 0.91; 'subject:add': 0.91
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=dziw/+AggFcKPckrpPkEGeafvdyq5vCfM6jrCos7DNY=; b=VkfHmskR6ISByBCheIR0QCKAMi8bArOCOsDEdJCvtZ0aLMAOqTaYm6jaNyTUMjjhWr EdaTPyBG0d+u6LZ9rDkPoH+dIg/fjFq8vWgHTaxEdHyapb2bB7sKvYBX+QSKD2fiMX8u KMW7jT0lsrKZwhi2BcILg8JViwD2FEVyys8emGSxyvDNjr8CT7J6qcz9A9VhM6omDZhn HPnZW3wuql994r+cO9OdOFsaFd10QWFH0ZV/Zouc5BIqWrhByyfiC8TVOMknku8wkVx8 aVeocn+rGWF/pgUEon/1tfMLQbHYD4xtq1d//cVYKuVH9UgJO9n24XgnV5AI3sxflou7 3XjA==
MIME-Version: 1.0
X-Received: by 10.220.145.75 with SMTP id c11mr480431vcv.30.1383666264304; Tue, 05 Nov 2013 07:44:24 -0800 (PST)
In-Reply-To: <almarsoft.123071594883833362@news.gmane.org>
References: <l52pdo$k0f$1@dont-email.me> <mailman.1951.1383398828.18130.python-list@python.org> <l5391q$9in$1@dont-email.me> <bdm7fiF28rrU1@mid.individual.net> <roy-D613E2.07164103112013@news.panix.com> <l58k1t$24a$1@dont-email.me> <l59842$roj$1@dont-email.me> <l5a4no$21s$1@dont-email.me> <l5a8vu$iaa$1@dont-email.me> <mailman.2041.1383639718.18130.python-list@python.org> <l5abnk$v9u$1@dont-email.me> <l5acl9$qgm$1@speranza.aioe.org> <l5ae3r$aie$1@dont-email.me> <l5afbl$ft4$1@dont-email.me> <mailman.2047.1383646833.18130.python-list@python.org> <l5ahib$rel$1@dont-email.me> <5278db56$0$29972$c3e8da3$5496439d@news.astraweb.com> <l5ao43$tg6$1@dont-email.me> <almarsoft.123071594883833362@news.gmane.org>
Date: Tue, 5 Nov 2013 10:44:24 -0500
Subject: Re: How to add a current string into an already existing list
From: Joel Goldstick <joel.goldstick@gmail.com>
To: Dave Angel <davea@davea.name>
Content-Type: text/plain; charset=UTF-8
Cc: "python-list@python.org" <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 <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.2057.1383666267.18130.python-list@python.org>
Lines: 41
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1383666267 news.xs4all.nl 15924 [2001:888:2000:d::a6]:53504
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:58508

As I  read this thread, the original question was how to stuff
multiple values in a single sql column.  Several people pointed out
that the proper way to handle multiple values related to the original
table is to use a second table or perhaps a many to many relationship
with and intermediate join table.  Some people, including the original
poster seem to want to shoe horn the data into a single field. --
blobs, strings, even python lists, etc.  Although there is nothing
stopping a coder from doing that (except lack of skill ;)), it is a
bad idea.  SQL, whether a complete implementation of Codd stuff, or a
reasonable facsimile is a system that makes it possible to make
complex queries on data stored properly.  If you break the normal
forms, you always end up not being able to use sql statements to get
everything out that you put in.

So, some people here seem to think that's ok.  It may get the poster
past his first step more quickly than taking the time to understand
the tools he is using.  But eventually, there will be a big cost to
extending the code.  And we will endure another thread like this.
Personally, I think it demeans the group.

Once again we get the pattern:

How do I do this?

1. Here's how

No, I don't like that way

2. Here's a bad way

Oh good, will you write it for me.







-- 
Joel Goldstick
http://joelgoldstick.com