April 20, 2015

Schemas in Postgres

Even after using Postgres for some time I was not aware of schemas and how it could be used to organize objects into logical groups. In this post we will see what is a schema and how we can use it to improve our database management.

April 14, 2015

Hierarchical Data Modeling

Recently I was faced with a problem where there was a need to model some hierarchical data and I chose to solve it with the Adjacency List pattern. In this post we will see some advantages of this approach and how it can be even better in databases that implement recursive queries.

April 12, 2015

Filter clause in Postgres

One of the great things of the Postgres team is that they are always trying to improve and simplify our work. This feature is one small example of their mentality towards improvement. Let's see how we can simplify some queries using this new clause.

April 7, 2015

Window Functions in Postgres

Window functions are supported since version 8.4, but this feature is still unknown to some people. In this post we will investigate and define what is a window function and how it can be used.

April 2, 2015

Inherited Tables in Postgres

Investigating inherited tables feature from PostgreSQL. Is inheritance useful in a relational database? If so, when should I use it? How they work and what should I keep an eye on during the implementation? Let's find out!