Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <z@etiol.net>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.169
X-Spam-Level: *
X-Spam-Evidence: '*H*': 0.75; '*S*': 0.09; '*not*': 0.07; 'python': 0.11; 'development?': 0.16; 'received:209.85.161.174': 0.16; 'task.': 0.16; 'subject:python': 0.16; 'wrote:': 0.18; 'discussion': 0.18; 'header:User-Agent:1': 0.23; 'issue,': 0.24; 'right.': 0.26; 'header:In-Reply-To:1': 0.27; "doesn't": 0.30; 'subject:Database': 0.31; 'could': 0.34; 'received:209.85': 0.35; 'received:google.com': 0.35; "didn't": 0.36; 'received:209': 0.37; 'to:addr:python-list': 0.38; 'does': 0.39; 'to:addr:python.org': 0.39; 'content-disposition:inline': 0.62; 'received:190': 0.69; '8bit%:100': 0.72; 'received:190.163': 0.84; 'subject:via': 0.84; 'mistake': 0.91; 'suited': 0.93; '2013': 0.98
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:date:from:to:subject:message-id:references :mime-version:content-type:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=Ce+frCfutjI5HpzIJj1MiixobGasbnqQsLMMQVLWAso=; b=JP8PZOkrCu6Ldrr9s5+u5l2SpkUML+OQvwf76as4wJkxAk9ZiDlLGWiMnkJy019nSt twbr+zAQzjYIUvyakg7TGKWYhKklLFPmYSt9y4RNyNN8NZuFTZfgo35KbvUYTaIlhfXH jSEA9s31A+xmpI6oHEL5I8X2gGG56yx/62hVrmGxC3RMZ6ZcW/2XrQy09wQmjUy329RJ EH1oeEHXSAVfjp1ReoOULtsDkj6UUHFrxxe1WpJ7Ncxf471kFFSTjU0CCKaePthDFZcr SvrHbuGukZgbn3Ozri99B9EwH/bnRazrC7QJFLCRX8EuucJQcqV08e0mtZc2VEKJ1Z+n kQIA==
X-Gm-Message-State: ALoCoQl1KpOs5s29Fkzrnzjg/06tePXWkoXwsrox5oqX2oIjJcn8zEsSxXqosP2ZfER8510Eq56/
X-Received: by 10.236.75.202 with SMTP id z50mr17123482yhd.6.1381009518178; Sat, 05 Oct 2013 14:45:18 -0700 (PDT)
Date: Sat, 5 Oct 2013 18:45:13 -0300
From: Zero Piraeus <z@etiol.net>
To: python-list@python.org
Subject: Re: Database statements via python but database left intact
References: <l2pois$359$1@dont-email.me> <mailman.757.1381001416.18130.python-list@python.org> <l2ppnh$9fc$1@dont-email.me> <mailman.758.1381005431.18130.python-list@python.org> <l2puok$5i8$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <l2puok$5i8$1@dont-email.me>
X-PGP-Key: http://etiol.net/pubkey.asc
User-Agent: Mutt/1.5.21 (2010-09-15)
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.785.1381074851.18130.python-list@python.org>
Lines: 21
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1381074851 news.xs4all.nl 15914 [2001:888:2000:d::a6]:53392
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:56264

:

On Sun, Oct 06, 2013 at 12:02:14AM +0300, Νίκος Αλεξόπουλος wrote:
> I neved had though of than an engine type could make so much mess.
> MyISAM is the way to go then for my web development?
> Why InnoDB failed to execute the queries?

Because you didn't commit. MyISAM doesn't support transactions, so when
you use it as the engine, your mistake happens to go unpunished.

Note that this is a weakness of MyISAM cancelling out a failure in your
code; it does *not* mean that MyISAM is better suited to your task.

By the way, Ned's right. At this point, this is no longer a Python
issue, and is off-topic for discussion here.

 -[]z.

-- 
Zero Piraeus: vive ut vivas
http://etiol.net/pubkey.asc