First of all I have to give the guys from woopra two thumbs up.
I use webanalytics software for some years now. I worked with Indextools and like nearly everyone with Google Analytics.
As Indextools has been sold to Yahoo, Yahoo decided to change the business model of Indextools.
Indextools was not free of charge and hugh application for small sites. So Indextools is more a enterprise tracking system.
Google Analytics is free of charge. On big problem for commercial sites is that the collected data is owned by Google and the “terms and conditions” can be change quickly to use these data for their own needs.
Okay back to the main topic. A friend of mine told me about Woopra and I decided to sign up for the beta test. Woopra is free of charge right now. After the signup you’ll have to wait until the guys from Woopra decided to give you access. In my case, this took two weeks.
After you’re enabled for Woopra, you have to install a javascript in your website.
The cool thing behind Woopra is the Java application you can download from their page. Sadly you’ll need java 1.6 which kicks out nearly all the Mac OS X guys, because Java 1.6 is only availible to 64bit users, which means only Mac Pro users are supported.
After installing the java application you have a wonderful, flash look-like, interface.
The best thing, you can see your users in real time. You can see, which site they are looking at, how long they have been there, where they came from (website and city/country) and a lot more.
The killer feature here is that woopra enables you to chat to current visitors on your website.
You can choose a user, click on “talk to this user” and get a chat window to talk to them.
At the end, Woopra is nice for small sites and blogs. I guess big business sites will not get the data they need and should use things like Indextools.
Btw. I think Woopra ROCKS!
I’m working on a project with a huge MySQL database and for that reason, I was looking out for some mysql performance tips.
One information I found in nearly every blog was using the slow_query function from mysql.
Put that in your my.cnf:
log-slow-queries=/tmp/slow_queries.log
long_query_time=10
After that you will see all querys that take longer than 10 sec. in the /tmp/slow_queries.log.
To see what you can optimize at this point, you can use EXPLAIN.
So that’s something you find everywhere. Something else you can see everywhere is to activate the query cache. If you are using mysql 5 > this should be enabled by default.
But there are these simple and little optimization points you should use everyday to bring you database on the speedway.
- Use only the datatypes you really need. Numbers should be saved as int. And text should be saved in the right type.
- If you’re working with numbers always use only the number no quotes around it.
select * from bla where id = 123. Otherwise the server will have to cast the number and will work with a string.
- Don’t use rand()
Beat me! This is a funny geek game. So, let’s show me your highscore.
43
As I blogged before, I worked with Grails in the past. One thing I didn’t like was the renaming of functions every version. Hopefully this is over now. Today Codehouse released Grails 1.0.
Further informations: Grails website
I nearly got crazy about that sh*t.
The goal was to bring up a tracking pixel to see the movement of single users. For that reason, you’ll need to set a cookie and read it on the page. In my case, the tracking pixel comes from another machine, than the website.
After I generating the p3p file with the ibm p3p generator, I checked and validated that stuff.
Normally that should work right now. It does in Firefox! But it doesn’t in Internet Explorer. After searching around, I found out, that I can also set the P3P stuff via the header, but that’s not all. You’ll have to send it on the site where you set the cookie and even on the page, you receive the cookie.
This is my header:
header ('P3P:CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"');
Good luck!
YES, exactly that! And yes, I’m using wordpress.
The reason, why I say that wordpress sucks is, that everytime I use the wysiwyg editor to post something and then want to change it, it breaks the whole design.
In the past I had to customize a lot of wordpress installations for customers and everyone who ever saw wordpress code, knows what I’m talking about. How about you?
I started playing with the Google AdWords API.
Before you begin the play with the API, you should enable the sandbox mode in the settings.ini File.
After that, you will have to connect with a valid Google user and put that code in your request.
print_r(getManagersClientAccounts());
That returns a bunch of client email addresses you can use to connect to the sandbox.
Now it’s time for developing…
