Articles tagged Database

Wrangle nested composite type arrays into something more elegant to work with, unnest to the rescue.

SQL Servers are awesome and allow us to build great things, but sometimes writing SQL just to get the boiler plate logic out can get in the way...

In this example we will show how to create and use custom types for columns within postgresql tables and be able to create an array of custom...

Add redundancy to your data and at the same time enable higher performance of read-only queries by leveraging the incredible power and...