# \#database

**URL:** https://community.ipinfo.io/tag/database/11.md

[Latest](https://community.ipinfo.io/latest.md) · [Categories](https://community.ipinfo.io/categories.md) · [Tags](https://community.ipinfo.io/tags.md)

---

## [LetsEncrypt IP's Accessibility](https://community.ipinfo.io/t/letsencrypt-ips-accessibility/7439)

<div class="topic-metadata">

**Author:** [@Postholer](https://community.ipinfo.io/u/Postholer)\
**Replies:** 2\
**Last updated:** [October 25, 2026, 7:42pm UTC](https://community.ipinfo.io/t/letsencrypt-ips-accessibility/7439 "2026-10-25T19:42:56Z")

</div>

Greetings! Here’s the dilemma. LetsEncrypt validates from a range of IP/CIDR’s. Understandably, they don’t make these public. Typically, you can find some of these in your web server logs, as they’re clearly tagged. T…

---

## [Migrating from MaxMind: Geolite2 Country to IPinfo Lite | MMDB Edition](https://community.ipinfo.io/t/migrating-from-maxmind-geolite2-country-to-ipinfo-lite-mmdb-edition/56)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [April 4, 2023, 10:54am UTC](https://community.ipinfo.io/t/migrating-from-maxmind-geolite2-country-to-ipinfo-lite-mmdb-edition/56 "2023-04-04T10:54:35Z")

</div>

If you want better accuracy, higher update frequency, an enterprise-ready solution, and more lenient license and copyright terms, you might be interested in our free IP data downloads. This guide shows how to migrate fro…

---

## [Limitations with Delta Updates and Real-Time Updates](https://community.ipinfo.io/t/limitations-with-delta-updates-and-real-time-updates/7274)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 1, 2026, 6:11pm UTC](https://community.ipinfo.io/t/limitations-with-delta-updates-and-real-time-updates/7274 "2026-05-01T18:11:51Z")

</div>

In the past we have experimented with delivering updates as deltas, and we continue to think about real-time or streaming data flow. However, the benefit-to-cost ratio is not always there. Delta and real-time updates int…

---

## [Website shows different info from API](https://community.ipinfo.io/t/website-shows-different-info-from-api/7054)

<div class="topic-metadata">

**Author:** [@whao](https://community.ipinfo.io/u/whao)\
**Replies:** 5\
**Last updated:** [September 21, 2025, 1:25pm UTC](https://community.ipinfo.io/t/website-shows-different-info-from-api/7054 "2025-09-21T13:25:19Z")

</div>

Hello, I am encountering a weird issue when inspecting IP 203.243.131.33. Here is the data I got from API. { "ip": "203.243.131.33", "city": "Sejong", "region": "Sejong-si", "country": "KR", "loc": "36.5924,1…

---

## [Understanding Range Aggregation in IPinfo's IP Databases](https://community.ipinfo.io/t/understanding-range-aggregation-in-ipinfos-ip-databases/6528)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [October 19, 2024, 5:14pm UTC](https://community.ipinfo.io/t/understanding-range-aggregation-in-ipinfos-ip-databases/6528 "2024-10-19T17:14:22Z")

</div>

You will often see that the number of ranges of an ASN you obtain through IPinfo WHOIS records, IP to Company Database or our ASN API does not match with the number of ranges in the ASN database or the free IP to ASN dat…

---

## [Database Type string values](https://community.ipinfo.io/t/database-type-string-values/6930)

<div class="topic-metadata">

**Author:** [@Sebbs](https://community.ipinfo.io/u/Sebbs)\
**Replies:** 5\
**Last updated:** [July 25, 2025, 9:04pm UTC](https://community.ipinfo.io/t/database-type-string-values/6930 "2025-07-25T21:04:55Z")

</div>

Hi folks. I’m currently adding support for IPInfo’s .mmdb databases in a project. The implementation requires the presence of columns containing the country name and country code, which limits the IPInfo databases that …

---

## [Using IPinfo's data in Spark (Using Pyspark)](https://community.ipinfo.io/t/using-ipinfos-data-in-spark-using-pyspark/6911)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [July 11, 2025, 8:26pm UTC](https://community.ipinfo.io/t/using-ipinfos-data-in-spark-using-pyspark/6911 "2025-07-11T20:26:45Z")

</div>

I am not super familiar with Spark so, if you have any advice for me from the spark community that will be awesome. ips.csv IP 8.8.8.8 32.165.16.84 530f:239a:b09d:3e98:56a1:6ef3:9174:acf0 .... MMDB-based enrichment M…

---

## [IPinfo Cloud Data Push for Google Cloud Storage (Google Cloud Platform / GCP)](https://community.ipinfo.io/t/ipinfo-cloud-data-push-for-google-cloud-storage-google-cloud-platform-gcp/6773)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 3, 2025, 4:06pm UTC](https://community.ipinfo.io/t/ipinfo-cloud-data-push-for-google-cloud-storage-google-cloud-platform-gcp/6773 "2025-05-03T16:06:53Z")

</div>

IPinfo supports automated delivery of user data directly to Google Cloud Platform (GCP)'s Google Cloud Storage (GCS) buckets. This joins our existing support for AWS S3 and Azure Blob Storage, allowing customers to choos…

---

## [\[IPinfo Lite\] How to generate find IP addresses for smaller ASNs](https://community.ipinfo.io/t/ipinfo-lite-how-to-generate-find-ip-addresses-for-smaller-asns/6767)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 1, 2025, 1:56pm UTC](https://community.ipinfo.io/t/ipinfo-lite-how-to-generate-find-ip-addresses-for-smaller-asns/6767 "2025-05-01T13:56:23Z")

</div>

So, I created IPguessr as a meme of sorts, but it is grown to be a very fun project. I was generating IP addresses randomly and testing them against our API service to eliminate bogon IP addresses. function g…

---

## [IPinfo Data Push Now Supports Azure Blob Storage](https://community.ipinfo.io/t/ipinfo-data-push-now-supports-azure-blob-storage/6772)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 3, 2025, 4:02pm UTC](https://community.ipinfo.io/t/ipinfo-data-push-now-supports-azure-blob-storage/6772 "2025-05-03T16:02:53Z")

</div>

We’re excited to announce support for pushing user data directly to Azure Blob Storage, alongside our existing AWS S3 and GCP GCS integrations. This feature allows IPinfo users to automatically receive their data downloa…

---

## [IPinfo on Google Cloud Marketplace - Region challenge](https://community.ipinfo.io/t/ipinfo-on-google-cloud-marketplace-region-challenge/6647)

<div class="topic-metadata">

**Author:** [@Johann\_De\_Wet](https://community.ipinfo.io/u/Johann_De_Wet)\
**Replies:** 11\
**Last updated:** [March 29, 2025, 5:10am UTC](https://community.ipinfo.io/t/ipinfo-on-google-cloud-marketplace-region-challenge/6647 "2025-03-29T05:10:06Z")

</div>

Hi all, we’re attempting to use IPinfo in BigQuery (IPinfo’s data is now available in BigQuery) but running into the problem that the linked dataset it created is in the US region whilst our warehouse is in the EU region…

---

## [How to correct company info detail in ipinfo database](https://community.ipinfo.io/t/how-to-correct-company-info-detail-in-ipinfo-database/6716)

<div class="topic-metadata">

**Author:** [@Black\_Pearl](https://community.ipinfo.io/u/Black_Pearl)\
**Replies:** 1\
**Last updated:** [March 28, 2025, 5:53am UTC](https://community.ipinfo.io/t/how-to-correct-company-info-detail-in-ipinfo-database/6716 "2025-03-28T05:53:01Z")

</div>

{“name”:“NEBULA SYSTEM SDN BHD - AS147040”,“domain”:“hitachi-sunway-is.com”,“type”:“business”} Can i change the type = ISP instead of bussiness. This is the requirement from e-commerce platform that require the company …

---

## [\[Announcement\] We are adding rate limits to data downloads](https://community.ipinfo.io/t/announcement-we-are-adding-rate-limits-to-data-downloads/358)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 14, 2023, 12:22pm UTC](https://community.ipinfo.io/t/announcement-we-are-adding-rate-limits-to-data-downloads/358 "2023-05-14T12:22:31Z")

</div>

We are adding rate limits to data downloads TLDR Individual database download limit to up to 10 times a day Rate limits are based on individual machines per unique IP address This applies to both free and paid data d…

---

## [IPv6 coverge, new ranges, and fallback values \[IPinfo Basics\]](https://community.ipinfo.io/t/ipv6-coverge-new-ranges-and-fallback-values-ipinfo-basics/5627)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 9, 2024, 11:13am UTC](https://community.ipinfo.io/t/ipv6-coverge-new-ranges-and-fallback-values-ipinfo-basics/5627 "2024-05-09T11:13:35Z")

</div>

IPv6 coverage We cover 100% of the allocated IPv4 and IPv6 addresses. For IPv6 IP addresses, we cover assigned IP addresses. From a user perspective, our database covers all of the “available” IP addresses they see on th…

---

## [Bad IPv6 data in IPInfo involving ranges outside of global unicast](https://community.ipinfo.io/t/bad-ipv6-data-in-ipinfo-involving-ranges-outside-of-global-unicast/5711)

<div class="topic-metadata">

**Author:** [@08\_cupfuls\_repay](https://community.ipinfo.io/u/08_cupfuls_repay)\
**Replies:** 2\
**Last updated:** [July 29, 2024, 3:39pm UTC](https://community.ipinfo.io/t/bad-ipv6-data-in-ipinfo-involving-ranges-outside-of-global-unicast/5711 "2024-07-29T15:39:58Z")

</div>

There seem to the following ranges present in the IPInfo data (at least on the website and the free DBs) that involve ranges outside the global unicast range 2000::/3, which should not be there. 200:: - 200::ffff:ffff:f…

---

## [Setting up a customer data upload to S3](https://community.ipinfo.io/t/setting-up-a-customer-data-upload-to-s3/1789)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 2\
**Last updated:** [July 26, 2024, 1:08pm UTC](https://community.ipinfo.io/t/setting-up-a-customer-data-upload-to-s3/1789 "2024-07-26T13:08:12Z")

</div>

There are two ways to set up an S3 data push from IPinfo to a customer, depending on whether the bucket is: Owned by IPinfo Owned by the customer The choice is left to the customer, based on their own preference. 1…

---

## [Is it possible that English language website change automatically website language according to google geographic location?](https://community.ipinfo.io/t/is-it-possible-that-english-language-website-change-automatically-website-language-according-to-google-geographic-location/5691)

<div class="topic-metadata">

**Author:** [@Rahul\_Rastogi](https://community.ipinfo.io/u/Rahul_Rastogi)\
**Replies:** 1\
**Last updated:** [July 11, 2024, 7:57am UTC](https://community.ipinfo.io/t/is-it-possible-that-english-language-website-change-automatically-website-language-according-to-google-geographic-location/5691 "2024-07-11T07:57:55Z")

</div>

I have a website in the English language, is it possible that the website language be changed according to Google’s geographic location automatically? for example, if anyone opens my website in Japan/UAE/France then the …

---

## [Lookup IP geolocation and ASN with ClickHouse and IPinfo's free database](https://community.ipinfo.io/t/lookup-ip-geolocation-and-asn-with-clickhouse-and-ipinfos-free-database/149)

<div class="topic-metadata">

**Author:** [@Max](https://community.ipinfo.io/u/Max)\
**Replies:** 2\
**Last updated:** [July 4, 2024, 12:09pm UTC](https://community.ipinfo.io/t/lookup-ip-geolocation-and-asn-with-clickhouse-and-ipinfos-free-database/149 "2024-07-04T12:09:09Z")

</div>

ClickHouse is a very fast columnar database which is well-suited to analytics use cases. For example, you might use ClickHouse to log requests made to a website. With IPinfo’s free databases you can enhance ClickHouse ab…

---

## [Why do the numbers of columns not match between the CSV/JSON and MMDB files?](https://community.ipinfo.io/t/why-do-the-numbers-of-columns-not-match-between-the-csv-json-and-mmdb-files/5531)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 6\
**Last updated:** [March 19, 2024, 2:25am UTC](https://community.ipinfo.io/t/why-do-the-numbers-of-columns-not-match-between-the-csv-json-and-mmdb-files/5531 "2024-03-19T02:25:30Z")

</div>

Please read this blog first: How to choose the best file format for your IPinfo database? - IPinfo.io The MMDB file format is a special type of binary database, designed for efficient IP lookup and returning its IP …

---

## [\[Announcement\] IPinfo’s Extended Databases are now available on Snowflake ❄](https://community.ipinfo.io/t/announcement-ipinfo-s-extended-databases-are-now-available-on-snowflake/696)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 30, 2023, 7:39pm UTC](https://community.ipinfo.io/t/announcement-ipinfo-s-extended-databases-are-now-available-on-snowflake/696 "2023-05-30T19:39:16Z")

</div>

IPinfo’s extended database for geolocation and privacy detection is available on Snowflake IPinfo’s extended databases provide insights into our data methodology and grant users additional levels of context to our databa…

---

## [Lookup IP addresses RWHOIS data from IPinfo’s WHOIS Summary database on Snowflake](https://community.ipinfo.io/t/lookup-ip-addresses-rwhois-data-from-ipinfo-s-whois-summary-database-on-snowflake/1119)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [June 20, 2023, 5:06am UTC](https://community.ipinfo.io/t/lookup-ip-addresses-rwhois-data-from-ipinfo-s-whois-summary-database-on-snowflake/1119 "2023-06-20T05:06:53Z")

</div>

On Snowflake, all of our listings come with their own unique UDTF (User Defined Table Functions) that is designed to enrich your IP database in the most efficient way possible. You should exclusively use these UDTFs if y…

---

## [Lookup ASN information from IP addresses from the IPinfo ASN database on Snowflake](https://community.ipinfo.io/t/lookup-asn-information-from-ip-addresses-from-the-ipinfo-asn-database-on-snowflake/1120)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [June 20, 2023, 5:18am UTC](https://community.ipinfo.io/t/lookup-asn-information-from-ip-addresses-from-the-ipinfo-asn-database-on-snowflake/1120 "2023-06-20T05:18:46Z")

</div>

On Snowflake, all of our listings come with their own unique UDTF (User Defined Table Functions) that is designed to enrich your IP database in the most efficient way possible. You should exclusively use these UDTFs if y…

---

## [Snowflake UDF: TO\_IP - Convert the integer equivalent of an IPv4 address to its IPv4 string equivalent](https://community.ipinfo.io/t/snowflake-udf-to-ip-convert-the-integer-equivalent-of-an-ipv4-address-to-its-ipv4-string-equivalent/688)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 30, 2023, 3:01pm UTC](https://community.ipinfo.io/t/snowflake-udf-to-ip-convert-the-integer-equivalent-of-an-ipv4-address-to-its-ipv4-string-equivalent/688 "2023-05-30T15:01:37Z")

</div>

TO\_IP snowflake UDF converts the integer equivalent value of an IPv4 address to its IPv4 string format. Often time it is easy to run IP address operations through their integer or hexadecimal equivalent values. However, …

---

## [Snowflake UDF: TO\_IP6 - Convert IPv6 Hex Value to its IPv6 string equivalent](https://community.ipinfo.io/t/snowflake-udf-to-ip6-convert-ipv6-hex-value-to-its-ipv6-string-equivalent/685)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 30, 2023, 2:27pm UTC](https://community.ipinfo.io/t/snowflake-udf-to-ip6-convert-ipv6-hex-value-to-its-ipv6-string-equivalent/685 "2023-05-30T14:27:13Z")

</div>

TO\_IP6 Lets you convert IPv6’s hex equivalent to it’s IPv6 IP format In our Snowflake listings, we package our listings with helpful functions that make using our data super easy. In that pursuit, we have developed the T…

---

## [Snowflake UDF: TO\_INT - Convert IPv4 to its integer and IPv6 to its hexadecimal equivalent](https://community.ipinfo.io/t/snowflake-udf-to-int-convert-ipv4-to-its-integer-and-ipv6-to-its-hexadecimal-equivalent/687)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [May 30, 2023, 2:45pm UTC](https://community.ipinfo.io/t/snowflake-udf-to-int-convert-ipv4-to-its-integer-and-ipv6-to-its-hexadecimal-equivalent/687 "2023-05-30T14:45:54Z")

</div>

TO\_INT converts the IPv4 IP address to its integer equivalent and IPv6 address to its hexadecimal equivalent. TO\_INT is a powerful function that can help you write custom IP address query logic and run IP address-based o…

---

## [IPinfo's join\_key column explained](https://community.ipinfo.io/t/ipinfos-join-key-column-explained/5526)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [February 23, 2024, 10:44am UTC](https://community.ipinfo.io/t/ipinfos-join-key-column-explained/5526 "2024-02-23T10:44:21Z")

</div>

This was taken from an internal wiki. Feel free to drop a comment if you have specific questions or feedback. join\_key for IPv4 is /16 and for IPv6 is /34. The problem that join\_key tries to solve is to make joins …

---

## [Script to get list of ASN Organizations](https://community.ipinfo.io/t/script-to-get-list-of-asn-organizations/2415)

<div class="topic-metadata">

**Author:** [@7zdzH](https://community.ipinfo.io/u/7zdzH)\
**Replies:** 18\
**Last updated:** [February 2, 2024, 4:41pm UTC](https://community.ipinfo.io/t/script-to-get-list-of-asn-organizations/2415 "2024-02-02T16:41:25Z")

</div>

I have to get list of unique ASN Organizations for a country sorted by no. of IPs Example - US has ~31K AS and Amazon has many AS in US. I want to get a list of AS organizations in US sorted by no. of IPs they own. Her…

---

## [Using IPinfo’s data downloads in PostgreSQL](https://community.ipinfo.io/t/using-ipinfo-s-data-downloads-in-postgresql/1000)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [June 14, 2023, 2:27pm UTC](https://community.ipinfo.io/t/using-ipinfo-s-data-downloads-in-postgresql/1000 "2023-06-14T14:27:06Z")

</div>

Using our database in PostgreSQL involves the following steps: Using the IP4R extension for IP address lookups. Create a sample log table. Create the table for the IPinfo data ingestion and ingest the data there. Ru…

---

## [Using IPinfo’s databases in Cribl](https://community.ipinfo.io/t/using-ipinfo-s-databases-in-cribl/5262)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [January 25, 2024, 5:28pm UTC](https://community.ipinfo.io/t/using-ipinfo-s-databases-in-cribl/5262 "2024-01-25T17:28:13Z")

</div>

IP intelligence inside Cribl powered by IPinfo Cribl provides solutions for data management and observability. Their pioneering product, Cribl Stream, allows for the management and optimization of data, particularly m…

---

## [PostgreSQL: \`CREATE TABLE\` and \`CREATE FUNCTION\` (UDF) queries for IPinfo data downloads](https://community.ipinfo.io/t/postgresql-create-table-and-create-function-udf-queries-for-ipinfo-data-downloads/1003)

<div class="topic-metadata">

**Author:** [@Abdullah](https://community.ipinfo.io/u/Abdullah)\
**Replies:** 0\
**Last updated:** [June 14, 2023, 3:16pm UTC](https://community.ipinfo.io/t/postgresql-create-table-and-create-function-udf-queries-for-ipinfo-data-downloads/1003 "2023-06-14T15:16:24Z")

</div>

Postgres CREATE TABLE queries for IPinfo data downloads We recommend you go through our Postgres doc first if you have not already: Using IPinfo’s data downloads in PostgreSQL You need to install the IP4R extension to u…

[Next page](https://community.ipinfo.io/tag/database/11.md?match_all_tags=true&page=1&tags%5B%5D=database)
