How to Tag and Push a Release with Git
Set the `-a` and the `-m` flags like so
git tag -a v1.0.0 -m "Note about the release goes here"
Then to push the tag to a repository
git push origin --tags
And that's it!
Here are the docs [https://git-scm.com/book/en/v2/Git-Basics-Tag...
Written by Sean Behan on 11/29/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 import CSV into SQLite3
To import a CSV file into SQLite is easy.
sqlite3 my.db
.mode csv
.import path/to/file.csv name_of_table
And done.
Written by Sean Behan on 12/03/2017
Override to_param method in model to get pseudo permalinks without any work
There are a number of permalink plugins for Rails, http://www.seoonrails.com/even-better-looking-urls-with-permalink_fu, is a good one that I've used before. However, this involves informing the model class (has_permalink :title), adding a route, using t...
Written by Sean Behan on 06/17/2012
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