start new:
tmux
start new with session name:
tmux new -s myname
#!/usr/bin/env python | |
# | |
# Mersenne Twister predictor | |
# | |
# Feed this program the output of any 32-bit MT19937 Mersenne Twister and | |
# after seeing 624 values it will correctly predict the rest. | |
# | |
# The values may come from any point in the sequence -- the program does not | |
# need to see the first 624 values, just *any* 624 consecutive values. The | |
# seed used is also irrelevant, and it will work even if the generator was |
Magic words:
psql -U postgres
Some interesting flags (to see all, use -h
or --help
depending on your psql version):
-E
: will describe the underlaying queries of the \
commands (cool for learning!)-l
: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)Postgres Cheat Sheet | |
Source: Postgresql Documentation | |
### shell commands | |
creatuser <user> | |
deletesuer <user> | |
createdb -O <user> -E utf8 -T <template> <db_name> | |
dropdb <db_name> |
import numpy as np | |
from lightning.classification import SAGAClassifier | |
from scipy import sparse | |
from sklearn.datasets import load_iris, make_classification | |
from sklearn.linear_model.logistic import ( | |
LogisticRegression, | |
) | |
#!/usr/bin/env bash | |
# obtains all data tables from database | |
TS=`sqlite3 $1 "SELECT tbl_name FROM sqlite_master WHERE type='table' and tbl_name not like 'sqlite_%';"` | |
# exports each table to csv | |
for T in $TS; do | |
sqlite3 $1 <<! | |
.headers on |