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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
