
Security News
vlt Launches "reproduce": A New Tool Challenging the Limits of Package Provenance
vlt's new "reproduce" tool verifies npm packages against their source code, outperforming traditional provenance adoption in the JavaScript ecosystem.
bigquery-geoip
Advanced tools
Bigquery maxmind geoip loader
Sign up for an account at https://maxmind.com.
Download and extract the following databases:
GeoLite2-ASN-CSV
GeoLite2-City-CSV
bq mk geoip
First, cd
to the parent directory of the extracted database directories:
cd ~/Downloads
# These paths should exist:
ls GeoLite2-ASN-CSV*/GeoLite2-ASN-Blocks-IPv4.csv
ls GeoLite2-City-CSV*/GeoLite2-City-Blocks-IPv4.csv
ls GeoLite2-City-CSV*/GeoLite2-City-Locations-en.csv
Then run the load script:
npm install -g bigquery-geoip
bigquery-geoip
with ips as (
select "162.213.133.27" as ip
)
select city.*, ips.*
from ips
left join geoip.city
on CAST(NET.IPV4_TO_INT64(NET.IP_FROM_STRING(ips.ip))/(256*256*256) as INT64) = class_a
and NET.IPV4_TO_INT64(NET.IP_FROM_STRING(ips.ip)) between start_num and end_num
The default dataset name is geoip
. Customize it by adding an argument:
bigquery-geoip ipToCity
FAQs
Bigquery maxmind geoip loader
The npm package bigquery-geoip receives a total of 0 weekly downloads. As such, bigquery-geoip popularity was classified as not popular.
We found that bigquery-geoip demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
vlt's new "reproduce" tool verifies npm packages against their source code, outperforming traditional provenance adoption in the JavaScript ecosystem.
Research
Security News
Socket researchers uncovered a malicious PyPI package exploiting Deezer’s API to enable coordinated music piracy through API abuse and C2 server control.
Research
The Socket Research Team discovered a malicious npm package, '@ton-wallet/create', stealing cryptocurrency wallet keys from developers and users in the TON ecosystem.