Skip to content

Instantly share code, notes, and snippets.

1 SIMPLE movies index PRIMARY,index_movies_on_id,index_movies_on_active index_movies_on_rating 5 NULL 8 Using where; Using temporary
1 SIMPLE torrents ref index_torrents_on_site_id,index_torrents_on_movie_id,index_torrents_on_tracker_id index_torrents_on_movie_id 5 site_development.movies.id 4 Using where
1 SIMPLE trackers eq_ref PRIMARY,index_trackers_on_id PRIMARY 4 site_development.torrents.tracker_id 1 Using index
1 SIMPLE images ref index_images_on_movie_id index_images_on_movie_id 5 site_development.torrents.movie_id 16
1 SIMPLE sizes eq_ref PRIMARY,index_sizes_on_id PRIMARY 4 site_development.images.size_id 1 Using where
@oleander
oleander / gist:978935
Created May 18, 2011 16:29
Open source dependencies for the Radiofy.se project

Open source dependencies for Radiofy written by us

  • Spot - A Ruby implementation of the Spotify Meta API
  • Hallon - Delicious Ruby bindings to the official Spotify API
  • webhallon_wrapper - The bridge between Webhallon and Ruby
  • rchardet - Character encoding auto-detection. Ruby 1.9 compatible
  • levenshteinish - An average distance implementation of the Levenshtein algorithm
  • libspotify-ruby - Bare-bones Ruby bindings for libspotify using Ruby FFI
  • Dimma - A ruby library for the Beacon push REST API
  • em-throttled_queue - A rate-limited Queue for EventMachine
F [2011-05-15 23:06:30] FATAL: Unhandled exception in driver loop - (NoMethodError): undefined method `handle_event' for nil:NilClass
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/driver.rb:151:in `initialize'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/driver.rb:149:in `loop'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/driver.rb:149:in `initialize'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/driver.rb:148:in `new'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/driver.rb:148:in `initialize'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/task.rb:28:in `new'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/task.rb:28:in `initialize'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../lib/god/watch.rb:24:in `initialize'
/usr/local/rvm/gems/ree-1.8.7-2011.03@system/gems/god-0.11.0/bin/../li
@oleander
oleander / uni
Created May 14, 2011 12:58 — forked from fbrosser/uni
universities.markdown
# Hello
------ World Wide/Specialutbyten ------ 1 Dec 2011 -----------------------------------------------------------------------------------------------------------------
NCTU Taiwan
+ https://student.portal.chalmers.se/sv/studier/studera_utomlands/utbytesprogram/civing_arkitekter/world_wide_norden/utbytesuniversitet/taiwan/sidor/nationalchiaotunguniversity(nctu)ihsinchu,taiwan.aspx
Nanyang Technological University (NTU), Singapore
+ http://www.ntu.edu.sg/Pages/default.aspx
+ https://student.gate.chalmers.se/sv/studier/studera_utomlands/utbytesprogram/civing_arkitekter/world_wide_norden/utbytesuniversitet/sidor/singapore.aspx
#!/usr/bin/env ruby -w
require "rubygems"
require "einstein"
Einstein.menu_for(:today).push_to(ENV['EINSTEIN_API_KEY'])

1.a

I Mac OS X:
Under systeminställningar -> nätverk -> Airport

Terminalen:

echo "puts %x{ifconfig}.match(/en0:.+?inet ([^\s+]+)/m).to_a.last" | ruby
# => 46.239.242.31
ERROR: Unable to load plugin heroku_herocutter: undefined method `list' for class `Heroku::Command::Plugins'
==> dyno-2278967.log <==
Jammit Warning: Asset compression disabled -- Java unavailable.
WARNING: Passing separate arguments for a single shadow to text-shadow is deprecated. Pass the values as a single space-separated list, or use the single-text-shadow mixin. See http://beta.compass-style.org/help/tutorials/upgrading/antares/ for more info.
on line 29 of /app/.bundle/gems/ruby/1.8/gems/compass-0.11.1/frameworks/compass/stylesheets/compass/css3/_text-shadow.scss, in `text-shadow'
from line 69 of /app/app/stylesheets/widgets/_channel.scss
from line 21 of /app/app/stylesheets/main.scss
def r(this)
require this
puts "#{this} is now loaded."
rescue LoadError
puts "The gem '#{this}' is missing."
puts "Should I install it? [y/n]"
if gets =~ /yes|y/i
puts "Installing #{this}, hold on."
if `gem install #{this}` =~ /Successfully/
Gem.clear_paths
SELECT COUNT(*) AS count_all, movies.id AS movies_id FROM `movies`
INNER JOIN `genres_movies` ON `genres_movies`.`movie_id` = `movies`.`id`
INNER JOIN `genres` ON `genres`.`id` = `genres_movies`.`genre_id`
INNER JOIN `torrents` ON `torrents`.`movie_id` = `movies`.`id`
INNER JOIN `trackers` ON `trackers`.`id` = `torrents`.`tracker_id`
LEFT JOIN formats_torrents ON formats_torrents.torrent_id = torrents.id
LEFT JOIN formats ON formats.id = formats_torrents.format_id
LEFT JOIN images ON images.movie_id = movies.id
LEFT JOIN sizes ON sizes.id = images.size_id
WHERE `genres`.`id` IN (2, 3) AND
SELECT DISTINCT movies.id, movies.title, images.url as poster
FROM `movies`
INNER JOIN `images` ON `images`.`movie_id` = `movies`.`id`
INNER JOIN `sizes` ON `sizes`.`id` = `images`.`size_id`
WHERE `movies`.`active` = 1 AND
(sizes.name = 'cover')
GROUP BY movies.id