Archive for November, 2008

Safari 3.2’s Anti-Phishing

Friday, November 28th, 2008

MacWorld deconstructs the anti-phishing features in Safari 3.2.

Bottom line for security & web developers: It’s Google’s database, they’ve been doing this for 3 years, only hashes go over the network, locally cached. It’s good stuff.

Bottom line for privacy-interested people: If you hit a suspicious hash prefix, you ask Google’s servers for the full hash. In theory this is enough for Google to do some analytics. Certainly it doesn’t directly reveal what URLs you are really visiting. Apple’s privacy policy does not discuss any sending of data to anyone but the site you visit (i.e. it is mute on this sort of feature). It further does not bind Google from misuse of anything they could collect. Mozilla’s privacy policy covers these bases.

Bottom line for anyone who has better things to worry about: It’s fine, leave the checkbox on, and if it ever warns you that you may be visiting a malicious website, stop and listen to it. You are probably not where you intend to be. Scott can explain.

Dumb Things are Happening with Comments

Sunday, November 23rd, 2008

I get a lot of spam comments on the blog here. You don’t see them, because I mark them as spam, a few hundred every week. They’re roughly uniformly distributed across all my posts. If fewer posts are open, I get fewer comments. So I want to minimize the number of comments I have to deal with.

I’m trying to use Mark Kenny’s Extended Comment Options plugin to automatically close comments on old posts. I used this plugin a long time ago, and it was great. But now, in WP 2.6, it seems to do exactly the inverse of what it says on the box: it closes my most recent posts and opens the oldest ones.

I don’t understand. Isn’t this just
UPDATE `wp_posts` SET `comment_status` = 'closed' WHERE `ID` IN (SELECT `ID` FROM `wp_posts` WHERE `post_status` = 'publish' AND `post_type` = 'post' ORDER BY `post_date_gmt` DESC) LIMIT 0,10

(Okay, it’s not quite that simple, because MySQL doesn’t do ORDER BY or LIMIT in subqueries… But it’s close! Temporary table?)

Has anybody got a good solution to this, better than a cron job to run that query?

Meanwhile, apologies to everyone who wanted to comment but couldn’t.

Google is the New Bartlett’s

Thursday, November 13th, 2008

I wasn’t sure of the exact phrasing of Einstein’s old chestnut about difficulty in mathematics. So I googled it. I haven’t found a really authoritative source, but there are definitely plenty of variations. So I picked one that sounded right.

As far as I can tell, it’s not even in Bartlett’s, which is a bit troubling. In fact, I can’t find any reputable source or citation. Is this an apocryphal quote?

Joshua Tree

Thursday, November 13th, 2008

Another personal post. Last weekend (8-10 Nov) I went with UCSD’s Outback Adventures to Joshua Tree National Park for a weekend of rock climbing. Joshua Tree is a world-renowned destination for climbers, and it’s easy to see why: the northwestern part of the park seems to be composed solely of steep and interestingly-textured rock faces to climb up and beautiful vistas of the high desert to look out upon.

Joshua Tree vista Joshua Tree vista 2 Joshua Tree vista 3

The Outback Adventures folks were experienced, taught us what we needed to know, encouraged us to do our best, and generally had their stuff together. I would strongly recommend any of their outings based on my experience.

I’m still very new to climbing. This quarter I started going to the climbing gym on campus once a week with a friend, and a month ago I went on a day trip with OA to Mission Trails park and climbed on actual rock. This weekend was the test for me: is climbing something I’ll keep on doing once a week at a gym, as a form of exercise I enjoy much more than lifting weights? Or is this a serious hobby I’ll put time and effort into? The answer is clear to me after this weekend: I really like climbing, and I want to do it as often as possible. To that end I’ve purchased a harness and shoes (thanks Craigslist!) and I’ll try to go to the gym twice a week.

The next step is to find a climbing partner who has the equipment and experience to set up top ropes on actual rock. It seems to me the rope and protection gear would cost $300-500 (new list price), and that’s an investment I’m not ready to commit just yet. I wouldn’t know how to use it either. So I have to find someone willing to set up climbs and teach me how to use the gear. To show me the ropes, if you will. Sorry.

