Skip to content

Instantly share code, notes, and snippets.

@stevenleeg
stevenleeg / gist:4128236
Created November 21, 2012 22:20
[Musicbrainz] Get meta data from release mbid
SELECT
musicbrainz.release.gid AS release_mbid,
musicbrainz.release_meta.amazon_asin AS asin,
musicbrainz.release_meta.cover_art_presence AS art
FROM
musicbrainz.release_group
INNER JOIN musicbrainz.release
ON musicbrainz.release.release_group = musicbrainz.release_group.id
@stevenleeg
stevenleeg / artist_albums.sql
Created November 20, 2012 18:39
[Musicbrainz] Get albums by artist mbid
SELECT
musicbrainz.release_group.gid AS release_mbid,
musicbrainz.release_group.type AS primary_type,
musicbrainz.release_group_secondary_type_join.secondary_type AS secondary_type,
musicbrainz.release_name.name AS release_name
FROM
musicbrainz.artist
INNER JOIN musicbrainz.artist_credit_name
ON musicbrainz.artist_credit_name.artist = musicbrainz.artist.id
@stevenleeg
stevenleeg / git.sh
Created October 10, 2012 01:21 — forked from clehner/git.sh
Simple Interactive Git Shell
#!/bin/bash
# git.sh - Interactive Git Shell
# store command history here
HISTFILE=~/.gitsh_history
control_c() {
# save history before exiting
history -a
# i can't figure out how to make this just break out of the read command
@stevenleeg
stevenleeg / Coffeescript version
Created June 16, 2012 19:45
Compiled source of app.js
window.App = {}
get_template = (el, tpl, callback, context = {}) ->
$(el).html(_.template("hello", context));
callback();
class App.IndexView extends Backbone.View
template: "index"
el: $("#container")