<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>PORQUE SÍ</title>
	
	<link>http://porque.si</link>
	<description>Un caprichoso ejercicio de aleatoriedad</description>
	<lastBuildDate>Mon, 21 Dec 2009 22:56:03 +0000</lastBuildDate>
	<generator>http://wordpress.org/?v=2.9</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/porque_si_en" /><feedburner:info uri="porque_si_en" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><item>
		<title>We’ll always have ah-jelly-pom</title>
		<link>http://feedproxy.google.com/~r/porque_si_en/~3/bINHxvRs_No/well-always-have-ah-jelly-pom</link>
		<comments>http://porque.si/en/reviews/well-always-have-ah-jelly-pom#comments</comments>
		<pubDate>Mon, 21 Dec 2009 22:56:03 +0000</pubDate>
		<dc:creator>carlitos</dc:creator>
				<category><![CDATA[Reviews]]></category>
		<category><![CDATA[Buenos Aires Herald]]></category>
		<category><![CDATA[Gypsy Music]]></category>
		<category><![CDATA[Hungarian Music]]></category>
		<category><![CDATA[The Best Music You Never Heard]]></category>

		<guid isPermaLink="false">http://porque.si/?p=163</guid>
		<description><![CDATA[
It&#8217;s no secret that Gypsies make the best musicians. The Roma –as they call themselves– have always been making music, at literally every occasion, happy or sad, secular or religious. Ever since the time they left their native Rajasthan over a thousand years ago, Gypsies have been absorbing the music of the peoples they met, [...]]]></description>
			<content:encoded><![CDATA[<p><a class="post_image_link" href="http://porque.si/en/reviews/well-always-have-ah-jelly-pom" title="Permanent link to We&#8217;ll always have ah-jelly-pom"><img class="post_image aligncenter" src="http://porque.si/index.php?feedimage=wp-content/uploads/2009/12/karavan_familia_2.jpeg" width="560" height="404" alt="Karaván Familia" /></a>
</p><p>It&#8217;s no secret that Gypsies make the best musicians. The <a href="http://en.wikipedia.org/wiki/Romani_people">Roma</a> –as they call themselves– have always been making music, at literally every occasion, happy or sad, secular or religious. Ever since the time they left their native <a href="http://en.wikipedia.org/wiki/Rajasthan">Rajasthan</a> over a thousand years ago, Gypsies have been absorbing the music of the peoples they met, enriching it and making it their own. Some of them settled down –at least for a while– on what is now Hungary. Today I want to tell about a certain family of Hungarian Gypsy musicians, and why their music will blow you away.</p>

<p><strong><a href="http://www.karavanfamilia.hu/">Karaván Familia</a></strong> is a Gypsy music group from Hungary, formed by István Nagy, his wife Ilona, and their two teenage children István Jr. and Niki. The head of the family sings, arranges and plays guitar in a style that reminds you equally of Django Reinhardt, Paco de Lucía and Carlos Santana. The wife sings in a haunting high-pitched voice which goes from sweet whisper to meteoric lilting in a split second, and dances as well. The children are miniature versions of their parents, and I&#8217;m sure that one day they&#8217;ll become important names in the world of Gypsy music on their own right. For an example of what they do on stage, go to <a href="http://www.karavanfamilia.hu">www.karavanfamilia.hu</a> and take a look at some of their videos.</p>

<p>The group plays traditional Gypsy music from Hungary and elsewhere, using instruments such as acoustic guitar, accordion and a rich assortment of percussion: Middle Eastern <em>darbuqqa</em> (hourglass-shaped drum favourite of bellydancers all over the world), Turkish finger cymbals (<em>zills</em>), Peruvian cajón and the rustic but inimitable steel milk jug, which sounds very much like an <em>udu</em> drum&#8230; or better yet, a slightly drunk <em>udu</em> drum.</p>

<p><strong>Roma Flamenco</strong> is the first album recorded by the Caravan in early 2000s. They got a little help from Boban Marković, one of the most famous Gypsy trumpet players from Serbia, and they also added to some songs a bit of electric bass and synthesized drums (traditional music fans, don&#8217;t cringe, it&#8217;s done tastefully). This album is, start to finish, one of best you&#8217;ve never heard in your life —without a doubt.</p>

<p>The stage is set at the very beginning of the record, with <em>Ki Itt A Legény</em> (Who&#8217;s the Man Here?), a fiery whirlwind of a song that clocks in at 190 beats per minute (read: faster than the Can-Can), and features all of key elements of the album: catchy melodies, very tight arrangements, Marković&#8217;s colourful improvisations, amazing polyphonic singing, the wildest lilting this side of Ireland, and a final accelerando that would make Fatboy Slim go green with envy. If you&#8217;re like me, this song will energize you like an hour on the treadmill would, but without the sweating.</p>

<p><em>Őszi Levél</em> (Autumn leaves), the next song, has a rumba-like feel, and I think that if Karaván were a mainstream act in Argentina, you&#8217;d hear this chorus sung at every football match. And maybe one day they will, you know? I certainly did play the next song, <em>A Tűz Varázsa</em> (&#8220;The Magic of Fire&#8221;), at parties, and people absolutely loved it! Actually, I dare you to listen to it and not hum along.</p>

<p>There&#8217;s a few ballads, too. <em>Pillem, Pillem</em>, <em>Karaván</em> and <em>Tango Gitano</em> add to this colourful and extremely complex mosaic of styles which is Gypsy music. The underlying merry theme is, however, always felt — even in the saddest song of the album, <em>A Szél Dalol</em> (&#8220;The Wind is Singing&#8221;). And when I mean sad, it&#8217;s not because I understand what they&#8217;re singing, no. Lyrics are not included in the liner notes, you can&#8217;t find them online, and not even my Hungarian-speaking friends were able to help. To me, this is by no means a weakness — on the contrary, it allows the spirit of these songs to breathe through&#8230; and hey, it&#8217;s great fun to be able to sing along phonetically again, just like we used to when were kids and didn&#8217;t know any English, don&#8217;t you think?</p>

<p>The album wraps up with <em>Pomagele</em>, the happiest, bounciest song of whole CD. You&#8217;ll have no idea of what you&#8217;re singing, but trust me, you will be singing &#8220;ah-jelly-pom&#8221; with the rest of us&#8230; and if you don&#8217;t, I would check my vitals signs if I were you. Back when I use to DJ, no &#8220;Balkan party&#8221; block would be complete without this song, and I wonder how come nobody has remixed it yet.</p>

<p>Roma Flamenc<strong>o</strong> is an excellent example of authentic, contemporary Gypsy music from Hungary, and Karaván will amaze you with their musical prowess and win you over with their fiery spirit.</p>

<p>If you are like me, you will also wonder how this music from so far away could possibly feel so close to home. But if doesn&#8217;t, hey, we&#8217;ll always have ah-jelly-pom.</p>

<ul>
    <li><strong>Who:</strong> Karaván &amp; Boban Marković</li>
    <li><strong>What:</strong> Roma Flamenco (2001), 12 tracks</li>
    <li><strong>How to get it:</strong> unfortunately, you are not going to find this record at music shops in Argentina. Since currently Amazon doesn&#8217;t have it in stock, I&#8217;d say you get it whichever way you can.</li>
</ul>

<address style="text-align: right;">Originally published at <a title="The Buenos Aires Herald" href="http://www.buenosairesherald.com/">The Buenos Aires Herald</a> on December 5th, 2009.</address>
<img src="http://feeds.feedburner.com/~r/porque_si_en/~4/bINHxvRs_No" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://porque.si/en/reviews/well-always-have-ah-jelly-pom/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://porque.si/en/reviews/well-always-have-ah-jelly-pom</feedburner:origLink></item>
		<item>
		<title>Default user and password for modem/router Ganymede 822+</title>
		<link>http://feedproxy.google.com/~r/porque_si_en/~3/arUMfzHemRA/default-user-and-password-for-modemrouter-ganymede-822</link>
		<comments>http://porque.si/en/cortito-y-al-pie/default-user-and-password-for-modemrouter-ganymede-822#comments</comments>
		<pubDate>Tue, 20 Oct 2009 10:55:39 +0000</pubDate>
		<dc:creator>carlitos</dc:creator>
				<category><![CDATA[Cortito y al pie]]></category>
		<category><![CDATA[Internet]]></category>
		<category><![CDATA[SIOL]]></category>
		<category><![CDATA[Slovenia]]></category>

		<guid isPermaLink="false">http://porque.si/?p=141</guid>
		<description><![CDATA[The default user and password for the modem/router Ganymede 822+, which is quite popular in Slovenia, is user/user.

Just saying, so that our friends at Google index this.

Nothing else to see here, bye!  
]]></description>
			<content:encoded><![CDATA[<p></p><p>The default user and password for the modem/router Ganymede 822+, which is quite popular in Slovenia, is <strong>user/user</strong>.</p>

<p>Just saying, so that our friends at Google index this.</p>

<p>Nothing else to see here, bye! <img src='http://porque.si/wp-includes/images/smilies/icon_smile.gif' alt=':-)' class='wp-smiley' /> </p>
<img src="http://feeds.feedburner.com/~r/porque_si_en/~4/arUMfzHemRA" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://porque.si/en/cortito-y-al-pie/default-user-and-password-for-modemrouter-ganymede-822/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://porque.si/en/cortito-y-al-pie/default-user-and-password-for-modemrouter-ganymede-822</feedburner:origLink></item>
		<item>
		<title>How to organize your iTunes library using tags and taxonomies</title>
		<link>http://feedproxy.google.com/~r/porque_si_en/~3/9kMtZFO2lLc/how-to-organise-your-itunes-library-using-tags-and-taxonomies</link>
		<comments>http://porque.si/en/tutorials/how-to-organise-your-itunes-library-using-tags-and-taxonomies#comments</comments>
		<pubDate>Tue, 15 Sep 2009 19:24:19 +0000</pubDate>
		<dc:creator>carlitos</dc:creator>
				<category><![CDATA[Tutorials]]></category>
		<category><![CDATA[Apple]]></category>
		<category><![CDATA[iTunes]]></category>
		<category><![CDATA[Music]]></category>
		<category><![CDATA[Organization]]></category>

		<guid isPermaLink="false">http://porque.si/?p=110</guid>
		<description><![CDATA[I want to show you how I managed to effectively organise my iTunes library, keeping it simple while not sacrificing detail, and without spending days doing it. I reduced the Genres List by 75%  and ended up with really great ways of rediscovering my own library. I currently have some 8500+ songs in my library, [...]]]></description>
			<content:encoded><![CDATA[<p></p><p>I want to show you how I managed to effectively organise my <a class="zem_slink" title="ITunes" rel="homepage" href="http://www.apple.com/itunes/">iTunes</a> library, keeping it simple while not sacrificing detail, and without spending days doing it. I reduced the Genres List by 75%  and ended up with really great ways of rediscovering my own library. I currently have some 8500+ songs in my library, from widely different styles ranging from Irish Traditional to Classical Hindustani to Argentine Ska and, believe it or not, I can now find everything I want to listen to right away. Keep reading if I got you  interested.</p>

<h3>The problem</h3>

<p>Our music collections are growing. The price per gigabyte of storage keeps going down, and there&#8217;s more music out there that we can possibly imagine. And of course, we want it all. Given time, a healthy musical curiosity and a fast Internet connection, <strong>your iTunes Library will go crazy</strong>. Unknown albums, Unknown Artists, unhelpful Genres (Traditional Turkmenistani, anyone?), and not a thing can help, not even the once-useful iTunes Search, because there is simply no proper metadata to search by.</p>

<h3>The solution</h3>

<p><a href="http://lifehacker.com/153970/tag-your-songs-in-itunes">A short post at Lifehacker</a> suggested a solution. By <em><strong>tagging</strong></em> your music instead of filing it (using the little-known Grouping attribute instead of Genre), you could then use Smart Playlists to filter your collection in any way you saw fit. Go read that post, I&#8217;ll wait.</p>

<p>While tagging certainly <strong>is</strong> more flexible than filing, after thorough testing I found this method to be a bit <em><strong>too</strong></em> flexible. In other words, you soon ended up with another mess inside the Grouping attribute, and the bloated, ugly Genre list was still there looking at you.</p>

<p>After some more testing I improved this already great original idea by <strong>adding to it the concept of taxonomies</strong>. If you&#8217;re not familiar with the term, a taxonomy is a way of grouping items (e.g. Color=Red). Since we&#8217;re talking about music here,  two useful taxonomies come to mind: Country and Language, which we&#8217;ll use to identify where an artist is from, and in which language they sing. You could also add Instruments, but hey, let&#8217;s keep it simple.</p>

<p>Finally, one of iTunes 9&#8217;s less known new features is the  revamped Column Browser, which now makes it possible to filter by our friend  the Grouping attribute, which is excellent for our task at hand. Oh and by the way <a class="zem_slink" title="Apple" rel="homepage" href="http://www.apple.com">Apple</a>, you spelled &#8220;Groupings&#8221; in the Column Browser, but &#8220;Grouping&#8221; in the Get Info window. Thought nobody would spot that, hmm? <img src='http://porque.si/wp-includes/images/smilies/icon_wink.gif' alt=';-)' class='wp-smiley' /> </p>

<h3>First thing first: trim your genres!</h3>

<p>Before diving into this taxonomy thingy,  though, start by trimming your genre list. Go into Grid Mode (cmd+alt+4 Macs) and select the <strong>Genres</strong> tab. Pick one of the more obscure ones, edit (right mouse click, Get Info) and make all its items look more mainstream. Repeat until your Genre List looks as boring as Tower Record&#8217;s aisles. Yes, <strong>genres in your library should match  aisles in a record store, and not sections in record bays</strong>. Use the broadest genres you can think of. Trust me, you&#8217;ll see why later.</p>

<ul>
    <li> Good examples: World, Latin, Rock &amp; Pop, Soundtrack, Children, Electronic, Classical.</li>
    <li> Bad examples: Celtic, Latin-Colombia, Choral, French chanson, Americana, Throat Singing, Instrumental.</li>
</ul>

<p>When in doubt, go for those genres iTunes has icons for, because if nothing else, they&#8217;re sexy. Don&#8217;t be afraid of using big &#8216;catch-all&#8217; genres such as Rock, Pop or Soundtrack, because you&#8217;ll be slicing your library using Smart Playlists anyway, ninja-style. My Library has barely 25 genres now, and my &#8220;Rock &amp; Pop&#8221; genre has 196 albums and 1930 songs, in case you were wondering.</p>

<p>There is one exception, though. If you&#8217;re a true connoisseur of a particular genre, and you  absolutely need to add a few extra subgenres to show off your amazing filing skills at let&#8217;s say, <a class="zem_slink" title="Qawwali" rel="wikipedia" href="http://en.wikipedia.org/wiki/Qawwali">Qawwali</a>, by all means do so (Qawaali Fusion and Qawalli Remix are good subgenres for that, by the way). It&#8217;s your library after all, and any system should work for you, not the other way around.</p>

<p>Finally, if you&#8217;re like me you&#8217;d like to tag songs individually by genre, regardless of the album&#8217;s main genre, such as a Spoken Word interlude between songs from a Soundtrack album. Resist this impulse, unless it makes perfect sense to you. Make all songs inside an album have the same genre.</p>

<h3>Adding taxonomies</h3>

<p>Now it&#8217;s time to start adding tags and taxonomies to the Grouping attribute. For example, let&#8217;s say you&#8217;ve selected all the songs from ABBA&#8217;s excellent compilation Gold. I would tag them like this (and as a matter of fact, I have):</p>

<p><img class="aligncenter size-full wp-image-116" title="itunes-using-taxonomies-to-tag-your-music" src="http://porque.si/index.php?feedimage=wp-content/uploads/2009/09/itunes-using-taxonomies-to-tag-your-music1.png" alt="itunes-using-taxonomies-to-tag-your-music" width="640" height="540" /></p>

<p>What this means is that all 19 songs will be tagged as being from the planet Sweden, and sung in English. I separate tags and taxonomies with simple commas, but anything will do really. I&#8217;m used to commas.</p>

<p>From here on, you can add more tags and/or taxonomies as you see fit. Examples could be &#8220;dance&#8221;, &#8220;80&#8217;s sparty&#8221;, &#8220;Bands with creepy haircuts&#8221; or &#8220;When mainstream music didn&#8217;t suck&#8221;. As they say, the sky&#8217;s the limit, but the more anal you get with the tagging, the easier it&#8217;ll be to find your music later. Basically lather, rinse, repeat until your obsessive-compulsive inner self is happy.</p>

<h3>Enter Really Smart Playlists</h3>

<p>So, you&#8217;ve tagged all you music. Congratulations! Now the fun begins. Let&#8217;s create a Smart Playlist (cmd+alt+N if you&#8217;re on a Mac) to match Swedish music, as follows:</p>

<p><img class="aligncenter size-full wp-image-118" title="itunes-using-taxonomies-to-tag-your-music-2" src="http://porque.si/index.php?feedimage=wp-content/uploads/2009/09/itunes-using-taxonomies-to-tag-your-music-22.png" alt="itunes-using-taxonomies-to-tag-your-music-2" width="640" height="259" /></p>

<p>Simple, huh? This will grab all the ABBA music in your library (admit it, you have some!), as well as <a class="zem_slink" title="Yngwie Malmsteen" rel="homepage" href="http://www.yngwiemalmsteen.com">Yngwie Malmsteen</a>, <a class="zem_slink" title="Roxette" rel="homepage" href="http://www.roxette.se/">Roxette</a>, Ace of Base and The Cardigans <small>(and maybe now would be a good time to  meditate on your musical tastes, don&#8217;t you think?)</small>. Now switch to Grid View, and you might see something like this:</p>

<p><img class="aligncenter size-full wp-image-120" title="itunes-using-taxonomies-to-tag-your-music-3" src="http://porque.si/index.php?feedimage=wp-content/uploads/2009/09/itunes-using-taxonomies-to-tag-your-music-3.png" alt="itunes-using-taxonomies-to-tag-your-music-3" width="640" height="521" />See the selected Smart Playlist on the left? You can create as many as you want, as I have, and even <em>combine</em> multiple Grouping filters. So next time you need your fix of Japanese videogame orchestral soundtrack music, you&#8217;ll only have to  create the following Smart Playlist:</p>

<p><img class="aligncenter size-full wp-image-121" title="itunes-using-taxonomies-to-tag-your-music-4" src="http://porque.si/index.php?feedimage=wp-content/uploads/2009/09/itunes-using-taxonomies-to-tag-your-music-4.png" alt="itunes-using-taxonomies-to-tag-your-music-4" width="640" height="312" /></p>

<p>Yes, the mind boggles. And by the way, you can see an example of a subgenre right there with <strong>Soundtrack (Videogames)</strong>. Maybe one day I&#8217;ll merge them all in a <strong>Soundtrack</strong> genre, and create more tags to split them apart, but for the time being, I have three different types of soundtracks, and all is well.</p>

<h3>Some example cases</h3>

<ul>
    <li>U2&#8217;s music is <strong>Rock &amp; Pop</strong> (genre) and <strong>Country=Ireland, Language=English</strong> (grouping). Instrumentals such as The Unforgettable Fire&#8217;s &#8220;4th of July&#8221; lack the Language=English taxonomy, since there are no lyrics, but sport the <strong>Instrumental</strong> tag.</li>
    <li>Music by Iranian pop star Andy Madadian is <strong>World</strong> (genre) and <strong>Country=Iran</strong> (grouping). He sings in many different languages, so <strong>Language=Farsi</strong> is not always the case.</li>
    <li>Madness is <strong>Rock &amp; Pop</strong> (genre), and <strong>Country=UK, Language=English, Ska</strong> (grouping). I don&#8217;t use a Ska genre for the reasons outlined above. Keep the genres always as simple as possible, unless, well, you happen to be a Ska nut.</li>
    <li>The genre for the soundtrack to Guy Ritchie&#8217;s movie Snatch  is <strong>Soundtrack (Films)</strong>, and the Grouping attribute changes from song to song. You have Soul, Spoken Word, 80s Pop, Ska, Electronica, Jewish traditional instrumentals, Brit Pop, and Motown. <em>And you can feed them all into the Grouping attribute</em>. This is a good example  where this taxonomy+tags method really shines, because there&#8217;s simply no other organization method that can handle this level of diversity within a single album.</li>
    <li>Señor Coconut&#8217;s album El Baile Alemán &#8211; Latin versions of Kraftwerk gets the <strong>Latin</strong> genre, and something like <strong>Country=Germany, Country=Chile, Covers</strong> as Grouping.</li>
</ul>

<h3>Conclusion</h3>

<p>This method solved all the problems that came from having a  large and varied iTunes music collection. Sure, you have some tagging work to be done, and depending on how precise you want to be, it could take a looooong time, but hey, nothing worth doing is easy.</p>

<p>So finally, you might ask why using Genres after all? It is a good question, and we could technically do away with genres completely, but  iTunes has them hardwired in several places by default, so I think it&#8217;s best to let them be&#8230; just don&#8217;t get too picky with them. They&#8217;re aisles in a music store anyway, remember? And you don&#8217;t complain with <em>that</em>, do you? <img src='http://porque.si/wp-includes/images/smilies/icon_smile.gif' alt=':-)' class='wp-smiley' /> </p>

<p>I hope  this tutorial was useful, and if you spot any errors or typos or there&#8217;s anything you&#8217;d like to say, use the comment form!</p>

<div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><a class="zemanta-pixie-a" title="Reblog this post [with Zemanta]" href="http://reblog.zemanta.com/zemified/5c2dbb88-9354-4746-9461-181131ba72a7/"><img class="zemanta-pixie-img" style="border: medium none; float: right;" src="http://img.zemanta.com/reblog_e.png?x-id=5c2dbb88-9354-4746-9461-181131ba72a7" alt="Reblog this post [with Zemanta]" /></a><span class="zem-script more-related pretty-attribution"><script src="http://static.zemanta.com/readside/loader.js" type="text/javascript"></script></span></div>
<img src="http://feeds.feedburner.com/~r/porque_si_en/~4/9kMtZFO2lLc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://porque.si/en/tutorials/how-to-organise-your-itunes-library-using-tags-and-taxonomies/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://porque.si/en/tutorials/how-to-organise-your-itunes-library-using-tags-and-taxonomies</feedburner:origLink></item>
		<item>
		<title>On America’s morality and religion</title>
		<link>http://feedproxy.google.com/~r/porque_si_en/~3/IhHlf3FZETw/on-americas-morality-and-religion</link>
		<comments>http://porque.si/en/ruminations/on-americas-morality-and-religion#comments</comments>
		<pubDate>Wed, 26 Aug 2009 22:15:05 +0000</pubDate>
		<dc:creator>carlitos</dc:creator>
				<category><![CDATA[Ruminations]]></category>
		<category><![CDATA[Literatura]]></category>
		<category><![CDATA[Neil Gaiman]]></category>
		<category><![CDATA[Religión]]></category>

		<guid isPermaLink="false">http://porque.si/?p=94</guid>
		<description><![CDATA[

  Image via Wikipedia 



America has invested her religion as well as her morality in sound income-paying securities. She has adopted the unassailable position of a nation blessed because it deserves to be blessed; and her sons, whatever other theologies they may affect or disregards, subscribe unreservedly to this national creed.

Agnes Repplier, Times and [...]]]></description>
			<content:encoded><![CDATA[<p></p><div class="mceTemp">
<div class="zemanta-img zemanta-action-dragged" style="margin: 1em; display: block;">
<div><dl class="wp-caption alignleft" style="width: 310px;"> <dt class="wp-caption-dt"><a href="http://commons.wikipedia.org/wiki/Image:Agnes_Repplier.jpg"><img title="Agnes Repplier (1855-1950), American essayist" src="http://upload.wikimedia.org/wikipedia/commons/thumb/d/d8/Agnes_Repplier.jpg/300px-Agnes_Repplier.jpg" alt="Agnes Repplier (1855-1950), American essayist" width="300" height="406" /></a></dt> <dd class="wp-caption-dd zemanta-img-attribution" style="font-size: 0.8em;">Image via <a href="http://commons.wikipedia.org/wiki/Image:Agnes_Repplier.jpg">Wikipedia</a></dd> </dl></div>
</div>
</div>

<p>America has invested her religion as well as her morality in sound income-paying securities. She has adopted the unassailable position of a nation blessed because it deserves to be blessed; and her sons, whatever other theologies they may affect or disregards, subscribe unreservedly to this national creed.</p>

<p style="text-align: right;"><strong>Agnes Repplier, Times and Tendencies (1931)</strong></p>

<p>Taken from an introduction to a chapter of <strong>American Gods</strong>, Neil Gaiman&#8217;s masterpiece. Makes you think, huh?</p>

<div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><span class="zem-script more-related pretty-attribution"><script src="http://static.zemanta.com/readside/loader.js" type="text/javascript"></script></span></div>
<img src="http://feeds.feedburner.com/~r/porque_si_en/~4/IhHlf3FZETw" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://porque.si/en/ruminations/on-americas-morality-and-religion/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://porque.si/en/ruminations/on-americas-morality-and-religion</feedburner:origLink></item>
		<item>
		<title>HOWTO use rsync to deploy WordPress sites to WebFaction</title>
		<link>http://feedproxy.google.com/~r/porque_si_en/~3/AcAmzqWz3Ig/howto-use-rsync-to-deploy-wordpress-sites-to-webfaction</link>
		<comments>http://porque.si/en/tutorials/howto-use-rsync-to-deploy-wordpress-sites-to-webfaction#comments</comments>
		<pubDate>Mon, 24 Aug 2009 13:44:05 +0000</pubDate>
		<dc:creator>carlitos</dc:creator>
				<category><![CDATA[Tutorials]]></category>
		<category><![CDATA[Development]]></category>
		<category><![CDATA[PHP]]></category>
		<category><![CDATA[rsync]]></category>
		<category><![CDATA[WebFaction]]></category>
		<category><![CDATA[WordPress]]></category>

		<guid isPermaLink="false">http://porque.si/?p=74</guid>
		<description><![CDATA[These days I&#8217;m spending a lot of time developing a WordPress-powered site, not yet online at the time of this writing. My workflow is simple: I develop at my home box (Mac OSX + XAMPP + Komodo Edit + Sequel Pro, thank you very much), and from time to time I deploy to a private [...]]]></description>
			<content:encoded><![CDATA[<p></p><p>These days I&#8217;m spending a lot of time developing a <a class="zem_slink" title="WordPress" rel="homepage" href="http://wordpress.org">WordPress</a>-powered site, not yet online at the time of this writing. My workflow is simple: I develop at my home box (<a class="zem_slink" title="Mac OS X" rel="homepage" href="http://www.apple.com/macosx/">Mac OSX</a> + <a class="zem_slink" title="XAMPP" rel="homepage" href="http://www.apachefriends.org/en/xampp.html">XAMPP</a> + <a class="zem_slink" title="ActiveState Komodo" rel="homepage" href="http://www.activestate.com/komodo/">Komodo Edit</a> +<a href="http://www.sequelpro.com/"> Sequel Pro</a>, thank you very much), and from time to time I deploy to a private URL hosted with <a href="http://www.webfaction.com/?affiliate=carlitos">WebFaction</a>, where the rest of the project&#8217;s team can check for updates, give opinions, etc.</p>

<p>First I tried using a private <a class="zem_slink" title="Subversion (software)" rel="homepage" href="http://subversion.tigris.org/">Subversion</a> repository, but it choked every time WordPress -or any plugin!- was updated, so in the end  <strong><a class="zem_slink" title="Rsync" rel="homepage" href="http://rsync.samba.org/">rsync</a></strong> proved to be the right tool for the job. I wrote these instructions  on how to do this deployment mostly for myself, but I thought &#8217;someone out there&#8217; could benefit from them as well, so here we go. You&#8217;ll thank me later.</p>

<p class="alert"><strong>IMPORTANT:</strong> while this HOWTO applies directly to <a href="http://www.webfaction.com/?affiliate=carlitos">WebFaction</a> customers only —and you should give them a try if you&#8217;re considering switching hosting companies, they&#8217;re great— resourceful Web boys and girls will surely know how to make it work  at  their Web company of choice too. <img src='http://porque.si/wp-includes/images/smilies/icon_smile.gif' alt=':-)' class='wp-smiley' /> </p>

<h3>Requirements</h3>

<ul>
    <li>A fantastic WordPress-powered Website running on your box, itching to be deployed.</li>
    <li>The <strong>rsync</strong> command line tool running on your local box. Normally built-in with Linux or Mac OSX, I guess it <em>should</em> work under <a href="http://www.cygwin.com/">cygwin</a> as well, but I haven&#8217;t tried.</li>
    <li>A  way to export your <a class="zem_slink" title="MySQL" rel="homepage" href="http://www.mysql.com">MySQL</a> database. I use  Sequel Pro, but <a class="zem_slink" title="PhpMyAdmin" rel="homepage" href="http://www.phpmyadmin.net">phpMyAdmin</a> or mysqldump if you&#8217;re hardcore, will do just as well.</li>
    <li>Your favourite text editor. I prefer <strong>vi</strong>, because I&#8217;m old.</li>
    <li>An account with WebFaction. Any plan will do, since we only need SSH login and their Control Panel.</li>
</ul>

<h3>Step by step</h3>

<p>Start by going to your WebFaction control panel, and create a new <strong>Static/CGI/PHP</strong> Application. Call it <em>myproject</em>, and hit <strong>Create</strong>. It&#8217;s up to you to wire it to one of your domains, so I won&#8217;t touch on that here.</p>

<p>Now fire up  a terminal session at your home box, change to your  project&#8217;s root directory, and type:</p>

<p><code> cp wp-config.php wp-config.php.tmpl</code></p>

<p>Now paste the following line into a new file called rsync_exclude.txt, which will live at the same directory:</p>

<p><code>wp-config.php</code></p>

<p>The previous two commands will make sure your local configuration settings will not overwrite those in the production environment every time you rsync.  Now we&#8217;re ready to invoke rsync&#8217;s magic:</p>

<p><code>rsync -avzh --delete --exclude-from '/path/to/local/wordpress/rsync_exclude.txt' . YOURUSERNAME@YOURBOX.webfactional.com:/home/YOURUSERNAME/webapps/myproject</code></p>

<p>This command does the following:</p>

<ul>
    <li>It mirrors the exact state of your local development root directory with your live site at WebFaction, adding, modifying and <strong>deleting</strong> files as needed. Exercise good-old common sense while running this line, OK? (if you&#8217;re not too sure, add the -n parameter, which asks rsync to do a &#8216;dry run&#8217; only, without changing anything at the destination site).</li>
    <li>The -avzh instructs  rsync to process all hard links, preserve file attributes and other niceties, use compression for faster transfers, and display human-friendly statistics.</li>
    <li>The &#8211;exclude-from switch does what you expect: tells rsync to skip what&#8217;s listed on rsync_exclude.txt, which is nothing but  WordPress&#8217;  local configuration settings (the wp-config.php file).</li>
    <li>The last two parameters describe the source and target directories to sync. The single dot (.) means &#8220;the current directory I&#8217;m in&#8221;, and the target directory is actually a combination of a SSH-enabled host plus the full  path, separated by a colon. rsync will ask for your SSH password, so don&#8217;t worry about that.</li>
</ul>

<p>Almost ready now!</p>

<p>Log into your box using SSH, change to ~/webapps/myproject, and execute:</p>

<p><code>cp wp-config.php.tmpl wp-config.php</code></p>

<p>Now go and edit wp-config.php and change the database connectivity options (DB_NAME, DB_USER, DB_PASSWORD, DB_HOST, and maybe DB_CHARSET and/or DB_COLLATE) to reflect your production environment. Which reminds me&#8230;</p>

<h3>What about the database?</h3>

<p>The method outlined above takes care of the <span class="zem_slink">PHP</span> side of things only. If you&#8217;re also producing content at your home development box, as I am, you&#8217;d like to copy your database over to the production environment as well. <strong>And rsync can help here too</strong>.</p>

<p>Using your MySQL frontend of choice, connect to your local host and dump your project&#8217;s  full database  to a file with a .sql extension (use today&#8217;s date as part of the the filename, it&#8217;ll help). If you&#8217;re using<strong> Sequel Pro</strong>, go to File -&gt; Export -&gt; MySQL dump and you&#8217;re set. Save the dump file with the rest of the stuff at your project&#8217;s root directory, and rsync will catch it next time.</p>

<p>If you develop locally using &#8220;localhost&#8221; or &#8220;myproject.local&#8221; as your home URL, as most of us do, you will have to edit the dump file and replace all local URLs with  &#8220;live&#8221; URLs. If you use vi, this is a one-liner:</p>

<p><code>:1,$ s/myproject&#46;local/myproject&#46;com/g</code></p>

<p>(That means in <em>oldfartese</em> &#8220;change all the occurrences of the string myproject.local into myproject.com&#8221;)</p>

<p>Do a rsync now, watch your dump file get copied, and SSH to WebFaction.  We&#8217;re going to run one command that will overwrite your production database with the contents of the SQL dump file you just rsync&#8217;d. Which means <strong>you will not do this once your Website is live, unless you&#8217;ll have an excellent reason to do so</strong>. For the purposes of this example,   &#8220;latest.sql&#8221;  will be the dump file, and the production MySQL database will be &#8220;xyuser_myproject&#8221;. The command to run (at ~/webapps/myproject/) will be:</p>

<p><code>mysql --user=YOUR_SQL_USERNAME --password=YOUR_SQL_PASSWORD xyuser_myproject &lt; latest.sql</code></p>

<p>And that&#8217;s all folks! You should now point your browser to your live WebFaction URL, and see your updated WordPress-powered Website. Now wasn&#8217;t that easy!</p>

<h3>Conclusion / Everyday use</h3>

<p>Now that I look back at all those scary paragraphs and lines of code, I&#8217;d like to say that for everyday use, this solution is actually pretty straightforward. It&#8217;s a matter of firing up Sequel Pro, exporting, running <strong>sync.sh</strong> (which is nothing but a wrapper shell script that invokes the rsync line), and SSH&#8217;ing to WebFaction to import the data back in. With a bit of extra shell script-fu, I&#8217;m sure you could streamline the process even more, let&#8217;s say to bypass Sequel Pro and to everything with MySQL built-in command line tools.</p>

<p>So, what do you think? Did this article help you? Found any bugs? Anything doesn&#8217;t work? Drop a line at the comments!</p>

<p class="alert"><strong>UPDATE:</strong> big thanks go to <strong><a href="http://japh.com.au/">Japh</a></strong> for his help in simplifying this tutorial. Isn&#8217;t the Internet a great thing? <img src='http://porque.si/wp-includes/images/smilies/icon_wink.gif' alt=';-)' class='wp-smiley' /> </p>

<div class="zemanta-pixie" style="margin-top: 10px; height: 15px;"><a class="zemanta-pixie-a" title="Reblog this post [with Zemanta]" href="http://reblog.zemanta.com/zemified/3ca0752a-2c9e-461a-aa46-ad71dbfe91e2/"><img class="zemanta-pixie-img" style="border: medium none; float: right;" src="http://img.zemanta.com/reblog_e.png?x-id=3ca0752a-2c9e-461a-aa46-ad71dbfe91e2" alt="Reblog this post [with Zemanta]" /></a><span class="zem-script more-related pretty-attribution"><script src="http://static.zemanta.com/readside/loader.js" type="text/javascript"></script></span></div>
<img src="http://feeds.feedburner.com/~r/porque_si_en/~4/AcAmzqWz3Ig" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://porque.si/en/tutorials/howto-use-rsync-to-deploy-wordpress-sites-to-webfaction/feed</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://porque.si/en/tutorials/howto-use-rsync-to-deploy-wordpress-sites-to-webfaction</feedburner:origLink></item>
	</channel>
</rss>
