You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by "abdullahdevrel (via GitHub)" <gi...@apache.org> on 2025/09/12 04:47:33 UTC

[I] Feature request: Using IPinfo Lite DB (druid)

abdullahdevrel opened a new issue, #18514:
URL: https://github.com/apache/druid/issues/18514

   ### Description
   
   I am requesting to add support for [IPinfo's Lite](https://ipinfo.io/developers/ipinfo-lite-database) to the project.
   
   The database has the following features:
   
   -   Updated daily, with zero compromise to accuracy (no range clustering, full IP-level accuracy).
   -   Includes both **country** and **ASN** information in the same database.
   -   Data granularity at the **individual IP level**.
   -   Licensed under **CC-BY-SA 4.0**, permitting commercial usage, redistribution, and repackaging.
   -   Available in multiple file formats: **CSV, MMDB, JSON, and Parquet**.
   -   Tabular, unnested format, easy to work with.
   -   Includes both **IPv4 and IPv6** in a single file.
   
   #### Database Schema
   
   | Field Name | Example | Data Type | Description |
   | --- | --- | --- | --- |
   | network | 154.24.39.204/30 | TEXT | CIDR/IP range or single IP address |
   | country | Canada | TEXT | Country name |
   | country_code | CA | TEXT | Two-letter ISO 3166 country code of the IP addresses |
   | continent | North America | TEXT | Continent name of the IP location |
   | continent_code | NA | TEXT | Two-letter continent code of the IP location |
   | asn | AS174 | TEXT | Autonomous System Number, an organization that owns the IP range block |
   | as_name | Cogent Communications | TEXT | Name of the AS (Autonomous System Number) organization |
   | as_domain | cogentco.com | TEXT | Official domain or website of the ASN organization |
   
   Documentation: <https://ipinfo.io/developers/ipinfo-lite-database>\
   Samples: <https://github.com/ipinfo/sample-database/tree/main/IPinfo%20Lite>
   
   The database can be downloaded with only a free access token:
   
   `curl -L https://ipinfo.io/data/ipinfo_lite.csv.gz?token=$TOKEN -o ipinfo_lite.csv.gz`
   
   Additionally, there is a free [IPinfo Lite API service](https://ipinfo.io/developers/lite-api) based on this database that supports unlimited requests.
   
   ### Motivation
   
   -   **Use case**: Adding IPinfo Lite as a supported database would allow developers to integrate an accurate, daily updated, and open-licensed IP-to-geo/ASN database without restrictions.
   -   **Rationale**:
       -   Provides a high-quality, free, and permissively licensed alternative to existing databases.
       -   Simplifies integration with its easy-to-use, unnested schema.
       -   Offers flexibility with multiple formats (CSV, MMDB, JSON, Parquet).
       -   Ensures future-proofing with both IPv4 and IPv6 support in a single dataset.
       -   Free API version enables unlimited lookups, reducing dependency on bundled static databases.
   
   Let me know what you think. Thanks!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [I] Feature request: Using IPinfo Lite DB (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #18514:
URL: https://github.com/apache/druid/issues/18514#issuecomment-5013544197

   This issue has been closed due to lack of activity. If you think that
   is incorrect, or the issue requires additional review, you can revive the issue at
   any time.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [I] Feature request: Using IPinfo Lite DB (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #18514:
URL: https://github.com/apache/druid/issues/18514#issuecomment-4755774244

   This issue has been marked as stale due to 280 days of inactivity.
   It will be closed in 4 weeks if no further activity occurs. If this issue is still
   relevant, please simply write any comment. Even if closed, you can still revive the
   issue at any time or discuss it on the dev@druid.apache.org list.
   Thank you for your contributions.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org


Re: [I] Feature request: Using IPinfo Lite DB (druid)

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #18514: Feature request: Using IPinfo Lite DB
URL: https://github.com/apache/druid/issues/18514


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org