PostgreSQL (Postgres) Community

Postgres - Blog

Bruce Momjian
Follow /11 Jan 2018 at 9:40pm / Postgres - Blog

PL/Java Adoption

PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java language and hamper its adoption. First, there are a limited number of people who know both Java and the...
49 0 /
Bruce Momjian
Follow /11 Jan 2018 at 9:36pm / Postgres - Blog

Outer Joins and Where Clauses

Postgres supports both traditional join syntax , which uses the where clause to specify joined columns, and ansi join syntax, that uses the word join in the from clause. While both syntaxes can be used for inner joins, only the ansi join syntax supports...
68 0 /
Bruce Momjian
Follow /11 Jan 2018 at 9:33pm / Postgres - Blog

When to Use Server-Side Logic

The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The question has always been what amount of logic should be encoded in the database vs. in client applications...
68 0 /
Porus Homi Havewala
Follow /11 Jan 2018 at 7:21pm / Postgres - Blog

PostgreSQL database for Enterprises – Part IV

In this article series, we are exploring why and how enterprises are starting to use the PostgreSQL database. In particular we are looking at an enterprise-ready version of PostgreSQL, namely EnterpriseDB Postgres Advanced Server (EDBPAS). This customized...
164 0 /
Porus Homi Havewala
Follow /14 Dec 2017 at 6:01pm / Postgres - Blog

PostgreSQL database for Enterprises – Part III

In this article series, we are exploring why and how enterprises are starting to use PostgreSQL. In particular we are looking at an enterprise-ready version of the PostgreSQL database, such as EnterpriseDB Postgres Advanced Server (EDBPAS), which is even...
266 0 /