John Atten | Programming, Tech, and Stuff I Like to Write About . . .

Image by César Astudillo  |  Some Rights Reserved
ASP.NET 5 introduces a new runtime model for the .NET framework which allows us to employ a “pay-as-you-go” approach, building composable applications using only those framework components our application needs, without relying upon a central, monolithic...

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 on the client side.
When working in Node.JS, it might be handy to do some heavy lifting via Postgres to reduce some n+1 / lazy loading issues, especially when pulling data for display. Using some of Postgres’ in-built JSON  functions in conjunction with the JSON data type...

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 firmly in the latter camp...

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 port/compare etc. Chinook Database offers up a set of tables with enough sample...