Usage

Difference Between GROUP BY and PARTITION BY

Summary: 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?

Continue reading

Analyze Nginx access logs with PostgreSQL

Summary: 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.

Continue reading