Neues vom PostgreSQL Planet

I’ve used PostgreSQL for almost 20 years. During this time, I’ve struggled with its official clients. Normally, I have a good memory (except for people’s names and faces). So having to refer to the tool documentation each time I wanted to use it was very unusual for me. So I asked myself, why is that so? I noticed that there was inconsistency and even incompatibility among flags. Sometimes you need the -d flag for the database name.

Table of Contents

• PostgreSQL Extensions
• Available In Clouds
• Manged by Me, or Contributed to by Me
• The Ones You Always Will Need

Postgres is amazing for many reasons. One area that doesn't get near enough attention is datatypes. Postgres has a rich set of datatypes and one important one for devs to be especially excited about is JSONB.

JSONB which is structured and indexable. In JSON, the B stands for binary (or as we like to think of it B is for better), which means data is pre-parsed as it is stored. How do you get the most out of JSONB from a retrieval perspective? Enter Postgres' rich indexing support.

PostgreSQL Person of the Week Interview with Curt Kolovson: I grew up in the Boston area. I currently live in the San Francisco Bay Area and have resided here for over 40 years.