What does Natvie Posgres mean?

Started by Berend Toberalmost 8 years ago6 messagesgeneral
Jump to latest
#1Berend Tober
btober@broadstripe.net

When someone, e.g., as appeared in a recent and some older pgsql-jobs messages, says "Native Postgres", what do you suppose that means?

Does it mean something different than just "PostgreSQL"?

Is the word "Native" just noise, or does it actually refer to something specific?

A quick google search reveals that there apparently is a thing called "postgres-native" which is described as "...a native D implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is being talked about.

-- B

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Berend Tober (#1)
Re: What does Natvie Posgres mean?

On 06/12/2018 10:53 AM, btober@computer.org wrote:

When someone, e.g., as appeared in a recent and some older pgsql-jobs messages, says "Native Postgres", what do you suppose that means?

I'm going to say it means the community supported versions, not
offshoots or forks e.g. AWS RDS Postgres, EDB non-community versions, etc.

Does it mean something different than just "PostgreSQL"?

Is the word "Native" just noise, or does it actually refer to something specific?

A quick google search reveals that there apparently is a thing called "postgres-native" which is described as "...a native D implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is being talked about.

-- B

--
Adrian Klaver
adrian.klaver@aklaver.com

#3David G. Johnston
david.g.johnston@gmail.com
In reply to: Berend Tober (#1)
Re: What does Natvie Posgres mean?

On Tuesday, June 12, 2018, btober@computer.org <btober@broadstripe.net>
wrote:

When someone, e.g., as appeared in a recent and some older pgsql-jobs
messages, says "Native Postgres", what do you suppose that means?

Does it mean something different than just "PostgreSQL"?

Likely it means the open source product built directly from the source code
published here (or packages derived there-from). As opposed to say AWS RDS
or EnterpriseDB or various other forks of the product available in the wild.

David J.

#4Joshua D. Drake
jd@commandprompt.com
In reply to: Berend Tober (#1)
Re: What does Natvie Posgres mean?

On 06/12/2018 10:53 AM, btober@computer.org wrote:

When someone, e.g., as appeared in a recent and some older pgsql-jobs messages, says "Native Postgres", what do you suppose that means?

Does it mean something different than just "PostgreSQL"?

Is the word "Native" just noise, or does it actually refer to something specific?

A quick google search reveals that there apparently is a thing called "postgres-native" which is described as "...a native D implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is being talked about.

Native Postgres/PostgreSQL would imply PostgreSQL installed on a VM or
bare metal instead of something like Google Postgres or Amazon RDS.

JD

--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is. ***
PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
***** Unless otherwise stated, opinions are my own. *****

#5Benjamin Scherrey
scherrey@proteus-tech.com
In reply to: David G. Johnston (#3)
Re: What does Natvie Posgres mean?

In my experience it refers to development directly via SQL against the
Postgres server rather than via an ORM like Django or the like. A
remarkably high percentage of applications backed by Postgres have been
written by developers that have never actually seen or written SQL code
directly. It's all generated (often quite naively) by the object relational
mapper. Requesting "native" developers means that they want you to
understand how the DB actually behaves and to be able to generate optimal
SQL code and proper DDLs that fit the application domain correctly.

- - Ben Scherrey

On Wed, Jun 13, 2018, 12:59 AM David G. Johnston <david.g.johnston@gmail.com>
wrote:

Show quoted text

On Tuesday, June 12, 2018, btober@computer.org <btober@broadstripe.net>
wrote:

When someone, e.g., as appeared in a recent and some older pgsql-jobs
messages, says "Native Postgres", what do you suppose that means?

Does it mean something different than just "PostgreSQL"?

Likely it means the open source product built directly from the source
code published here (or packages derived there-from). As opposed to say
AWS RDS or EnterpriseDB or various other forks of the product available in
the wild.

David J.

#6Ron
ronljohnsonjr@gmail.com
In reply to: Benjamin Scherrey (#5)
Re: What does Natvie Posgres mean?

This, to me, is the true meaning of "native PostgreSQL" (as opposed to
"stock PostgreSQL", which is uncustomized code).  However, if the job wanted
post was written by an HR flunky, it could mean anything.

On 06/12/2018 01:11 PM, Benjamin Scherrey wrote:

In my experience it refers to *development directly via SQL against the
Postgres server* rather than via an ORM like Django or the like. A
remarkably high percentage of applications backed by Postgres have been
written by developers that have never actually seen or written SQL code
directly. It's all generated (often quite naively) by the object
relational mapper. Requesting "native" developers means that they want you
to understand how the DB actually behaves and to be able to generate
optimal SQL code and proper DDLs that fit the application domain correctly.

  - - Ben Scherrey

On Wed, Jun 13, 2018, 12:59 AM David G. Johnston
<david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:

On Tuesday, June 12, 2018, btober@computer.org
<mailto:btober@computer.org> <btober@broadstripe.net
<mailto:btober@broadstripe.net>> wrote:

When someone, e.g., as appeared in a recent and some older
pgsql-jobs messages, says "Native Postgres", what do you suppose
that means?

Does it mean something different than just "PostgreSQL"?

Likely it means the open source product built directly from the source
code published here (or packages derived there-from).  As opposed to
say AWS RDS or EnterpriseDB or various other forks of the product
available in the wild.

David J.

--
Angular momentum makes the world go 'round.