GeoIP MaxMind vs IPligence

[nickCR]

Hello All,

I have not been able to turn up much information comparing the two. I just bought the MaxMind data for $370 tonight but I later found IPligence (found them while searching for suggestions to translate short to long IPs).

IPligence is almost half the price and you even get a year of updates which is NOT something that MaxMind provides. I am curious if anyone has had any experience with either or and what you guys think?

Regards,

Nick

[topr8]

i use ip2location which i'm very happy with (not affiliated with in any way) - monthly updates for a years subscription

[Anyango]

No offence but i always thought we may not talk about paid products, specialy the names and price, here.

[nickCR]

Oh i'm sorry about including the price. Lets make this convo about the services each offers and which is better than the other.

If a mod really feels this is inappropriate please let me know or remove the post.

[astupidname]

translate short to long IPs

Just wondering, did you know php (version 4 and up) has an ip2long($ip) function and a long2ip($longip) function? See: [us3.php.net...]

[nickCR]

Very cool. Thanks for the suggestion that might come in very handy. I found on one of those sites that even MySQL has a converter:

Alternatively, you can take advantage of the sql function INET_ATON(), which translates the IP address to IP Number/Decimal for you, check if your SQL database supports such function.

The query using INET_ATON() looks like this:

SELECT owner,latitude,longitude,city_name,country_name FROM ipligence WHERE ip_from <= INET_ATON('209.132.177.50') and ip_to >= INET_ATON('209.132.177.50') LIMIT 1;

You can also use INET_NTOA() to translate a IP Number/Decimal to a normal IP address dotted format:

select INET_NTOA('3515134258');

The result is:

+-------------------------+
| INET_NTOA('3515134258') |
+-------------------------+
| 209.132.177.50 |
+-------------------------+
1 row in set (0.00 sec)