WP-Create

My WP-Mass-Upgrade script has saved me countless hours over the past year. Making sure all Birdhouse and J-School WordPress installations are managed via subversion has meant I’ve been able to wrap them all in a single shell script. When new releases emerge, I’m able to upgrade 50+ installs in a few minutes. The most time consuming part remaining was creating new installations when customers needed them. I had the process down to around five minutes, but knew the repetitive steps could be distilled into a script, so recently wrote WP-Create:

Super fast (~30 second) way to install WordPress for clients, via subversion. Yes, users can often self-install via Fantastico or similar programs, but what guarantee do you have that they’ll upgrade as soon as new releases become available? Letting users run old versions of web software is a great way to get hacked. Take control of users’ installations by checking them out via svn (with this script) and managing them with wp-mass-upgrade.

This script performs the following tasks:

  • Gather installation info
  • Create install dir and check out a copy of WordPress
  • Create database, db user, set db privs via external .sql file
  • Create WP config file
  • Create upload dir and set filesystem permissions
  • Generate array line for wp-mass-upgrade.sh

Final setup is done via browser.

Added these tools to the WordPress codex section on managing WordPress via subversion.

Music: The Staple Singers :: For What It’s Worth

Scripts and Utils

Over time, I’ve built up a handful of shell and PHP scripts, written to satisfy various itches with WordPress, Movable Type, QuickTime Streaming Server, hosting performance, etc. I’ve been tossing them into a dorky static site in case they prove useful to anyone else.

I’ve been meaning for a while to drop them into a WordPress installation – a little software library, open for discussion. Finally got around to doing that: scot hacker’s scripts and utils. Not much different from the old site, but now includes commenting, categories, search, RSS, etc. Using the badly named but very clean WP-Candy theme.

One of these days I’ll have to dig up all my old BeOS scripts and utils and give them a permanent home.

Music: Essential Logic :: World Friction

Windows Is ‘Collapsing’

A few days ago, I had the, um, pleasure of having to install some lock-programming software on a Windows laptop — a process that should have taken five minutes but instead took upwards of an hour. Endless DLL conflicts, an uninstallation fiasco, an installer caught in a circular loop, literally hundreds of entries being written to the registry… The whole farce would have been hilarious if it hadn’t wasted so much of my time. I run Windows so seldom these days, I forget how bad it can be.

Sounding a lot like the BeOS founders and evangelists from a decade ago, who used to talk about Windows being held together with bailing wire, chewing gum and twine, a pair of Gartner analysts recently came out and said it: Windows is ‘collapsing’ (Computerworld):

Calling the situation “untenable” and describing Windows as “collapsing,” a pair of Gartner analysts yesterday said Microsoft Corp. must make radical changes to its operating system or risk becoming a has-been … Analysts said Microsoft has not responded to the market, is overburdened by nearly two decades of legacy code and decisions, and faces serious competition on a whole host of fronts that will make Windows moot unless the software developer acts. “For Microsoft, its ecosystem and its customers, the situation is untenable,” said Silver and MacDonald in their prepared presentation, titled “Windows Is Collapsing: How What Comes Next Will Improve.” Among Microsoft’s problems, the pair said, is Windows’ rapidly-expanding code base, which makes it virtually impossible to quickly craft a new version with meaningful changes. That was proved by Vista, they said, when Microsoft — frustrated by lack of progress during the five-year development effort on the new operating — hit the “reset” button and dropped back to the more stable code of Windows Server 2003 as the foundation of Vista … “Windows as we know it must be replaced,” they said in their presentation.

It’s one thing for the userbase to talk like this, but analysts like Gartner are serious about what they do, and don’t make heavy-handed proclamations lightly. Something is in the wind, and it smells like carrion. You can only put so much lipstick on a pig.

Music: Ivan Boogaloo Joe Jones :: You’ve Got It Bad, Girl

BeOS Journal Lives

I’ve fallen out of like with the web’s usual April Fool’s day shenanigans (on account of being an old humorless curmudgeon), but this one hits joyously close to home.

Toward the end of the BeOS era, I was working with the publishers of the Linux Journal to create a sister publication, the BeOS Journal (this is true – not making this up). I was the senior editor, and had commissioned and packaged all of the content. We had the first issue in the bag and had already gone to layout when Be made the formal announcement that it was folding their cards. Of course, the BeOS Journal went down along with it, and issue #1 never saw the light of day.

But today is a great day. Seven years later, the publishers of Linux Journal have finally come to their senses, and have decided to drop Linux coverage in favor of full-time BeOS content. The introductory video speaks for itself.

The day we’ve anticipated for so long has finally arrived. I’m thrilled to see the technology world finally sitting up and taking notice of the greatest OS ever developed. Though I unfortunately can no longer promise to be a substantial contributor to the project, I’ll be reading BeOS Journal regularly and cheering from the sidelines. Hup hup!

Also excellent today: ThinkGeek is running a special on the Super Pii Pii Brothers video game for Wii controllers (see video). Now that’s compelling game content!

Thanks Bret Chou.

