Have you ever wanted to fire off a post from your phone, Blackberry, Outlook at work…? Following on from Comment Reply Via Email we’re introducing our latest feature to make it even easier to publish to your blog: Post by Email.

Maybe you’re on holiday and want to show your journey. Maybe you’ve captured something with your cell phone that you just have to share. Maybe you’re at work and should be doing something else. With Post by Email you can keep everyone up-to-date without even opening a browser.

Post by Email is super simple to use. From the new My Blogs menu you can generate special email addresses:

You can create as many email addresses as you need, one for each blog you have access to.

Now for the fun part – send an email!

You can send email …

While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video.

You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL/Sun’s) new founders, Wordpress is MySQL today, and for the foreseeable future. Anyway, I digress.

Wordpress.com has about 70 million tables, and tens of thousands of blogs. Large amount of tables, serve for easy sharding - …

I have a Google Alert on “percona”. (And many other things — great way to keep tabs on competitors, what people are saying about you, etc.)

I’ve been seeing increasing amounts of this type of thing:

MySQL server version: 5.0.67-percona-3 CATEGORY QUERY: SELECT wp_term_taxonomy.count as ‘count’, wp_terms.term_id, wp_terms.name, wp_terms.slug, wp_term_taxonomy.parent, wp_term_taxonomy.description FROM wp_terms, wp_term_taxonomy WHERE …

Go to the page in question (sorry, I won’t link it) and you don’t see “percona” anywhere on it. View the source and you do. It’s WordPress debugging output.

I’m glad to see the anecdotal evidence of more and more active use of the Percona server builds, but at the same time, it’s kind of like finding out that your best friend made it onto the Jerry Springer Show. Sometimes I think …

Yesterday, I started my sporadic series of blog posts where I share my experiences improving my online manners through social networking websites, many of which are powered by MySQL. My first target was the traveller site Dopplr, and this time, it’s Google’s picture sharing site Picasa Web.

My starting point is the same: “Everyone else” among colleagues and friends was there long before me, and I feel like a latecomer. I want to go in, do what seems to be the right thing, and share the observations I had. And everything within the time constraint of not being able to do a full evaluation, as I obviously have other things to do as well.

Unlike Dopplr, starting with Picasa Web never required invitations. My first exposure to Picasa was through …

This is part knowledge share, part appeal: fellow bloggers, I’d comment a lot more on your blogs (and I want to!) if I could. Please, make it easy for me to comment — don’t make me log in (I won’t do it) or moderate me. I’ve found a solution that works really well [...]

Because of some weird bug my RSS feeds were broken ever since I’ve upgraded to WP 2.5. Today they were fixed and I hope they’ll have some new posts there soon Stay tuned.

Do you use mod_auth_mysql, the Apache module that allows authentication of users to happen through a MySQL database?

If so, the nice folk at Automattic (makers of fine blogging software like Wordpress) have released a patched version that works with phpass.

With this, you can now have single sign on (SSO), with authentication against a WordPress blog (or bbPress forum). Note that WordPress (in 2.5 and later), doesn’t use MD5 hashes to store passwords any longer; instead they are salted and hashed with the phpass library. The Automattic folk use this to provide SSO for Trac and Subversion.

Read …

Did you notice that I moved this blog from pair Networks to pairLite hosting?

Probably not, unless you check the DNS of xaprb.com regularly!

Don’t you hate it when people say “I’m moving my blog, I hope there won’t be more than a few days of downtime, blah blah…” Why is this ever necessary, I wonder? I wonder the same thing about a lot of hosting providers — recently I had a client in my consulting practice whose (very large, well-known) hosting provider tried to help them with some very simple MySQL work and ended up causing them an obscene amount of downtime, like many many days, and there was no end in sight. As I spoke on the phone with him and asked him about his business, he said “we have X thousand users in our beta.” long pause. “Well, we did …

Update: I’ve been suffering some ungly and stupid bugs today, so I’ve fixed them and released version 0.2. It also includes a new script wp-update-home.

I’ve just published some scripts that help me manage my personal wordpress installations, and publish some plugins I’m working on.

Warning: these are early versions which I use for small tasks. If you find
a bug or have suggestions, contact me at jbernal@warp.es

Download version 0.1 …

My wife has a site that needs two WordPress blog installations. The URLs differ by a subdirectory name. Both blogs need to be (URL-wise) subdirectories of /blog/. They need to be completely independent of each other, yet use the same custom theme. And there used to be just a single blog, which was not in a subdirectory; its permalinks must not break. (It has nice URLs with the date and title in them, not post ID-style URLs). And because I’m the husband, I get to maintain it, so tack “easy to maintain” onto the requirements (it must be easy to upgrade WP in both blogs, for example). In this article I’ll show you how I did it with a single .htaccess file, a single copy of WordPress, two MySQL databases, and a single configuration file.

Fixing URLs

As I mentioned, there used to be a blog at /blog/ which must not break. Suppose this blog was about dogs and my wife has recently started blogging about cats. She wants two …