Re: Python versus Other Languages using PostgreSQL

Thank you all for taking the time to answer my questions. I've been out of
the programming world for a long time, so I am back to being a newbie. I
was told this is the place for newcomers to ask questions. I apologize if
my questions did not contain the necessary sophistication or nuance for
some to answer.

George, your answer makes the most sense. Thank you! You said:

>>Most cloud servers come preconfigured with some variation of either
the "LAMP" or "LAPP" stack: i.e. Linux, Apache, MySQL or Postgresql,
PHP or Python.

>>There needs to be a compelling *application* reason to install
something else: a JVM (or Apache-Tomcat vs regular Apache),
Ruby/Rails, Groovy/Grails, etc.

>

<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>

On Tue, May 9, 2017 at 7:54 AM, George Neuner <gneuner2(at)comcast(dot)net> wrote:

> On Mon, 8 May 2017 14:26:02 -0700, Paul Hughes <paul(at)vivation(dot)com>
> 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!
> >
> >So here are my questions:
> >
> >1) Why do the largest web applications that use PostgreSQL also use
> Python,
> >even though Python is significantly slower than it's biggest competitors?
>
> Most cloud servers come preconfigured with some variation of either
> the "LAMP" or "LAPP" stack: i.e. Linux, Apache, MySQL or Postgresql,
> PHP or Python.
>
> There needs to be a compelling *application* reason to install
> something else: a JVM (or Apache-Tomcat vs regular Apache),
> Ruby/Rails, Groovy/Grails, etc.
>
>
> >2) Can PostgreSQL just as easily be used with PHP or Node.js? If not, why
> >not?
>
> Absolutely. The DBMS is (programming) language neutral - the only
> requirement is that a client speak the wire protocol. That can be
> done natively, or via a library/driver.
>
>
> >3) Can PostgreSQL be made to work seamlessly to take advantage of the
> >superior performance of HHVM or Node.js?
>
> Not really sure what you're asking. The application running under
> HHVM or node.js is completely separate from Postgresql.
>
> Both PHP and Javascript (generically and for node.js specifically)
> have libraries for Postgresql.
>
>
> George
>
>
>
> --
> 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
>

--
Paul Hughes
Executive Director
Vivation International
1-800-514-8483
Skype: Vivation2
paul(at)vivation(dot)com
http://www.vivation.com/