Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.ag!news2.euro.net!xlned.com!feeder1.xlned.com!newsfeed.xs4all.nl!newsfeed6.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; 'python.': 0.02; 'languages,': 0.04; 'subject:Python': 0.05; 'binary': 0.05; 'badly': 0.07; 'postgresql': 0.07; 'python': 0.09; 'to:addr:comp.lang.python': 0.09; 'cc:addr:python-list': 0.10; '(the': 0.15; 'enough.': 0.16; 'happily': 0.16; 'released.': 0.16; 'row': 0.16; 'module': 0.19; 'trying': 0.21; 'cc:2**0': 0.23; 'cc:no real name:2**0': 0.24; 'cc:addr:python.org': 0.25; 'header :In-Reply-To:1': 0.25; 'header:User-Agent:1': 0.26; 'select': 0.26; 'ago': 0.27; 'received:209.85.212': 0.28; 'chris': 0.28; 'cases.': 0.29; 'locking': 0.29; 'locks': 0.29; 'probably': 0.29; 'maybe': 0.29; 'anyone': 0.33; 'version': 0.34; 'received:google.com': 0.34; 'needed': 0.35; 'pm,': 0.35; 'table': 0.35; 'received:209.85': 0.35; 'really': 0.36; 'but': 0.36; 'too': 0.36; 'uses': 0.37; 'being': 0.37; 'quite': 0.37; 'received:209': 0.37; 'subject:: ': 0.38; 'things': 0.38; 'performance': 0.39; 'short': 0.39; 'think': 0.40; 'your': 0.60; 'easy': 0.60; 'from:no real name:2**0': 0.60; "you'll": 0.62; 'back': 0.62; 'engines': 0.62; 'between': 0.63; 'different': 0.63; 'ever': 0.63; 'decided': 0.65; 'gave': 0.65; 'choose': 0.65; 'finally': 0.66; 'topic,': 0.78; 'kicking': 0.84; 'unaware': 0.84; 'windows)': 0.84; 'received:209.85.212.56': 0.91; 'suffer': 0.91 Newsgroups: comp.lang.python Date: Fri, 28 Sep 2012 08:52:45 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=65.183.81.59; posting-account=h7ZmAgoAAAChnNHfIDF1M6YGHuonryl5 References: <5061cf25$0$29981$c3e8da3$5496439d@news.astraweb.com> <5063a179$0$29981$c3e8da3$5496439d@news.astraweb.com> <5063eba2$0$29997$c3e8da3$5496439d@news.astraweb.com> <506515F8.9020606@tysdomain.com> User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-IP: 65.183.81.59 MIME-Version: 1.0 Subject: Re: Article on the future of Python From: rurpy@yahoo.com To: comp.lang.python@googlegroups.com Content-Type: text/plain; charset=ISO-8859-1 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: , Message-ID: Lines: 23 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1348847568 news.xs4all.nl 6876 [2001:888:2000:d::a6]:56108 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:30408 On 09/27/2012 10:37 PM, Chris Angelico wrote:>[...] > * MySQL is designed for dynamic web sites, with lots of reading and > not too much writing. Its row and table locking system is pretty > rudimentary, and it's quite easy for performance to suffer really > badly if you don't think about it. But if your needs are simple, MySQL > is probably enough. PostgreSQL uses MVCC to avoid locks in many cases. > You can happily read from a row while it's being updated; you'll be > unaware of the update until it's committed. MVCC comes with a cost though, as anyone who has ever needed to do a SELECT COUNT(*) on a large Postgresql table knows. >[...] > * Both engines have good support in popular languages, including > (dragging this back on topic, kicking and screaming) Python. Maybe things are different now but a few years ago I was trying to choose between Postgresql and Mysql about the time Python 2.4 (I think) was released. After waiting for over a year for the Python mysql dbi module to be released for the then current version of Python (I needed a binary for Windows) I finally gave up and decided to go with Postgresql (the psycopg2 module was available a very short time after the new Python was.)