📜 ⬆️ ⬇️

GeoLite City vs CNGeoip

Yesterday I tested the GeoLite City base from Max Ming. This is a free version of the database, almost no different from the paid version. After studying the contents of the database came to disappointing conclusions.
There are a lot of mistakes in the spelling of cities in the database, different spellings (for example, Chelyabinsk and Cheliabinsk) are often encountered, regions and sometimes streets are sometimes written instead of cities. But the biggest problem is that the names of all cities are written only in English / local Latin. Such a base is practically unsuitable for use in Russian-speaking resources. To make the correspondence of the English names to the Russians in an automatic mode is practically an unreal task for the reasons described above. And only fairly large companies can afford to use the work of operators for processing about 180,000 locations in the database. The curse of the GeoLite City database can be found even on this forum .
[Interesting, and which databases use Google, Yandex?]

I did not find any other good full-fledged databases of cities (not countries) over IP, either paid or free, except for one - this is CNGeoip - a module for determining a city and country by IP address. I must say that the base is paid. The cost of the base for one site is 99 WMZ (when paying by WebMoney, as of 04/02/2008).
Now about the possibilities. I tested the database on the manufacturer’s website. For this there is a demo version . All test queries gave a result no worse than GeoLite City. The speed of the work does not cause complaints.
But the main advantage of CNGeoip over GeoLite City is that all the names of cities and countries are available in both English and Russian! That is, it is easy to use the base on services that are oriented to the Runet.
CNGeoip developers in their blog write :
“The task of determining the city of a user by IP address is not as rare as it seems, it is the analysis of statistics, banner targeting, automatic setting of user profiles, etc.
Base geography is not so difficult to find - expensive.
The real quality of the database is from MaxMinda (this is the one that everyone uses, but does not pay (GeoIPCity :)). The price of this base inspires, for a thousand bucks a year passes.
But Russia and the CIS are covered there with inaccuracies, sometimes ridiculous. Type city - st. Lenin, etc. Well, in general, all this and so they know.
It has long been thought to make their decision. Understood why take the money Maxmindovtsy. :) "

In fact, the quality of the CNGeoip base on the territory of the former USSR far exceeds the quality of GeoLite City. [According to my humble tests. If you have counterarguments, welcome to the comments!]
Testing in practice. First, as I already wrote, you can always test the database on a demo page , where your defined IP and location are written on the left. There is also a form for entering any IP. But of course this was not enough for me. I would like to test the database in real conditions. However, I did not find the laid out base on the Web in the clear. While thinking about buying.
Conclusion If you are going to create a commercial service in RuNet in Russian, which requires the definition of a country and a city by IP (for example, auto-substitution of values ​​in the corresponding fields during registration, or the display of a weather informer by city ), you should definitely look towards CNGeoip. There are no quality alternatives. $ 200 for the base plus a year of updates - a cheap price.

')

Source: https://habr.com/ru/post/22779/


All Articles