On 9/6/16, Richard Hipp <d...@sqlite.org> wrote: > On 9/6/16, Nelson, Erik - 2 <erik.l.nel...@bankofamerica.com> wrote: >> >> What percentage of sqlite.org hits are mobile browsers? > > Rough breakdown: 4% mobile, 6% bots, 90% desktop.
Emphasis on *rough*. When I compute the number of bots using a better algorithm, I get twice as many. (The numbers above come from an SQL query with a long "WHERE agent LIKE '%..%' OR agent LIKE '%...%' OR agent LIKE '%..%' ..." phrase.) Assuming mobile is similarly under-counted, a better estimate might be: 8% mobile, 12% bots, 80% desktop -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users