Skip to content

Instantly share code, notes, and snippets.

View derencius's full-sized avatar
🍀
Wish me luck, I'm fixing my bugs

Marcus Derencius derencius

🍀
Wish me luck, I'm fixing my bugs
94 followers · 144 following
View GitHub Profile
@derencius
derencius / style.css
Created May 17, 2013 18:47
garoa bold
@font-face {
font-family: "GaroaBold";
src: url(/assets/garoaminuscula.eot);
src: local("GaroaBold"),
url(/assets/garoaminuscula.eot?#iefix) format("embedded-opentype"),
url(/assets/garoaminuscula.woff) format("woff"),
url(/assets/garoaminuscula.ttf) format("truetype"),
url(/assets/garoaminuscula.svg#GaroaBold) format("svg");
font-weight: normal;
font-style: normal;
@derencius
derencius / gist:5557330
Created May 10, 2013 20:54 — forked from wrburgess/gist:3778949
@derencius
derencius / new_gist_file
Created March 28, 2013 03:56
postgres lc_collate
CREATE DATABASE "db" with ENCODING = 'unicode' lc_collate='pt_BR.UTF-8' lc_ctype='pt_BR.UTF-8' TEMPLATE=template0;
show lc_collate;
select * from (values('Éder', 'Eda', 'Edu')) x order by 1;
@derencius
derencius / image.rb
Created November 8, 2012 21:04
MiniMagick & ImageMagick - Level Colors and Composite
require 'rubygems'
require 'mini_magick'
color = '#103afc'
img = MiniMagick::Image.open("letter_x.png")
img.combine_options do |c|
c.add_command( 'level-colors')
c.+ "#{color},"
@derencius
derencius / distance.sql
Created April 20, 2012 22:04
latitude/longitude distance function - for mysql (original source: http://derickrethans.nl/spatial-indexes-mysql.html - syntax changed to fit in 1 line for easy use in a rails migration).
CREATE FUNCTION distance (latA double, lonA double, latB double, LonB double)
RETURNS double DETERMINISTIC
RETURN 2 * ASIN(SQRT((SIN((radians(latA) - radians(latB))/2) * SIN((radians(latA) - radians(latB))/2) +
COS(radians(latA)) * COS(radians(latB)) * SIN((radians(lonA) - radians(LonB))/2)*SIN((radians(lonA) - radians(LonB))/2)))) * 6371.01
@derencius
derencius / gist:1640992
Created January 19, 2012 16:26
def create
erros = []
variants = []
ProductionLabel.transaction do
begin
label = ProductionLabel.create!(params[:production_labels])
unless (label.valid?)
raise label.errors.full_messages
end
@derencius
derencius / dabblet.css
Created December 16, 2011 02:22
The first commented line is your dabkjkjblet’s title
/*ok
/**
* The first commented line is your dabkjkjblet’s title
*/
background: #f06;
background: linear-gradient(45deg, #f06, yellow);
min-height:100%;
@derencius
derencius / gist:1472733
Created December 13, 2011 16:16
[branch]
       autosetuprebase = always
@derencius
derencius / find_gap.sql
Created August 24, 2011 19:42
sql to find largest serial column leaps in a table.
-- 1) ran fine for 2 mi records table.
-- 2) assuming the table name is clients.
select did, cid, did - cid as gap
from
(
select
d.id as did,
(select min(id) as cid from clients c where c.id > d.id ) as cid
from
@derencius
derencius / gist:1101971
Created July 23, 2011 22:52
Using built-in specs.
Target: i686-apple-darwin10
Configured with: /var/tmp/gcc/gcc-5666.3~123/src/configure --disable-checking --enable-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^.-]*$/s/$/-4.2/ --with-slibdir=/usr/lib --build=i686-apple-darwin10 --program-prefix=i686-apple-darwin10- --host=x86_64-apple-darwin10 --target=i686-apple-darwin10 --with-gxx-include-dir=/include/c++/4.2.1
Thread model: posix
gcc version 4.2.1 (Apple Inc. build 5666) (dot 3)