photo: nothing to see here
MySQL has some powerful, and perhaps underused spatial extensions, but the most interesting functions are still unimplemented: “Note: Currently, MySQL does not implement these functions…”
Among those as-yet unimplemented functions is DISTANCE(). Alternatives can be found here and here, though neither is clean or simple. I wonder if a simple MBRContains() is good enough, though…
Will it be a thinner or fatter iPhone? Will it record live video? Will it have a metal cutting laser?
To heck with the iPhone rumors. We know the story, all we’re waiting on are the details. I’m more interested in what we don’t know. What aren’t we expecting? Will there be “one more thing”?
(thanks to [...]
Found in the MySQL 5.0 Reference Manual:
Related(g1,g2,pattern_matrix)
Returns 1 or 0 to indicate whether the spatial relationship specified by pattern_matrix exists between g1 and g2. Returns –1 if the arguments are NULL. The pattern matrix is a string. Its specification will be noted here if this function is implemented.
(emphasis mine.)
I have a lot of WordPress sites I manage and I’ve been thinking about converting them to WordPress MU sites to consolidate management. Today I attempted the first one, about.Scriblio.net. There’s no proper way of doing it that I found, but here’s what I did:
Create a new site in MU
Create the users in the correct [...]
I’ve had a lot of features on the table for bSuite for a while, but this recently discovered comment from John Pratt (whose Smorgasboard.net is a lot of fun), kicked me into gear to actually get working on it again. The result is bSuite 4, which is probably what bSuite 3 should have been all [...]
Stuck with PHP 5.1.6 on RHEL or even CentOS (and a sysadmin who insists on using packages)? Need JSON? I did. The solution is easy:
yum install php-devel
pecl install json
The pecl install failed when it hit an 8MB memory limit, and I was clueless about how to fix it until I learned that the pecl installer [...]
WordPress was released to the world five years ago today. Celebrate in SFO, Sydney, or with me at whatever bar I find myself at in New Hampshire tonight. DM me with any ideas.
“Gun control is like trying to reduce drunk driving by making it tougher for sober people to own cars.” via
WordPress 2.5.1 added a really powerful feature to register_taxonomy(): automatic registration of permalinks and query vars to match the taxonomy. Well, theoretically it added that feature. It wasn’t working in practice. After some searching yesterday and today, I finally found the bug and worked up a fix. I made a diff and set off to [...]
Clay Shirky recently posted a transcript of his Web 2.0 Expo keynote.
…If you take Wikipedia as a kind of unit, all of Wikipedia, the whole project — every page, every edit, every talk page, every line of code, in every language that Wikipedia exists in — that represents something like the cumulation of 100 [...]
I was amused to learn Nathan was officially at ROFLcon on behalf of his library. I wasn’t representing my work and wasn’t on the lookout for work-related tools, but I found some anyway.
Universities have been anxious to get into live video casting for a while. Our first effort eventually became PBS (NET, ETS and PBS [...]
Anglia Ruskin University is in Cambridge, but it’s not Cambridge University. It’s likely that none of us would even know of Anglia Ruskin’s existence if it wasn’t for Naomi Sugai, but she’s not interested in promoting the school.
She’s got complaints, she’s fed up, and she’s taking her case to YouTube.
Well, she took her case to [...]
Last weekend, while I was putting an iPod interface into my Scion I did the same thing for my 2002 Honda Civic. Using Ben Johnson’s story as a guide, I bought a PIE HON98-AUX interface and dove in.
Aside from tools (screwdrivers and 8 and 10mm sockets), you’ll need:
The interface adapter
Audio wiring — I used a [...]
It was only after I’d taken my seat and David Weinberger began his ROFLcon keynote that I realized there was a box of t-shirts at the side of the room with a sign over them that said something along the lines of “FREE: t-shirts from worn out memes.” Thinking that the internet might be old [...]
Sure you played Asteroids and Defender, but did you play these?
