CodeProject
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...
CodeProject
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...
CodeProject
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