Category: postgres

Tree structure query with PostgreSQL

When dealing with hierarchical data, we usually use recursion for constructing the tree structure. It would be a performance problem if you query the tree node data from the databa...

Embracing SQL In Postgres

Having the ability to work SQL in your favorite database engine is a life-long, good skill to have. In this post I'll show you some of the favorite things I use in Postgres.