PostgreSQL Blog

Backward compatibility of database versions is critical, as it directly impacts the availability, continuity, and overall efficiency of business systems, and is necessary for the success of a database product. When you get used to using some successful database products, you may not feel that they exist, because it has become like air and water, making you feel that database products are supposed to be the way they are. However, if you choose to use a bad database product, you will feel like you’re always running into problems because of the lack of backward compatibility of the versions.

Development culture in PostgreSQL community

By John Doe in Business

November 14, 2023

The PostgreSQL community is characterized by a unique development culture that emphasizes collaboration, transparency, and community-driven contributions. Here are some key aspects of the development culture in the PostgreSQL community:

PostgreSQL view dependencies

By Laurenz Albe in Usage

July 5, 2023

We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it:

PostgreSQL function dependencies

By John Doe in Usage

July 4, 2023

When using PostgreSQL functions, you need to be careful not to end up with dangling functions, since the dependency between functions is not well maintained in the PostgreSQL system catalog. The following example shows how you can end up with a dangling function:

Managing Complex Data with JSON

By Rob Giseburt in Usage

May 24, 2023

Are you looking at your stale, flat relational database and thinking: “It’s so rigid and lifeless!” Do you need polymorphism? Do you have a NoSQL database that has no obvious shape and is causing you lack-of-relationship nightmares? With JSON in PostgreSQL, you can have your cake and relationships too!

Difference Between GROUP BY and PARTITION BY

By John Doe in Usage

April 8, 2023

The GROUP BY and PARTITION BY clauses are both used in SQL to group data and calculate aggregate values, then what’s the difference between them?

Access PostgreSQL with ChatGPT

By John Doe in Product

March 28, 2023

GPT can write SQL. If we write our question in plain English, and have GPT write the SQL to get the answer, well then we can save a lot of time spent on enterprise process management and data analysis software.

Database Compatibility and Selection Suggestions

By John Doe in Product

March 26, 2023

Database compatibility is critical to the success of a database product, and it can even make the difference between life and death for a database product. The problem of database compatibility is essentially a problem that software products will have.

PostgreSQL optimizer is good enough

By John Doe in Product

March 24, 2023

The optimizer is the heart and soul of a relational DBMS. It analyzes SQL statements and determines the most efficient access plan for satisfying each statement. For database optimizers, there have always been many voices among database-related practitioners.

Analyze Nginx access logs with PostgreSQL

By John Doe in Usage

March 14, 2023

PostgreSQL supports the data types json and jsonb, while nginx supports log output in JSON format. We can easily implement the analysis of nginx access logs using PostgreSQL.

PostgreSQL Backward Compatibility

Development culture in PostgreSQL community

PostgreSQL view dependencies

PostgreSQL function dependencies

Managing Complex Data with JSON

Difference Between GROUP BY and PARTITION BY

Access PostgreSQL with ChatGPT

Database Compatibility and Selection Suggestions

PostgreSQL optimizer is good enough

Analyze Nginx access logs with PostgreSQL

Search

Categories

Tags