Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed5.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.003 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'subject:Python': 0.05; 'inspired': 0.05; 'plenty': 0.07; 'postgresql': 0.07; 'formatted': 0.09; 'instance.': 0.09; 'postgres': 0.09; 'sep': 0.09; "they've": 0.09; 'stored': 0.10; 'sat,': 0.15; '(now': 0.16; 'desktop.': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'name...': 0.16; 'tradition': 0.16; 'string': 0.17; 'wrote:': 0.17; 'widely': 0.17; 'pre': 0.22; 'sends': 0.22; 'posts': 0.23; 'references': 0.23; 'least': 0.25; 'header:In-Reply-To:1': 0.25; 'am,': 0.27; 'environment.': 0.27; 'installing': 0.27; 'message- id:@mail.gmail.com': 0.27; "doesn't": 0.28; 'chris': 0.28; 'run': 0.28; 'gis': 0.29; 'statements': 0.29; "i'm": 0.29; 'fri,': 0.30; 'query': 0.30; '(and': 0.32; 'running': 0.32; 'to:addr:python- list': 0.33; 'received:google.com': 0.34; 'continue': 0.35; 'received:209.85': 0.35; 'there': 0.35; 'serve': 0.36; 'but': 0.36; 'url:org': 0.36; 'received:209': 0.37; 'data': 0.37; 'subject:: ': 0.38; 'easier': 0.38; 'supports': 0.38; 'url:docs': 0.38; 'sure': 0.38; 'url:en': 0.38; 'to:addr:python.org': 0.39; 'build': 0.39; 'header:Received:5': 0.40; 'your': 0.60; 'days': 0.60; 'skip:u 10': 0.60; 'further': 0.61; "you'll": 0.62; 'back': 0.62; 'improved': 0.62; 'please,': 0.62; 'details,': 0.65; 'capital': 0.68; 'click': 0.76; 'dennis': 0.91; 'transactions': 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 :content-type; bh=PusBqi5OKjb7tuPjouAITxJVJsfan0igvDhAG/qNS04=; b=hUnerQX3ZvBwDe2bHzhEZeU1+bik0cNye/8FGmcb5YSXMKrcp7wgCZc6YpSJ27IK6+ ldvaMDtI+CGU8ArAfGxSzGxVjAUzW2mA/l5EgaWmjOnoahLPybqkm00WuUxb4c2Iekgl 73SPqQdJGABdWS6s22Y76h/frR62q8GaWj/TsrN24bjzx/X25KYm+e6zFIKzuIrIMYTB Yme/lN8NTc/ll+oslQ1Vk5gPYkC0CwicJu6yi9W0wYitH/4DP10l0OYDcOA5cNQbPRSc EJAn3VqPDCejFjGpOx4Lr0QfQ1Q9OWfwk4sYga4rDiClZx+jEelMTvccPTNt91L7YQQ3 Vrdg== MIME-Version: 1.0 In-Reply-To: References: <506515F8.9020606@tysdomain.com> Date: Sat, 29 Sep 2012 00:58:51 +1000 Subject: Re: Article on the future of Python From: Chris Angelico To: python-list@python.org Content-Type: text/plain; charset=ISO-8859-1 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: 41 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1348844334 news.xs4all.nl 6893 [2001:888:2000:d::a6]:49807 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:30396 On Sat, Sep 29, 2012 at 12:31 AM, Dennis Lee Bieber wrote: > On Fri, 28 Sep 2012 14:37:21 +1000, Chris Angelico > declaimed the following in gmane.comp.python.general: > > >> For further details, poke around on the web; I'm sure you'll find >> plenty of good blog posts etc. But as for me and my house, we will >> have Postgres serve us. >> > > Please, at least use the proper name... "Postgres" is a non-SQL > database inspired by Ingres. "PostgreSQL" is Postgres with an SQL query > engine. http://www.postgresql.org/docs/9.1/static/history.html "Many people continue to refer to PostgreSQL as "Postgres" (now rarely in all capital letters) because of tradition or because it is easier to pronounce. This usage is widely accepted as a nickname or alias." There's lots of internal documentation that references "Postgres". I don't see it as that big a deal. > On my side... I have MySQL running on my desktop. When I started, > MySQL had a native build that would run on Win9X; PostgreSQL at the time > required installing a Cygwin environment. > > MySQL v5 has improved a lot from those days (v3)... It now supports > stored procedures, triggers, a form of views, and prepared statements > (though MySQLdb is still pre v5 and sends completely formatted string > queries). They've even added GIS capabilities. (And then there is the > "drop-in" replacement for MySQL -- MariaDB: > http://kb.askmonty.org/en/mariadb-vs-mysql-compatibility/ ) Yes, MySQL has definitely improved. There was a time when its unreliability applied to all your data too, but now you can just click in InnoDB and have mostly-real transaction support etc. But there's still a lot of work that by requirement happens outside of transactions - MySQL doesn't let you roll back DDL, for instance. ChrisA