After my post from yesterday evening, WordPress analytics are telling me that almost 13,000 views (mostly from Hackernews) have seen that post in less then 24 hours. I don’t know about you, but for me, this is pretty amazing, and I’m very thankful.
I would also like to mention that you can suggest (in comments) any additional ideas, or that you can even implement it right away, push it to Github and send me a pull request.
- World `countries` – database table for MySQL (echobehind.wordpress.com)
- Trying to translate a MySQL query into a PHP query (stackoverflow.com)
So today, I was buzzing around and searching for a `countries` table script that I could use in MySQL database. As you can imagine, it wouldn’t make any sense to add all world countries into database table one-by-one.
I’ve found few interesting things around there, but all of those solutions were not flexible and were created for individual projects – and when I say that, I mean that some of those tables have only two columns (like country code and country name), some of those have 3 columns, and some of those have bunch of columns (that are probably not useful to many developers).
Anyway, after checking some of those solutions I came to idea that I could make something on my own – something that will be flexible and customizable. And the result was GetCountries “program” where you can select which columns do you want, click “Get it!” and the program will fetch “fresh” results from Geonames API and will generate you a SQL script. After that you can copy/paste that script and eventually change column names.
Hope someone will find that useful.
- Handy PHP and MySQL Queries for Developers (dzone.com)
- Trying to translate a MySQL query into a PHP query (stackoverflow.com)
- MySQL ordering results by specific field values (techtalk.virendrachandak.com)
- Open Source Wars (arnoldit.com)
Since Propagandhi has released a new album called “Failed States”, I’ve remembered that, few years ago, I’ve made an interview with them – for a Dead Space webzine that was active back then. I’ve found this interview, I’m looking at it and can’t believe to some of my questions, but hey, people change, and this was 5 years ago :) Anyway, I would like to share that interview with you so here it is.
Propagandhi, we all know it’s great melodic hardcore punk band from Canada. This interview was made (answered) on april 24, 2007. The interview was made by mail, answered by Todd. Enjoy.
Hi Todd and Propagandhi, as a first question I would ask you to present the Propagandhi to the people in Croatia. And if you want, can you tell us your age and how many years is each of you playing (instrument that you play)?
Hello, Perić! It’s nice to talk to you. Well, I (Todd) Am 33, I’ll be 34 next month. Chris and Jord are 36 and Beave is 28. Chris and Jord have been together for 18 years or so. I’ve been in the band for 11 years; Beave has been with us for about 8 months. I’m on bass. Chris is on guitar, Jord is on Drums, Beave is on Guitar.
And one more thing. can you tell us something about your past bands (I now that before Propagandhi there was also some other bands that you guys were involved)?
Well, Beave was in a band called Giant Sons which was really good. I was in I Spy and Swallowing Shit. I Spy did a 10″ split record with Propagandhi in about 1992. G7 has since released both bands recordings.
When did you start the “G7 Welcoming Committee Records” and what was the primary reason? Of the band members, who is active on project “G7 Welcoming Committee Records”, are the whole band helping in this?
G7 was started by Chris and Jord. Jord quit about 5 years ago. Chris and our friend Derek Hogue do the label now. It was started to introduce interesting bands with good ideas to the public. Perhaps drawing on a bit of Propagandhi’s following a bit.
For the new album you made a joke where you said that Chris Hannah has left the band and that the new singer and guitarist is Glen Lambert; where did you get an idea for this and why? I think that a lot of people were assured that this is true.
Haha. Yeah, that was kind of a spur of the moment thing for a laugh. I like how everybody was so concerned about Lambert and his mental health. haha.. NOFX even wrote a song pitying the guy. haha..What a world! We played that up pretty good to get kids mad at Lambert.
The music that you playing on “G7 radio” is different one from another. are you listening a lot of kinds of music? I saw that there is punk rock, hardcore, old school hardcore, crust, rap,. Who are your favorites (bands)?
My favorite bands are SNFU, Razor, Sacrifice, Dio, Fates Warning, real old C.O.C. etc.. I also like a lot of African music such as Gigi Shebawbaw, Salif Keita etc. I love them.
I don’t know how much, but it has past a lot of time since you have been on tour in Europe. When are you planning European tour again?
Right now we have no idea when we’ll be back there. I hope we’ll be back soon.
Would you like to visit Croatia, maybe and Pazin(our small town)?
We’d love to come to Pazin sometime!
If it’s not a secret, can you tell me/us how much money are you asking for a gig (on tour in Europe)?
Every show changes in regards to what we get paid. we keep the shows reasonably cheap and then see how many people can attend the show, how much a countries currency is worth, what’s the state of the economy, what is a reasonable price to charge etc. then we take it from there.
Do you have a contract with the Fat Wreck or is it just verbal agreement?
We just have a verbal agreement.
I am asking because you are releasing album every 5 years approximately, and the other bands on Fat Wreck (like Lagwagon, Lawrence Arms, Strung Out,.) are releasing their albums every year, every two years or three years maximum, so I think that you maybe don’t have contract with them, that you are releasing your stuff when you want (that you are totally free in this way)?
Yeah, we do whatever we want with ourselves. Hah. I guess those other bands feel like two years is a good amount of time to get their songs together. We wouldn’t be ready in that amount of time. We’re trying to be a little faster this time around.
I heard your live “Curse of the MTV punks”. do you have always conflicts with the “punks” that simply don’t understand what are they fighting for, and even what are they try to say?
I’m not sure what that “Curse of the MTV Punks” is, to tell you the truth. But to answer your question; punks are just a crossection of general society these days so we don’t tend to agree with or enjoy most punks. haha. but I can’t say we really are in conflict with them. We just go about our business. I hope I’m too old to be in conflict with punks. ha. I’m too busy engaging in undercover espionage.
Except band and record label, do you have some other job like “ordinary” people?
Haha.. Today I say no in about a month I’d have to answer yes, unfortunately. Jord and Beave both have jobs. Me and Chris are trying to hang on to the good life. Having said that Chris and I do work really hard and do not sit around wasting our time. We are geared towards being productive and self sufficient. This plan is, however, now taking a bender. haha..
Are you guys vegans or vegetarians? Are each of us in band supporting that way of living?
We are all vegans. We all have to believe in the lyrics and songs we’re playing. Veganism is an extension of our quest for justice and liberty it is a very important aspect to the band.
I think that this thing means a lot to you, so I’m asking.
You are correct, Perić!
What do you think about internet?
It’s product of globalization but it’s also very useful thing. in the sense of D.I.Y. propaganda.
The internet is good and bad. It connects people and is a good way of knowing what’s going on in the world and helps people gets their stories and ideas out to each other. On the other hand it can also be a big waste of time and there are a lot of freaks out there taking advantage of others using it. These people would exist with or without it, though. The internet is probably more good than bad at the moment.
Where are you recording your albums? I think I was reading that you are recording some stuff by yourself?! Are you paying your albums by yourself or is it Fat Wreck financing you?
Heheh.. Fat financed our last record which is why we owe them money. haha.. Recording is an expensive, life squeezing rip off. We might record the next record ourselves. We did most of the last one ourselves. Chris is getting really good at recording that shit.
On your website, and in your lyrics I can see that you read a lot of stuff, a that you know a lot about the war in Iraq, about testing products on animals,. and a lot of other stuff that you won’t see on the TV, or in the newspapers. I would like to ask you. do you know something about Croatia? About our fuckin’ bad politics, war that was here in the beginning of the 90’s and other stuff?
Yeah, I’ve read quite a bit about Croatia and the war. I also have some Croatian friends here in Winnipeg as well. Actually Elizabeth Neuffer who wrote my favorite book about the war was killed in Iraq recently covering that war. I would love to go to Croatia and see the country for myself. I have heard it is also very beautiful.
What do you think about marriage? Is it necessary or unnecessary?
I don’t really care too much. It’s up to the people who are getting married to decide what it means for them. If it is something that makes them happy then go for it. I’ve seen it backfire quite often. haha..
Is it someone from Propagandhi in marriage?
None of us are married. Who would marry us? A Troll covered in dogshit? haha..
I’m asking all this because my opinion about marriage is that marriage is unnecessary, because if you love someone you don’t need a ”contract” for that.
I tend to agree but whatever. Some people like the ceremony or the acknowledgement, or more likely the gifts that go along with it. haha…
On your website, I saw an interview when one guy wrote you a word association, so I’ll do the same now. I would write you few words (associations), and you tell me first thing that comes to your mind?
-LP (I mean on gramophone record, not Linkin Park ;)) – Razor, Shotgun justice! I wish I had that LP. Haha.
-Minor Threat – bald kid, white shirt. Pretty good.
-Coca-Cola – makes your teeth stick together. Makes you feel like shit.
-Straight Edge – I wish I could get a long, clear plastic ruler.
-Fanzines – Jord and Chris were interviewed in their favorite zine, “Navel gazing” hahaha. Inside joke, for my own amusement.
Somewhere in August, or September 2002, there were some rumors about Propagandhi gig in Zagreb, in club Attack. Do you now, what happened with this, why this gig wasn’t maintained?
This was just a rumour. I wish it was true! We had no plans.
Are you still going to the punk/hardcore gigs? Still supporting underground and diy bands, buying diy records (tapes, cd’s, lp’s,.)?
I don’t buy many new cd’s or anything. I don’t download them either. I go to shows sometimes. I’m pretty busy and get up early so I tend to miss a lot of them. I guess we try to support smaller bands by taking them on tour or having G7 help them or whatever. If a band I’m into comes to town I go watch them for sure. Actually, me and Chris traveled about 2000 miles to see Sacrifice! I listen to my old records every day. I tend to like non western music better these days it seems to have more heart or something.
Commercialism has ruined my quest to find good underground bands. I don’t know where to look anymore. Most bands end up disappointing anyway when they sell out after two years. haha..
So, this is it. We made it finally. Do you have something else to mention for the end, someone to say hello, something else? I hope I will see you live, soon of course.
Well, I guess I’d like to say that I hope we’ll make it out to Croatia sometime soon. Now that we’ve got a good buddy named Perić to contact maybe this will happen. I hope we’ll see you all in Pazin. At that point I will say hello to you in interviews. Until that time I really have no friends to say Hello to! hah.
- Propagandhi members launch ‘Escape Velocity’ podcast (punknews.org)
- New Releases Out This Week (punknews.org)