Tech
Postgres 8.4
Last year, you may remember me fussing with a new installation of Snow Leopard and trying to get Postgres to behave properly.
At my most current job I’m still stuck on Leopard and just began a project maintaining our installation of Redmine that requires PostgreSQL. We’re behind an iron-clad proxy server (which is a pain in itself) due to the nature of the company, but I was working from home that day and had the luxury of just disconnecting from the VPN and was able to use the one-click installer provided by EnterpriseDB which was a relatively painless procedure. I don’t remember it being so pleasant last year. I’m not sure if the one-click installer is new, I probably installed everything by source last time. In the hopes that within the next few months (I can only dream) I’ll get one of the new snazzy MacBook Pros they’re rolling out to the Online team, I can do it “properly” then and can afford to be lazy now.
I was quite impressed at the tools available in the installer that placed themselves in my /Applications directory by default such as pgAdmin III and a cute SQL Shell that automatically launches the psql command line tool. My only gripe with the one-click installer was that by default it installed postgres to the /Library/PostgreSQL/8.4 directory instead of /usr/local so previous postgres configurations in my extensive dotfiles were a little mucked up until I realized what I had done. Nothing a little bit of symlinking couldn’t fix, but it did drive me insane wondering why psql wasn’t in my $PATH.
Gmail Filters Suck
I hate Gmail’s filters.
I’ve been using Gmail for a number of years now, and the most irritating, hair-pulling experience is whenever I have to make changes to my filters. When I was in college, I used Pine in conjunction with Procmail and I was a happy little ducky for a long time. Then CCIS upgraded to Zimbra, and I thought, “Hey, I want to try that new stuff!” and got my email transitioned to the web client. Well, I couldn’t use my procmail settings anymore and while the filters weren’t as nicely set up and I had to deal with a lot more clicking than I wanted to, it was still fairly straight forward to get my mail directed to where I wanted it to go.
Now that I am graduated and have grown out of my college email address, the logical next step was to something like Gmail because hey, everyone™ uses that now, right?
Every time I have to make a change to one of my filters I have to take a deep breath and try my damnedest not to kill my screen in the process.
- You can’t logically order them. Every time you make a change, that filter goes to the top of the list. I have to do a text search to figure out which of my filters I need to edit.
- You can’t do an OR on two different types of fields. For instance, I’d like it to search for something in the subject or if the email is from a certain address. Impossible to do!
- You can’t do precedence. What is great about Procmail and even the mail filters in Zimbra, you can order filters to your heart’s content so you can check if it fits one filter and then nothing else is acted upon it. Gmail doesn’t have an indication to do this.
- Impossible to edit complicated filters. This is my filter to label things as “Shopping” so that they get shuffled off into a separate folder with a “Shopping” label instead of cluttering up my inbox.
Matches: from:(*@masterbeat.com |*@stores.gap.com | *@koss.messages1.com | *@e.victoriassecret.com | *@athletag.delivery.net | *@shop.sephora.com | *@piperlimeg.delivery.net | penews@perfumeemporium.com | *@giltgroupe.com | *@ideeli.com| thegoodguideteam@goodguide.com | BarnesandNobleEmail@email.bn.com | creativememories@nwlmail.com | *@trans-em.jetblue.com | email@photo.cvs.com | promo@e.newegg.com | *@es.shoebuy.com | *@es.bagsbuy.com | *@stewleonards.com | *@zipzoomfly.com | *@gapinc.delivery.net | *drugstore.com | cbnews7@cox.net | *gap.delivery.net | petperks@petsmart-mail.com | News@insideapple.apple.com | *@pragmaticbookshelf.com | *@e.staples.com | *@bedbathandbeyond.com | email@extracare.cvs.com) Do this: Apply label "Shopping"
That is impossible to edit in a couple hundred pixels input form field.
I’m sure there are other things about the filters that piss me off but those are the top four. In my opinion, Gmail really needs to step it up quite a bit and I’m disappointed there really hasn’t been any major changes since Gmail Beta. Gmail has the opportunity to have some really awesome filtering capability that integrates well with the label and folder system but it is just too frustration right now to be really useful!
Upgraded to WordPress 3.0
I upgraded all my blogs to WordPress 3.0 today. Gotta say it was pretty painless since DreamHost has those One-click installs, and you know how lazy software engineers get…
Git Handyism: Reflog
This just saved my butt.
Say you want to delete a branch:
% git branch -D s-588-test-list-of-urls
BUT THEN YOUR REALIZE YOU DELETED THE WRONG ONE. And you had commits that were local and were not pushed to the main repository, this piece of information is very helpful.
Do a:
% git reflog
And you’ll get something like:
fbfdcea HEAD@{0}: checkout: moving from master to s-588-test-list-of-urls
fbfdcea HEAD@{1}: checkout: moving from b-702-slideshow-play-button-jquery to ma
c87935e HEAD@{2}: checkout: moving from s-588-test-list-of-urls to b-702-slidesh
eaeb971 HEAD@{3}: commit: Writing some looping code to pull urls from sitemap.xm
fe2d942 HEAD@{4}: commit: adding backgroundrb
fbfdcea HEAD@{5}: checkout: moving from master to s-588-test-list-of-urls
fbfdcea HEAD@{6}: checkout: moving from b-702-slideshow-play-button-jquery to ma
c87935e HEAD@{7}: commit: Change how the text buttons are colored
1d233b8 HEAD@{8}: checkout: moving from master to b-702-slideshow-play-button-jq
fbfdcea HEAD@{9}: checkout: moving from b-702-slideshow-play-button-jquery to ma
1d233b8 HEAD@{10}: commit: Slideshows work again with jQuery
f101f15 HEAD@{11}: checkout: moving from 0.8.0 to b-702-slideshow-play-button-jq
87a1769 HEAD@{12}: checkout: moving from b-702-slideshow-play-button-jquery to 0
f101f15 HEAD@{13}: commit: Playing with javascripts and styles
Pick out which revision you last remember you did on your branch and then do this (with a new branch):
% git checkout -b s-588-test-list-of-urls-redo HEAD@{3}
And then checkout the correct repository again:
% git checkout s-588-test-list-of-urls
And do a merge!
% git merge s-588-test-list-of-urls-redo
And breathe a sigh of relief because you saved yourself a panic attack.
Why I Can’t Stress Enough the Benefits of Using a Password Manager
Last month, I saw this post on LifeHacker and like the lazy blogger I am, didn’t get around until now to comment on it. The short of it is that because some Twitter users used the same password for multiple sites, an unscrupulous individual was able to use those usernames/passwords collected from a fake BitTorrent web site and use them on Twitter to see if they worked. Unsurprisingly, many username/password combinations worked.
The full explanation from the Twitter Blog:
It appears that for a number of years, a person has been creating torrent sites that require a login and password as well as creating forums set up for torrent site usage and then selling these purportedly well-crafted sites and forums to other people innocently looking to start a download site of their very own. However, these sites came with a little extra – security exploits and backdoors throughout the system. This person then waited for the forums and sites to get popular and then used those exploits to get access to the username, email address, and password of every person who had signed up. Additional exploits to gain admin root on forums that weren’t created by this person also appear to have been utilized; in some instances, the exploit involved redirecting attempts to access the forums to another site that would request log-in information. This information was then used to attempt to gain access to third party sites like Twitter.
It’s absolutely critical that people use at least different passwords for each site they visit, especially if the credibility of the site is in question (i.e. if the site was for warez or even for torrents as in this example.) A better practice is to have strong, different password for each site. Sometimes this is hard because each site has a different “rule set” for their passwords. Some site may require at least 2 symbols and 1 capital letter or some variation and things can get complicated and confusing very quickly.
I’m sure you’re thinking, “but Rachel, how am I supposed to remember all those stupid passwords? I’m not a computer!”
And then I say, “no problem, bucko, that’s where password managers come in!”
In an earlier post this week I was detailing a bug I had with 1Password. Well, that’s a password manager!
What’s a password manager?
A password manager is an application or service that uses a master password to encrypt a database of username/password combinations for web sites, services or other applications. On a Mac, it’s like Apple’s keychain. You type in your password whenever you log in to your Mac and magically all the passwords you saved in that keychain are available to your applications so you don’t need to type them in all the time.
My favorite password manager is 1Password but practically all password managers have similar functionality. Password managers have multiple purposes but I think the best are:
- Ability to create a strong password for different sites. Most password managers have the function to generate a password for you so you don’t have to come up with a strong password on your own.
- Create a password and then never enter it in manually again. Plugins for web browsers like FireFox and Safari make it so easy to click a button, enter your master password, and bang! You’re logged in. You’ll never have to remember an obscure password again. Of course, if you’re no where near your password manager and need that obscure password to log on to a site while at a public computer you’re a little screwed unless you have your password database automatically set up to sync with a service like Dropbox (and then you’re all set!)
- A central, encrypted place for all your passwords. “Back in the day…” I remember I used to keep all my usernames/passwords on pieces of paper and up until recently my mother was keeping them on index cards on a rolodex. If you’re a sloppy pig and don’t know how to organize that stuff, you may end up misplacing that password and then you’re screwed. With
