Use Postgres JSON Type and Aggregate Functions to Map Relational Data to JSON
Postgres is just too cool. Because Postgres can work with both JSON and arrays as first-class data types, it is possible to perform some very handy mappings on the server end which would become potential performance bottlenecks...
Installing and Configuring PostgreSQL 9.4 on Linux Mint/Ubuntu
Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided...
A More Useful Port of the Chinook Database to Postgresql
Image by Ingrid Talar | Some Rights Reserved I use Chinook Database as the sample database for a lot of things, primarily because the same data set is available for most of the major database platforms, so it’s easy to...
No More Results