Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #56264

Re: Database statements via python but database left intact

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> (permalink)
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

Show key headers only | View raw

:

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

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 22:16 +0300
  Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 22:27 +0300
  Re: Database statements via python but database left intact Zero Piraeus <z@etiol.net> - 2013-10-05 16:29 -0300
    Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 22:36 +0300
      Re: Database statements via python but database left intact Ian Kelly <ian.g.kelly@gmail.com> - 2013-10-05 14:31 -0600
        Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 00:02 +0300
          Re: Database statements via python but database left intact Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 17:39 -0400
          Re: Database statements via python but database left intact Chris Angelico <rosuav@gmail.com> - 2013-10-06 09:51 +1100
          Database engine bindings for Python (was: Database statements via python but database left intact) Ben Finney <ben+python@benfinney.id.au> - 2013-10-06 12:05 +1100
          Re: Database engine bindings for Python (was: Database statements via python but database left intact) Chris Angelico <rosuav@gmail.com> - 2013-10-06 12:19 +1100
          Re: Database engine bindings for Python (was: Database statements via python but database left intact) Dan Sommers <dan@tombstonezero.net> - 2013-10-06 06:22 +0000
            Re: Database engine bindings for Python (was: Database statements via python but database left intact) Chris “Kwpolska” Warrick <kwpolska@gmail.com> - 2013-10-06 11:10 +0200
            Re: Database engine bindings for Python (was: Database statements via python but database left intact) Chris Angelico <rosuav@gmail.com> - 2013-10-07 00:37 +1100
              Re: Database engine bindings for Python (was: Database statements via python but database left intact) Roy Smith <roy@panix.com> - 2013-10-06 10:05 -0400
          Re: Database statements via python but database left intact Chris “Kwpolska” Warrick <kwpolska@gmail.com> - 2013-10-06 11:05 +0200
            Re: Database statements via python but database left intact rusi <rustompmody@gmail.com> - 2013-10-06 04:36 -0700
              Re: Database statements via python but database left intact Chris “Kwpolska” Warrick <kwpolska@gmail.com> - 2013-10-06 14:01 +0200
          Re: Database statements via python but database left intact Zero Piraeus <z@etiol.net> - 2013-10-05 18:45 -0300
            Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 18:57 +0300
              Re: Database statements via python but database left intact Piet van Oostrum <piet@vanoostrum.org> - 2013-10-06 17:40 -0400
          Re: Database statements via python but database left intact Adam Tauno Williams <awilliam@whitemice.org> - 2013-10-06 11:55 -0400
      Re: Database statements via python but database left intact Adam Tauno Williams <awilliam@whitemice.org> - 2013-10-06 11:52 -0400
        Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 19:49 +0300

csiph-web