MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists many different client programs/libraries. Very useful tips for all mysql DBA’s, Developers. Minimize traffic by fetching only what you need. Paging/chunked data retrieval to limit Don’t use SELECT * Be wary of lots of small quick queries if [...]
November 1st, 2010
Turkey Lifts YouTube Ban
Back in March 2007, a Turkish court ordered YouTube to be banned in that country over offensive comments about the founding father of the Turkish Republic, Mustafa Kemal Ataturk. This ban was eventually lifted, but videos insulting the founding father caused one new ban after another; YouTube was finally completely blocked in Turkey in May [...]
October 21st, 2010
Store Daily Alexa Report into MySQL using PHP Simple HTML DOM Parser
My company asks me to take daily alexa report manually. I took for more than 3 months. But, after that, i got bored in doing manual works. Becuase, nearly i needs to take more than 20 websites per day. It’s eats my time and structs in my remaining works. So, i searched for solution online [...]
October 19th, 2010
Phishing scam trying to steal your Account
Before few mins, i received a mail from unknown gmail account by saying that “Due to congestion in our database, we deleting your Google account”. Once i found this email, i found that it’s a phishing scam send by someone to hack my gmail account. So beware always to product your account from hacking. You can get Email as [...]
October 4th, 2010
Google announces new photo format: WebP
WebP (pronounced weppy) has been under development by Google and reduces file sizes by 40 percent compared to JPEGs. That means faster downloads from websites and less strain on networks. Richard Rabbat, product manager at Google explains why they made the decision to develop WebP, “Most of the common image formats on the web today [...]
October 3rd, 2010
Avoid following Tips to Increase Google page rank
Never put ads to new sites right away as Google may mark your site as “ ad farm “ and will not index the site. You should wait for a month or so to begin ad activity. It has been seen that Google bestows high ranking to sites having multiple inbound links. The important fact [...]
September 26th, 2010
Log into the Google Analytics API using PHP and CURL using Username/Password Authentication
Google have finally made an API available for Google Analytics although it’s currently in beta and the specs are subject to change. I’ve been playing around this morning logging in using ClientLogin Username/Password Authentication with PHP and CURL and show how to do this here. The code example below attempts to log in using $email [...]
September 21st, 2010
How to Add Google Reader Feeds to Flipboard : #iPad Hack
Okay, let me put it short and sweet. Flipboard is the revolutionary app that sits on every iPad. Its a beautiful app with a different perspective and an effective way of presenting the otherwise confusing, over-sized, disorganized data from your social channels. It picks up your social media networks and presents the news and links shared by [...]
