Skip to content

Instantly share code, notes, and snippets.

@bdon
bdon / gist:2886527
Created June 7, 2012 04:21
simple fulltext search with postgres + sequel
if params[:query].present?
# not doing :* prefix matching right now.
# Preprocess the string into what TSvector wants. spaces -> ?
# Then only letters, numbers, underscores and qmarks are left.
query = params[:query].gsub(/\s+/, '?').gsub(/[^\w\?]/, '')
@results = @results.select { [ts_headline('english', :text, to_tsquery('english', query), 'MaxFragments=2').as(headline), id, title, happened_at]}
@results = @results.filter("ts_text @@ to_tsquery('english', ?::text)", query)
end
@bdon
bdon / gitaliases
Created April 5, 2012 05:12
Git aliases I use often
[alias]
st = status
co = checkout
lg = log --graph --oneline --all --decorate
gap = add --patch --interactive