Tiago Albineli Motta timotta

timotta / dependencies.json

Created March 10, 2021 20:20

Lib versions that works together on package.json

timotta / postgre_tables_size.sql

Created November 28, 2019 19:39

	SELECT *, pg_size_pretty(total_bytes) AS total
	, pg_size_pretty(index_bytes) AS INDEX
	, pg_size_pretty(toast_bytes) AS toast
	, pg_size_pretty(table_bytes) AS TABLE
	FROM (
	SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM (
	SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME
	, c.reltuples AS row_estimate
	, pg_total_relation_size(c.oid) AS total_bytes
	, pg_indexes_size(c.oid) AS index_bytes

timotta / postgre.sql

Created October 2, 2019 13:10

	-- show tables
	SELECT * FROM pg_catalog.pg_tables;

	-- describe table
	select column_name, data_type, character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_name = 'tablename';

timotta / notebook-to-python.sh

Created May 16, 2019 13:12

jupyter nbconvert --to script config_template.ipynb

timotta / enabling-jupyter-service.sh

Created April 25, 2019 18:51

	sudo cp jupyter.service /usr/lib/systemd/system/
	sudo systemctl enable jupyter.service
	sudo systemctl daemon-reload
	sudo systemctl restart jupyter.service
	journalctl -u jupyter > /tmp/test.txt && cat /tmp/test.txt

timotta / jupyter.service

Created April 25, 2019 17:06

	[Unit]
	Description=Jupyter Notebook

	[Service]
	Type=simple
	PIDFile=/run/jupyter.pid
	# Step 1 and Step 2 details are here..
	# ------------------------------------
	ExecStart=/usr/local/bin/jupyter notebook --ip=0.0.0.0 --no-browser
	User=ubuntu

timotta / jupyter.sh

Created February 15, 2019 17:49

sudo jupyter notebook --allow-root --ip=0.0.0.0 --port=80 --no-browser

timotta / .gitignore_global

Created February 15, 2019 12:48

timotta / erase.sh

Created February 14, 2019 19:18

Erase HD

dd if=/dev/urandom of=/dev/sdX bs=1M

timotta / ml-engine.sh

Last active February 9, 2019 16:36

	JOBID=`cat /dev/urandom \| tr -dc 'a-zA-Z' \| fold -w 10 \| head -n 1`

	gcloud ml-engine jobs submit training $JOBID \
	--module-name=$MODULE \
	--region=us-central1 \
	--package-path=$PACKAGE \
	--job-dir=$BUCKET \
	--project=$PROJECT \
	--scale-tier=basic_gpu