The Sweet Spot
On software, engineering leadership, and anything shiny.

Category: javascript

2016
April
Knex.js and PostGIS cheat sheet

As follows are some code snippets for using [Knex.js](http://knexjs.org/) for executing Postgres and PostGIS queries. ### Execute raw SQL in migration I often find this useful for fancy SQL, like …

2015
Building GPX stats through FRP principles with Bacon.js

With my current fascination with [tracking workouts and location-based-activities](http://github.com/andrewhao/stressfactor), I have been interested in how I might be able to rewrite some of my stats logic with FRP principles. ### …

2011
October
mmtss, a collaborative loop station

## mmtss is a loop station built for live performances. Let's make music together! This project simplifies a traditional loop tracking station and is designed for interactive collaborative music performances. …

July
Chat App - Frontend Prototype

[![Chat View - 1](http://farm6.static.flickr.com/5261/5885861130_71e25f2beb.jpg)](http://www.flickr.com/photos/andrewhao/5885861130/) [![Interview View](http://farm7.static.flickr.com/6053/5885860254_a2aa7f7895.jpg)](http://www.flickr.com/photos/andrewhao/5885860254/) Some UI work I did for a stealth startup in early '11. Responsible for look & feel and frontend chat interactions. jQuery/UI communicating to …

2010
December
Aristo, the shiniest jQuery UI theme of them all.

Let's face it: [jQuery UI skins](http://jqueryui.com/themeroller/) suck. They're flat, they're boring, they don't pop. Enter [Aristo](http://taitems.tumblr.com/post/482577430/introducing-aristo-a-jquery-ui-theme), a jQuery UI port of the [Cappuccino Javascript framework](http://cappuccino.org/) theme. [![](http://www.g9labs.com/wp-content/uploads/2010/12/Screen-shot-2010-12-01-at-4.47.58-PM.png)](http://www.g9labs.com/2010/12/01/aristo-the-shiniest-jquery-ui-theme-of-them-all/screen-shot-2010-12-01-at-4-47-58-pm/) Much better. Clone …

April
YUI 3 Widget lazy instantiation

At work, we make good use of [YUI 3](http://developer.yahoo.com/yui/). It's a really well-thought-out framework, from sandboxing and deep namespaces to CSS3 selector support and lazy-loading modules through the Yahoo! CDN. …

2008
October
First look at SproutCore and Cappuccino

One trend on the Web these days is to move away from traditional full-stack frameworks (like [Rails](http://rubyonrails.org)) toward client-side, full-stack Javascript frameworks (among them [Dojo](http://dojotoolkit.org/), [GWT](http://code.google.com/webtoolkit/), [SproutCore](http://sproutcore.com), and [Cappuccino](http://cappuccino.org)). There's …

GWT vs. SproutCore vs. Cappuccino

I'm looking to develop a Web application with a full-stack Javascript framework like [GWT](http://code.google.com/webtoolkit/), [SproutCore](http://www.sproutcore.com) or [Cappuccino](http://www.cappuccino.org). I'm making the decision to go with a Javascript framework over a traditional …