Barry Frost

This is Barry Frost’s personal website.

Tagged #query

knex

A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder for Node.js and the Browser

jsondns

JSONP RESTful interface for DNS lookups

Documents about MySQL query optimization

CouchDB "Joins"

This seems like a lot of faffing to my relational brain, but handy to know how to achieve it

Rail Spikes: (One reason why) MySQL sucks

Remember not to use :text for selectable columns in migrations in MySQL < 5.0.3