On a more introspective note, I’m still amused by my newfound enjoyment of The Great Outdoors. My family was never the outdoorsy type, and we never went camping or hiking or anything like that. Until this summer I’d never been camping at all. But so far, I’ve been enjoying it a lot. Was I always an outdoorsy person, but I never knew? On the other hand, it’s possible that I’m developing a taste for camping simply because I’m experiencing it at this time of my life, going with these people, doing these things. Were I occasionally dragged on yet another family camping trip all throughout my childhood, would I have a different opinion? Nature versus nurture: am I a person who likes camping and hiking but never discovered it until now, or do I like camping and hiking because of the ways I’m experiencing it now? It’s unknowable, of course.

A Political Post

Wednesday, November 5th, 2008

Dear California:

I’m ashamed to tears to live in this state. Yesterday, 4.8 million of my neighbors voted against civil rights and equal protection. Proposition 8 was never about homosexuality, or religion, or the traditional marriage ceremony: it was about government adjudication of who can engage in domestic partnership, and the answer of the people is: “Not everyone”. The beliefs of a few about things that don’t affect them have now been turned into laws trampling on the rights of many. Congratulations, California, you just passed a miscegenation law.

To everyone who thinks this is a religious issue, to all Christians who voted yes on Proposition 8 because you interpret Leviticus 18:22 as declaring homosexuality a sin and calling you to take positive action to prevent same-sex couples from being happy in such sin, may I draw your attention to the New Testament: Luke 6:36-37, Colossians 3:13, 2 Corinthians 3:6, Galatians 5:14-15, and Galatians 3:19-28 for starters. You can think homosexuality is a sin, if you want to ignore the new covenant, follow all the laws of Leviticus, and declare putting meat and dairy on the same plate a sin as well, and miss the entire point of Christianity. But even if you do that, don’t you dare condemn other people for what you call a sin. Next time, try listening to what good old JC actually said before you try to do something in his name. Hint: it’s about forgiveness and love, not about legalism.

To all of you Yes on 8 campaigners who claimed this was about protecting the marriage of straight couples from some sort of degradation of society, or about what our children would be taught in schools, or that kids need both a mother and a father or they’ll grow up to be criminals and/or homosexuals, or especially anybody holding one of those signs that said “Prop 8 = less government”, come see me sometime, and I’ll send you to whatever hell you wish. You lied through your teeth to convince otherwise reasonable but tragically uninformed people that Prop 8 was something it wasn’t. I’ve been trying to keep my feelings today mostly in disappointment and not hate: but I really really really don’t like you.

My hopes and whatever feeble prayers I dare offer are with the ACLU, Lambda Legal, and the National Center of Lesbian Rights, who are currently challenging the constitutionality of Prop 8 in the California Supreme Court; and that the Court will do the right thing and protect the rights of all people.

I should be happy with the outcome of the Presidential election. The candidate I supported won, and I think the country sent a message that we’re not happy with the way things have gone. The power of the people is passing to a younger generation and we’re going to make some changes. I should be happy, but today I just can’t be. More than anything else, I’m shocked that this happened here. This is the West Coast, the land of hippies and greenies and crazies of all sorts. If this is what 47.9% of Californians believe, what does that say about the rest of the country? How can the same country elect Barack Obama and ban gay marriage? I just don’t understand.

All right. Back to infrequent natterings about technology.

P.S. Hey, Santa Clara county, where do you think you’re going? You come right back here. Santa Clara County, you screwed up big. 33.7% of you voted against BART. What the hell?! Who voted against BART? You’d better hope there are 5,000 more uncounted absentee votes for Measure B hiding somewhere. If B finally fails when every vote is in, I will find all of you and I will beat your ass back into the real world where we need BART in the South Bay so bad it hurts.

Full disclosure on my political & religious positions: I’m an atheist who sees a lot of value in the best teachings of Christianity and all religions; the teachings that nobody can always follow because it’s actually difficult to be a good person. I have strong respect for civil liberties and the rights of individuals. I’m a bit left on welfare issues. On the other hand, I don’t trust the free market as we know it today. I’d love to, but it proves itself time and again to be a terrible servant of the public good.