Wednesday, July 30, 2014

Send money per Gmail

Most interesting feature -  I know quite a few companies have been working on this, and read a bit about Google planning financial services, but it still came as a surprise when this popped up in my gmail today:



Google offers to send money per email to any recipient it looks like.
And the transfer seems to be free with a debit card of when linked to an bank account. 
It again provides verification - real world verification, much stronger even than a phone number! And it also will make it easier to purchase through Google - giving Google fees in the process. 



Thursday, July 10, 2014

Google ngrams - see the rapid increase for Google



Ngrams has data on word occurrences in books over a long timespan (1800 to 2008). A 1gram is just the word itself, a 2gram a two word combination and so on.

What's closer than trying this on mentions on search engines in books? They pretty much show the rapid rise of mentions of  'Google' compared to others like Bing, Baidu, Hotbot, Altavista, Wolfram Alpha (with the last two not even being found).

Take a look:


Definitely going to use this more!

Tuesday, July 1, 2014

Mysql - cautious with formatted numbers!

WATCH IT - when using formatted numbers in mysql. This was keeping me busy for a little while, I did not expect this to happen and had do do some searches and tries to find the root cause:

The query for these two is the same , but the first calculation is with formatted numbers, the second with unformatted. What a difference (and what a "curious" behavior in mysql): -172306 vs 97

mysql calculation with 'formatted' number

mysql calculation with not formatted numbers



Just to show the queries in case:
set @one=(select format(count(distinct(Target_URL)),0) from supportdellcom_inbound_links_urls_T);
set @two=(select format(count(distinct(Target_URL)),0) from supportdellcom_backlinks_t);
set @three=(select count(*) from (select Target_URL from supportdellcom_backlinks_t
union
select Target_URL from supportdellcom_inbound_links_urls_T) x)  ;
select (@one + @two - @three);

set @four=(select count(distinct(Target_URL)) from supportdellcom_inbound_links_urls_T);
set @five=(select count(distinct(Target_URL)) from supportdellcom_backlinks_t);
set @six=(select count(*) from (select Target_URL from supportdellcom_backlinks_t
union
select Target_URL from supportdellcom_inbound_links_urls_T) x)  ; # why the x at the end of the line?
select concat("number of the same target urls majestic to google is: ", (@four + @five - @six);

Bookmark and Share