08.01.06

Bots

Posted in Uncategorized, Microsoft at 9:17 am by gloomy

According to Yahoo! blog they have their new bot (Yahoo! Slurp) version in action that will reduce the number of requests and bandwidth consuption to crawled sites.

Almost at the same time MSN renamed few its bots (they all were named the same before) to help better distinguish them apart. So from now:
The MSN Shopping bot - msnbot-products
The MSN News bot - msnbot-news
The MSN Search bot - msnbot
The MSN Image Search bot - msnbot-media

This will help you better understand what is MSN doing on your site ;)

07.09.06

3D rendering with PHP

Posted in PHP at 1:39 pm by gloomy

Some guy wrote simple 3D rendering PHP script. It is based on well known game called Wolfenstein 3D “raycaster” algorythm and is pretty simple. Funny is that you can combine that with AJAX to get some unseen results (let’s not think about server load and traffic yet).

06.28.06

CodePlex.com by Microsoft

Posted in Microsoft at 8:51 pm by gloomy

Well, Microsoft has stepped even further into open source. Some time ago they have opened an open source community portal - codeplex.com - a nice place for those who are developing open source projects based on microsoft technology and for those who have interest in such projects. So grab a free copy of Visual studio Express 2005 and go coding. I have been using Visual Studio Express 2005 for a while and find codeplex combined with msdn quite useful.

06.14.06

Desired percentage of rows?

Posted in MySQL at 10:41 pm by gloomy

How to make MySQL return a desired percentage of rows?

Some people time after time ask this question. Most of
them are migrating from MsSQL (Microsoft SQL Server 2xxx) that
has the ability to retrieve a desired percentage of rows. For example:

SELECT TOP 50 PERCENT * FROM table

This query will return 50% of rows. Nice. What do you do
in MySQL if you get a task “to return half of the records from a table”?
So far i found just one easy solution for MySQL 5.0.7+ version:

SELECT @percentage := ROUND(COUNT(*) * 50/100) FROM table;
PREPARE STMT FROM 'SELECT * FROM table LIMIT ?';
EXECUTE STMT USING @percentage;

Any thoughts?

05.23.06

Hello blogworld!

Posted in Uncategorized at 9:53 pm by gloomy

So, here goes another blog.

I hope this will be the place where I will be able to post anything I find worth to. Time will show if this was a good idea.

I plan stick around with various topics: webdevelopment, webmastering, internet marketing, lifestyles, culture, politics, religion, etc.

Don’t beat me.

· Next entries »