I hereby claim:
- I am jrc on github.
- I am jrc (https://keybase.io/jrc) on keybase.
- I have a public key whose fingerprint is 992C 4519 EF34 0CCA CA9E 08A3 0D2E 1F38 61F5 F472
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
# Get ISO country codes and demonyms for all countries and geo regions | |
SELECT ?item ?itemLabel ?countryCode ?demonym | |
WHERE { | |
{ | |
# see "Query not returning all expected results" | |
# https://www.wikidata.org/wiki/Wikidata_talk:SPARQL_query_service/queries | |
?item p:P31 [ps:P31 wd:Q6256]. # categoryof (P31) country (Q6256) | |
?item wdt:P297 ?countryCode . | |
?item wdt:P1549 ?demonym . | |
FILTER (LANG(?demonym) = "en") . |
# Monitor Wi-Fi signal on Linux (Debian) | |
import subprocess | |
import time | |
IS_TESTING_ON_MACOS = False | |
SLEEP_SECS = 60 | |
#!/bin/bash | |
GATEWAY_IP=172.18.0.1 | |
log() { | |
command echo "$(date --rfc-3339=seconds | sed 's/ /T/'): $@" | |
} | |
while true | |
do |
https://docs.timescale.com/latest/getting-started/installation/ami/installation-ubuntu-ami
ssh -i ~/.ssh/KEY-PAIR.pem ubuntu@HOSTNAME
postgres
user: sudo -u postgres -s
/etc/postgresql/12/main/
.
postgresql.conf
, change listen_addresses = '*'
pg_hba.conf
, add host all all YOUR-IP-ADDRESS/32 md5
psql
then ALTER USER postgres PASSWORD 'newPassword';
to set a password.