mysql on rails 2.3.2
mysql driver is no longer bundled w/ rails. you'll need to install it yourself w/
sudo gem install mysql
however, on ubuntu (heron) this won't work. issue these commands first
sudo apt-get install libmysql-ruby libmysqlclient-dev
if libmysqlclient-dev...
Written by Sean Behan on 06/17/2012
How to Enable UUIDs in Postgres
The first thing you'll need to do is enable the extension
create extension "uuid-ossp";
To test that it's working
select uuid_generate_v1();
For more info on which version of the algorithm you should use refer to the documentation.
...
Written by Sean Behan on 03/03/2017
Extract Domain Names From Links in Text with Postgres and a Single SQL Query
This query and pattern will return urls in text all within a single SQL query.
select substring(column_name from '.*://([^/]*)') as domain_name from table_name;
And here it is in a larger query, say for retrieving page view counts for referrers.
...
Written by Sean Behan on 11/23/2013
How to Render Partials with an Underscore in Sinatra
Sinatra doesn't have a method for rendering partials. It defers to the template language of your choice. For instance, if you're using ERB, it's as simple as
erb :'path/to/partial'
Rails has a nice convention of using an underscore to mark file...
Written by Sean Behan on 10/13/2013
Git Feature Branch Naming Strategy
There are only two hard things in Computer Science: cache invalidation and naming things.
-- Phil Karlton
Typically, we have three main branches at any given time in a project lifecycle.
master, development and staging.
Master is production ready code, d...
Written by Sean Behan on 06/17/2012