Category Database Development

PostgreSQL: Data from Multiple Queries in JSON

During a discussion the other day where we discussed SOA and a new service for a set of data that we currently have in PostgreSQL, a thought popped into my head – what if the database could do all of the selects and build the service JSON document in one request, rather than having a […]

Data Normalization and Reporting Tutorial

Data is what I do for a living, and in this article, I’m going to load some raw data into a database, normalize it for reporting and website use, and run some reports using, at first, grouping statements, and finally I’ll jump into analytic functions. I’m going to be working with PostgreSQL, for a couple […]