|
|
|
|
|
|
by anyfactor
1201 days ago
|
|
|
I would really love some feedback and queries from HN. I have been in HN for a while now, and through absolute wild luck Ben hired me because, get this.... he liked a comment I made on HN. But that is another story.... I am the first DevRel hire of IPinfo and this is the first product launch that we did that celebrates the developer experience. So, any feedback you have in regard to documentation, technical resources and using this boatload of data, please, let me know. Thank you. |
|
|
So, I exported the CSV files for country and asn data, and then uploaded them to Splitgraph. You can see some sample queries in the readme of the repository [0]. Since Splitgraph is built on Postgres, it's possible to use all the `inet` and `cidr` tools available from Postgres, so you can make range queries easily. One sample query also demonstrates a join between the two tables, resulting in the equivalent of your combined country_asn.csv.
Another idea: We have a newer project called Seafowl [1], which is an open-source analytical database optimized for running "at the edge," with cache-friendly semantics making it ideal for querying from Web applications. We don't have a SaaS version of this yet, so you'll need to host it yourself, but perhaps the next thing to try would be loading this data into Seafowl and querying it "at the edge" - I've been thinking about ways that we could package Seafowl along as an OpenResty module, which could allow for true "at the edge" use cases like querying IP data in your reverse proxy. (Although the .mmdb format already solves this particular problem pretty efficiently and interoperably, although I'd be curious to measure the difference).
[0] https://www.splitgraph.com/miles/ipinfo-country-asn
[1] https://seafowl.io/