Business Intelligence Network business intelligence resources

Blog: Pete Loshin

Main

November 13, 2007

Installing MySQL: A Tale of Two Platforms

Before I begin here, be warned: one of the links I'm pointing to here is NSFW. That means "NOT SAFE FOR WORK", and in this case it means that the page contains vulgar language and profantiy. If you're easily offended or are at work, you may want to go do something else now.

Here's the story:

On November 10, this article was posted: Installing MySQL on Mac OS X. A well-written, comprehensive, detailed and in-depth how-to article that anyone who wants to get MySQL going on OS X would be happy to stumble over.

The guy who wrote it, Dan Benjamin, seems a talented and very nice fellow, and he went to a great deal of trouble to put the article together.

I'm guessing that sometime shortly after that article got posted, Mark Pilgrim read it and decided that running MySQL on a Mac seemed like a lot work--much more than using it on Linux.

Then, Mark wrote his own "answer", contrasting, how-to Installing MySQL on Ubuntu (the NSFW way). This article is NSFW. But it's also hilarious as H-E-double-hockey-sticks, and it looks to be just as useful as the first article.

If you're worried about the foul language in the second article, I'll summarize: installing MySQL on OS X sounds like an incredibly complicated and scary adventure; installing it on an Ubuntu Linux box sounds like a walk in the park.

The funny thing is, we just got an iMac. And I just installed MySQL on an Ubuntu Linux system. I don't anticipate installing it on the iMac, so I'm enjoying this on multiple levels.

Posted by at 6:00 AM | | Comments (0)

November 5, 2007

Opening Up the Internet: Craigslist + Yahoo! Pipes = Better Data Searching

We've really come a long way with the web and the Internet over the past dozen years or so. Back then, it was kind of a big deal to run screen-scraping software that could pull data off websites, or access corporate legacy mainframe systems through a webified front end.

Now, we're seeing more and more of the web is instantiated in some seriously big data stores, and we're seeing more and more of the owners of those seriously big data stores making data processing tools and APIs available to anyone who wants them, so we can have some nice little mashup applications combining, for example, maps and data with geographical components.

But here's something sort of new: a way to make an already popular, useful and generally great website--in this case, Craigslist--with another popular, useful and great website--Yahoo! Pipes. The result is even better than either one.

Yahoo! Pipes is kind of like a web version of UNIX piping: a way to take the results of one command (output) and "pipe" it into another command as input. What you get is a very handy way to create very specific and powerful searches, and turn the results into useful information.

So, here's the article that got me hooked: How to Actually Search Craigslist. As great as Craigslist is, it has some drawbacks. James Aaron, who wrote the article, is a student at San Jose State's School of Library and Information Science, and is looking for a job currently. He likes Craigslist, but, as he explains, it could be even more helpful if there were ways to search better:

There is no way to truncate searches, such as "librar*" to include librarian, library, libraries, etc. There is no way to perform Boolean AND, OR, NOT searches. There is no way to remove frequently occuring irrelevant items. There is no way to search two sub-regions at once. So, unless I want to perform 20 searches a day and receive MANY completely irrelevant hits, I basically have to browse.

The answer, he tells us, is Yahoo! Pipes, and he explains just how to use Pipes with Craigslist to make Craigslist that much more useful.

In other words, more evidence of just how much the entire web is evolving into the world's biggest ever data store, with the most powerful ever set of tools for extracting business intelligence.

How could you use this kind of capability to extract actionable knowledge from the web?

Posted by at 9:00 AM | | Comments (0)

July 30, 2007

Instructional Eclipse/Java Videos

Curious about Eclipse? Then check out a series of tutorials called Eclipse And Java For Total Beginners, by Mark Dexter. Mark has put together 16 tutorial screencam videos that show just how easy it is to develop Java code using the Eclipse platform.

According to his introduction, Mark isn't an Eclipse or Java expert, just a guy with 30 years of solid development experience who discovered Eclipse and liked it--and decided to contribute this series of tutorials.

Posted by at 7:00 AM | | Comments (1)