IP address data and intelligence for businesses
“I also use Workflowy a lot for my current to-do-list and other longer-term priorities.”
“I almost always listen to music while I'm working - I find it helps to block out distractions and get me into the "zone". I have a bunch of different Spotify playlists I switch between.”
“Importing into PostgreSQL The CSV-formatted distribution of the dataset is easier to import into PostgreSQL than the JSON version. I'll create a new database and table and populate it with the CSV file. $ createdb ipinfo_free $ psql ipinfo_free CREATE TABLE country_asn_latest ...”
“$ pip install \ emoji-country-flag \ geoip2 \ pyecharts”
“I spend a lot of time in Gmail and Google Calendar!”
“I'll use it to install Python and DuckDB. $ brew install \ csvkit \ duckdb \ jq \ virtualenv”
“Importing into SQLite SQLite3 only supports five data types so every field will be imported as a TEXT field. $ sqlite3 ipinfo_free.db .mode csv .separator "," .import country_asn.latest.csv country_asn_latest”
“Importing into ClickHouse ClickHouse supports importing JSON and this format avoids delimiter pitfalls that are common with CSVs. $ clickhouse client CREATE OR REPLACE TABLE ipinfo_country_asn ...”
“I've installed Homebrew on my 2020 MacBook Pro and I'll use it to install Python and DuckDB. $ brew install \ csvkit \ duckdb \ jq \ virtualenv”
“I've installed Homebrew on my 2020 MacBook Pro and I'll use it to install Python and DuckDB. $ brew install \ csvkit \ duckdb \ jq \ virtualenv”
“$ brew install \ csvkit \ duckdb \ jq \ virtualenv”
“DBeaver is a free, open source, GUI application that can connect to more than 100 different database engines. It can run on macOS, Windows and Linux. It makes it very easy to connect to remote databases and import data from files on your local system.”