Index Your Foreign Keys

Index Your Foreign Keys

We add indexes to our database in order to speed up read operations. Basically, an index is a sorted copy of a particular set of columns the database uses to quickly look up the attributes of another table, most commonly, foreign keys of relations. There are several...
ActiveRecord Associations and You

ActiveRecord Associations and You

I love abstraction. It’s great to compartmentalize complexity and keep your application modular. SQL is not that. Relying on SQL strings in your code ties your implementation directly to the type, structure, and even the version of your database. ActiveRecord...
iBeacon’s Required Advertising Interval May Not Matter

iBeacon’s Required Advertising Interval May Not Matter

Apple’s Proximity Beacon Specification documents what it means for a Bluetooth Low Energy device to be an iBeacon. Within the specification there are several requirements identified. One of those is a fixed advertising interval. There have been many complaints...