I'Ve a table which contains IPs in rows I'm wanting to

Question

Devs Chat

Kazem

I'Ve a table which contains IPs in rows I'm wanting to

sort them by country
What's the best reason ?
I can't save countries in that table

#english #programming

0

16.10.2020

17 ответов

4 просмотра

Kazem Автор вопроса

Ulven - Old account
Unix uniq

what

0

16.10.2020

Пользователь 61930

That is a crazy task let me tell you that. But how can it be done? geoip-lite Is a database full of ipv4 ranges sorted by country. You should search each IP against all the ranges. I suggest loading all the database into the memory first then doing a b tree search on it. The database comes in form of csv

0

16.10.2020

Kazem Автор вопроса

Пользователь 61930
That is a crazy task let me tell you that. But ho...

how to a b tree search ?

0

16.10.2020

Ulven - Old account

Kazem
how to a b tree search ?

Bruh

0

16.10.2020

Kazem Автор вопроса

Ulven - Old account
Bruh

yea

0

16.10.2020

Пользователь 61930

Kazem
how to a b tree search ?

Google first I told you it's tough. You need to write a b tree algorithm against that geoip database

0

16.10.2020

Kazem Автор вопроса

Пользователь 61930
Google first I told you it's tough. You need to w...

Sorry I didn't understand Am I correct ? 1. sort geoip database 2. search all IPs in geodb 3. list countries and sort by used count I need just top 6 used countries

0

16.10.2020

Пользователь 61930

Kazem
Sorry I didn't understand Am I correct ? 1. sort ...

Yes that is correct.

0

16.10.2020

Kazem Автор вопроса

Пользователь 61930
Yes that is correct.

sort database by what ? country ?

0

16.10.2020