Обсуждение: What does Natvie Posgres mean?
When someone, e.g., as appeared in a recent and some older pgsql-jobs messages, says "Native Postgres", what do you supposethat 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 nativeD implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is beingtalked about. -- B
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 supposethat 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 nativeD implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is beingtalked about. > > -- B > > > > > -- Adrian Klaver adrian.klaver@aklaver.com
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.
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 supposethat 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 nativeD implementation of the Postgres frontend/backend protocol.", but I don't get the sense that this is what is beingtalked 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. *****
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:
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.
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 ScherreyOn Wed, Jun 13, 2018, 12:59 AM David G. Johnston <david.g.johnston@gmail.com> wrote: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.
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.