Thursday, August 16, 2007

Web Traffic Comparison

Web Traffic Comparison

http://www.alexa.com/
http://www.compete.com/
http://www.ranking.com/
http://www.feedburner.com/fb/a/home
http://www.quantcast.com/

http://www.antezeta.com/web-analytics/web-statistics-suppliers.html#WS18

Ad & Affliate Networks
http://www.cpxinteractive.com/sign_up.php
http://www.casalemedia.com/
http://www.adtegrity.com/
http://www.oridian.com/
http://www.text-link-ads.com/
http://www.cpxinteractive.com
http://www.tradedoubler.com
http://www.cj.com
http://www.webgains.com/

Interesting Tools
http://synergy2.sourceforge.net/about.html
http://www.mattcutts.com/blog/page/3/

Wednesday, August 01, 2007

I insert data in to multiple tables in MySql

I saw this question on Techjamaica forum and noted it. Interesting question and interesting answer.

Basically here is the question. Can I insert data in to multiple tables in MySQL using one insert SQL statement?

Seems like the answer is no

Can I you insert data multiple times into the same table with one statement too.
INSERT INTO employees VALUES
(DEFAULT,'Hicks','Freddy','crew'),
(DEFAULT,'Harris','Joel','crew'),
(DEFAULT,'Davis','Julie','manager');

Examples taken from:
http://www.tizag.com/sqlTutorial/sqlinsert.php
http://www.desilva.biz/mysql/insert.html

Audio Noise Removal

Many times in record clips we end up with unwanted background noise. Recently faced with the situation, I  needed to clean up some audio and...