Skip to content

Instantly share code, notes, and snippets.

View artlung's full-sized avatar
💭
🤖

Joe Crawford artlung

💭
🤖
View GitHub Profile
@njh
njh / musicbrainz-twitter.sql
Created September 8, 2011 21:31
Twitter accounts in MusicBrainz
COPY (SELECT artist.gid, artist_name.name, url.url FROM url
JOIN l_artist_url ON (url.id = l_artist_url.entity1)
JOIN artist ON (artist.id = l_artist_url.entity0)
JOIN artist_name ON (artist_name.id = artist.name)
WHERE url LIKE '%twitter.com%') TO STDOUT WITH CSV;
891abb2e-0156-411b-bf60-f4104e71ddfa,SMiLE.dk,http://twitter.com/smiledkmusic
aead4c74-d7e1-4960-8cec-bacb86617924,Triobelisk,http://twitter.com/triobelisk
89bf7e7f-34ef-4d91-a4f2-4f2bfe8c5c67,Freeze The Atlantic,http://twitter.com/fta_band
@cowboy
cowboy / HEY-YOU.md
Last active July 16, 2025 03:49
jQuery Tiny Pub/Sub: A really, really, REALLY tiny pub/sub implementation for jQuery.
@artlung
artlung / StructToQueryString.cfm
Created October 11, 2010 14:22
StructToQueryString() ColdFusion
<!---
<cfset submit_URL = StructNew()>
<cfset submit_URL.something = 1>
<cfset submit_URL.something2 = 2>
<cfset submit_URL.other = "hello world">
<cfoutput>
#StructToQueryString(Submit_URL)#
</cfoutput>