DuckDuckGo Traffic

Re:DuckDuckGo Traffic by kccqzy on Wednesday January 22, 2020 @02:53AM (#22115529)

Google's results have definitely become more quirky. Just now I was writing some SQLite database code and was wondering how the sum() aggregate handles integer overflow. So I searched for "sqlite integer overflow" in DDG and Google. To my surprise the first result in Google is someone's random blog post[0] from 2011 describing their experience which doesn't answer my question at all. I am very surprised Google decided to put this as the first result. Both DDG and Google gave me results on Stack Overflow, but only Google managed to give me the official documentation of aggregate functions on the sqlite website, with the snippet highlighting the relevant fact: "Sum() will throw an 'integer overflow' exception if all inputs are integers or NULL and an integer overflow occurs at any point during the computation."

Overall I still believe for sloppily constructed queries for which I want specific results Google seems to read my mind better and produce better results than DDG, but Google is very quirky.

[0]: http://jakegoulding.com/blog/2011/02/06/sqlite-64-bit-intege...

[ Parent | on HN ]

Re:DuckDuckGo Traffic by klingonopera on Wednesday January 22, 2020 @08:34AM (#22117361)

This is a particularly interesting query, as both SO and the query itself share the word overflow, which probably is throwing off DDG from the result you were looking for.

For me, on DDG, it's the first result on the 2nd page, on Google, it's the third result.

It would appear that DDG and Google's results differentiate in a way, that the sequence of words probably don't matter on DDG, but do matter on Google.

[ Parent | on HN ]