SQLite Rules

Quick, what’s the most widely deployed database in the world? MySQL? Oracle? Nope, it’s that puny squirt SQLite – the one you see listed as an option every time you set up a new Rails or Django site. SQLite is not a database server, but a SQL-compatible interface to a single file — perfect for every application that needs a full relational database without the overhead and complexity of a client/server connection. In other words, it’s in your smartphone. It’s on your Mac (driving the indexes in Mail.app, plus the databases behind Aperture and Safari). It’s in Adobe AIR. It’s in FireFox. It’s in Android. It’s in a bunch of giant products and services that will never admit to it.

SQLite is fast. Hella fast. Not great with massive concurrency or transactions, but runs circles around its more popular big brothers in simple SELECT/INSERT statements in moderate-traffic environments. Apparently it can be used to run production web applications if you don’t transactions or permissions (“If your site is small enough to run on a single server, it’ll rock on SQLite.”)

Excellent interview with SQLite’s creator Richard Hipp in this week’s FLOSS. Incredibly humble guy. Talks like his accomplishments ain’t no big thing. But his software changed the world. And instead of making a million bucks off it, he took his name out of the source code and released it into the public domain. Now he makes his living doing customizations for giant corps. Altruism can be good business.

Music: The Who :: Sunrise

Scalable Web Ventures

Loose notes from SXSW 2008 panel Scalable Web Ventures, with:

Chris Lea Media Temple
Joe Stump Lead Architect, Digg.com Inc
Cal Henderson Badass MC, Flickr
Matt Mullenweg Founding Dev, Automattic/WordPress
Kevin Rose Founder, Diggnation/Digg Inc

This session was about much more than load balancing – scaling orgs in all directions (personnel, technique, communication), but was focused on technical scaling techniques. Amazing to see how some of the internet’s most popular properties have faced the problem in completely different ways, and how all of them basically learned by doing. You can throw, money, software, hardware, or brains at the problem, in various combinations… and these orgs have tried everything. Juicy stuff.
Continue reading “Scalable Web Ventures”

CMS Roundup

Loose notes from SXSW 2008 panel Content Management System Roundup, with:

George DeMet Owner, Palantir.net
Jeff Eaton Lullabot
Tiffany Farriss Pres, Palantir.net
Mike Essl Owner Operator, mike.essl.com
Matthew McDermott Principal Consultant, Catapult Systems

The perennial question on every web dev mailing list: What CMS should I choose? Expression Engine made a huge splash at this year’s SXSW, but the Drupalites were out in force as well. This panel basically boiled down to MS Sharepoint (missed this, but not interested), EE, Drupal, and observations on a smattering of other systems. In a software category that offers around 600 choices, it’s impossible ever to represent the whole picture with anything approaching accuracy, but the conversation was still useful.

Continue reading “CMS Roundup”

Building Portable Social Networks

Loose notes from SXSW 2008 session Building Portable Social Networks with:

Jeremy Keith Clearleft Ltd
Chris Messina CEO, Citizen Agency
Leslie Chicoine Experience Designer, Get Satisfaction
Joseph Smarr Chief Platform Architect, Plaxo Inc
David Recordon Open Platforms Tech Lead, Six Apart Ltd

This topic has been fresh on our minds at the Berkeley J-School in our work providing guidance to news publications who are trying to focus more on community, and wondering whether to just tap into Facebook, use Ning, or create their own. The public is rapidly approaching SN overload. Are people really willing to create yet another SN profile? Will they able to re-engage their existing networks of friends? What about all of the data they’ve already stored in their existing SNs? Will BuddyPress help? OpenSocial? SocialThing? What are the technical and privacy issues we’re facing here? Is this problem solvable, or are we erecting a tower of babel?

Continue reading “Building Portable Social Networks”

Adobe Air

Loose notes from SXSW 2008 panel on Adobe Air, Taking it to the Desktop.

In October 2006, I attended an Adobe focus group for what was then code-named Apollo, which promised to let us easily create desktop software out of HTML + JavaScript + Flash web apps. Fascinating technology, but I had a hard time wrapping my mind around its potential. With software in general moving towards the web, who out there wants to move things the other direction? I thought the biggest market would be on cell phones. Now, 18 months later, Apollo has become AIR and the software has become more polished. But the strategy is still the same, and I’m still at a loss to come up with a compelling business case for the product.

Anyway, this session helped put a few more of the pieces together mentally. Still not convinced it’s going to become a big hit though.

Continue reading “Adobe Air”

Scalability Boot Camp

Loose notes from SXSW 2008 session “Scalability Boot Camp” with:

Blaine Cook Architect, Twitter Inc
Jakob Heuser Architect, Gaia Interactive
Alan Kasindorf MySQL DBA, SixApart
Sandy Jen Co-founder, Meebo
Kerry Miller Writer, passiveaggressivenotes.com

Good tips from diverse perspectives. Everyone on the panel admitted to having made huge scaling mistakes in the past, and to having learned critical lessons from real-world usage patterns.

Continue reading “Scalability Boot Camp”