More
Beyond jsonb: a generalized, unstructured data type for Postgres
Álvaro Hernández Aug 6, 2020 6 min read

jsonb supports, unsurprisingly, JSON jsonb is, undeniably, king. It is a very flexible data type, that allows for unstructured/schema-less storage. It has very powerful indexing mechanisms, and its internal representation is reasonably compact and efficient. It comes with advanced operators and expressions to query/extract parts of it, and has recently seen the addition of SQL/JSON path functionality to extend that to comply with the SQL Standard. There are countless posts and resources explaining the virtues of this data type and what you can accomplish with it.

Read post
Generated Columns vs. Triggers in PostgreSQL 12
Emanuel Calvo & Anthony Sotolongo Jul 7, 2020 5 min read

A comparative approach between Generated Columns and Triggers In this post, we are going to describe how Generated Columns work and how much it improves query execution times, compared to trigger-based solutions. For the test set, we analyzed the performance of INSERT and UPDATE operations using Generated Columns against C and PL/pgSQL based function triggers. This blog post includes a ready-to-go laboratory with the full battery of tests at this repository.

Read post