Re: Python versus Other Languages using PostgreSQL

From: Neil Anderson <neil(at)postgrescompare(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Paul Hughes <paul(at)vivation(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Python versus Other Languages using PostgreSQL
Date: 2017-05-09 04:00:13
Message-ID: CAEKCySuH60k=Vx4PtE15eZrA_RS7hF8mSxV-byq+n5PtRMfu_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm also interested to know which frameworks you're referring to?

Regarding Node and Mongo I imagine that they are well suited because
Mongo stores JSON documents and Node, being Javascript, has first
class support for JSON. Python and PostgreSQL's relationship might be
more of a principled one? Pythonic being a characteristic not
dissimilar to stable, reliable and of high quality.

On 8 May 2017 at 21:22, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> On 05/08/2017 05:45 PM, Paul Hughes wrote:
>>
>> Thank you for the links. I'm glad there are other languages that are
>> working with PostgreSQL. My question still remains though - why is it that
>> all the largest web platforms that have used PostgreSQL *specifically*
>> choose Python as their back-end language? Why are Postgres and Python so
>> married, in the same way that Node.js is largely married to MondogDB?
>
>
> I think you are going to have name frameworks, because AFAIK Drupal uses
> PHP, Ruby on Rails uses Rails and so on:
>
> https://en.wikipedia.org/wiki/Comparison_of_web_frameworks
>
> As to why Postgres and Python seem to be attached I would say that is
> because about the time people started looking for an alternative to
> MySQL/PHP, Python reached the state and breadth of distribution to became
> the language to pair with Postgres.
>
>>
>>
>> On Mon, May 8, 2017 at 3:50 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>
>> On 05/08/2017 02:26 PM, Paul Hughes wrote:
>>
>> Hello,
>>
>> I noticed that most of the largest web platforms that use
>> PostgreSQL as
>> their primary database, also use Python as their primary back-end
>> language. Yet, according to every benchmark I could find over
>> the last
>> couple of years, back-end languages like PHP, HHVM, and Node.JS
>> outperform Python by 2x to 8x!
>>
>>
>> Postgres does not really care what you use to pull data from it.
>> There are many libraries across many languages that you can use.
>>
>>
>>
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>> Virus-free. www.avast.com
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
>>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
Neil Anderson
neil(at)postgrescompare(dot)com
https://www.postgrescompare.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Venkata B Nagothi 2017-05-09 05:17:07 Re: Migration Query
Previous Message Armand Pirvu (home) 2017-05-09 03:31:12 Re: data transformation and replication