Month: September 2014

Transforming API Data Objects in AngularJS

The Problem AngularJS is awesome, but one thing sorely lacking from it is the ability to use information from HTTP endpoints as Business Logic objects. For example, if you get a list of files from an API endpoint, all you get are the attributes from that endpoint, no methods. [{“filename”: “avi_1003.mov”, “filesize”: 1033293}, {“filename”: “avi_1123.mov”, […]

A Neat Little SQL Trick

What’s Going On? Have you ever needed to select a subset of a table, based on non-contiguous identifiers? I used to either use a join for that or write an external script to SELECT * FROM whatever WHERE key=’val’, then loop through the results using them as needed. Recently, I ran across this neat little SQL operator, […]