Monthly Archives: June 2006

How to log SQL queries (again)

Same task as before, different database. I have been doing some development over the last few days with Rails and MySQL. To cut a long story short I wanted to have a look at what queries were being sent to the database. This post describes one way of turning on logging for MySQL. I did all of this on Mac OS X so your mileage may vary.

  1. Create the log file
    > su
    > cd /var/log
    > touch mysqld.log
    > chown mysql mysqld.log
  2. Edit /etc/my.cnf
    log = /var/log/mysqld.log
  3. Restart the database

If you installed the MySQL Startup Item then you can restart the server simply by running:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart

Job done!

Google Office

In a previous post I mentioned that after Google’s purchase of Writely all they needed now was a spreadsheet program and something for creating presentations before we see an online competitor to Microsoft’s desktop-bound Office product. Well here’s the spreadsheet. I’m off to the bookies to put a bet on the presentation software appearing in the not-so-distant future 🙂

Distributed columns

I have just finished reading an article about the limits of Google’s limitless business model. I got to the bottom of the first page and clicked on “Please continue reading part two”. Suddenly I was taken to a different site – there appeared to be continuity with what I had just read so I continued reading. Same thing as before: I got to the bottom of the page and clicked on “continue reading”. Bang! Different site again! At first I was confused but then at the bottom of the final page was this little snippet:

[This is an experimental publishing format, a distributed column across different web sites. The first part is here. The second part is here. The first part leads you through all three sections.]

Oh. The article really was distributed across several web sites! First of all, why? Could it be they did this so that by having different parts of the article on different websites the reader is exposed to advertisements from both sites?

My initial impression is that it doesn’t work; because it is an unfamiliar way of reading a multi-page article spread I wasn’t sure if I was actually reading the same article. The navigation is broken too. If I do a search on Google for example and I end up on page two of the article there is no way to get to page one from page two – this because there are only links to each part of the article on page one.

It will be interesting to see what other publishing formats these media companies come up with in the future. Then again, if they are anything like the distributed method I have just mentioned, maybe it won’t be that interesting after all.