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 postgresSome 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 |