http://drewjoh.com/blog Words on your display Sat, 02 May 2009 21:15:56 +0000 http://backend.userland.com/rss092 en I recently had to deal with a SQLite database that stored the timestamps as ticks.  Having to first research what a tick is, I created a simple function that will convert a tick value to a timestamp or MySQL datetime value since I couldn't find anyone else who had done ... http://drewjoh.com/blog/2009/05/converting-ticks-to-a-timestamp/ I recently had a small need to sign up two new Google Apps accounts and setup calendar sharing between them. So I naturally open up Safari as my second browser of choice and go to the sign-up page, only to notice that rather than the standard 7.2GB of space, I ... http://drewjoh.com/blog/2008/11/google-apps-only-gives-2gb-to-safari-users/ Just spent almost the entire day trying to figure out what I was doing wrong when trying out many different flash multi-file uploading widgets. All of them would give me a 302 redirect http error, even when testing locally. So after much searching and reading and studying... and finally testing this ... http://drewjoh.com/blog/2008/09/bug-with-adobe-flash-on-mac-when-uploading-files-to-a-redirected-url/ I was recently playing with mod_rewrite and wanting a couple of subdomains to act as subdomains, but all others to redirect back to my site without the leading "www". For example: www.example.com => example.com bad.example.com => example.com api.example.com => api.example.com Not being a regular expression or mod_rewrite expert (or any resemblance of such), this ... http://drewjoh.com/blog/2008/09/redirect-all-but-used-subdomains-to-primary-domain-using-mod_rewrite-and-codeigniter/ Ran into a little problem hitting the memory limit for PHP when serving 100MB+ files through a script like: $file = @fopen($filename,"r"); if ($file) { while(!feof($file)) {     print(fread($file, 1024*4));     ... http://drewjoh.com/blog/2008/09/serving-a-large-file-through-php-without-hitting-memory_limit/ If you're one of the lucky ones to be able to get one of the latest MacBooks with Multi-Touch, you've probably asked the same question I have: "How can I get Firefox to use the swipe gesture to go forwards and backwards like Safari does?" Answer: MultiClutch This neat little Preference Pane ... http://drewjoh.com/blog/2008/04/multitouch-trackpad-gestures-for-the-rest-of-your-apps/ When buying portable products, I usually like to be (over) prepared for whatever situation may arrive.  When I bought my Panasonic HD camcorder, I also searched the web thoroughly and bought two extra batteries and a 16GB SD Card.  Plenty of power and plenty of space. So I found myself looking ... http://drewjoh.com/blog/2008/04/cycle-your-batteries/ Upon getting my Mac, Spaces was one of the first things I checked out. I had tried Virtual Desktops in Windows and Linux, but never found them to be too terribly helpful. Not to mention I used a dual monitor setup with my Windows machine, so I felt I had ... http://drewjoh.com/blog/2008/03/getting-organized-with-spaces/ I've been a Mac user now for 24 days; and I'm loving it. I've been anxious to write several blog posts about the highlights of my experience in switching to a Mac + PC workstation. I have several stickies on my desktop with notes about what to include in these ... http://drewjoh.com/blog/2007/12/my-mac-crashed-on-me-and-i-lived-to-tell-about-it/