pablodz’s gists

pablodz / violence analizer.ipynb

Created June 28, 2020 22:18

Sorry, something went wrong. Reload?

Sorry, we cannot display this file.

Sorry, this file is invalid so it cannot be displayed.

pablodz / NLP libraries language support.csv

Last active June 28, 2020 23:22

NLP Library	Languages supported	Can I add new dictionaries?
NLTK	'danish', 'dutch', 'english', 'finnish', 'french', \n 'german', 'hungarian', 'italian', 'norwegian', 'portuguese', 'russian', 'spanish', 'swedish', 'turkish'	YYes
TextBlob	English, French, German, Arabic	No
CoreNLP	Arabic,Chinese, French, German, Spanish (Not completely, check https://stanfordnlp.github.io/CoreNLP/human-languages.html)	-
Gensim	English	-
spaCy	Chinese, Danish, Dutch, English, French, German, Greek, Italian, Japanese, Lithuanian, Norwegian, Polish, Portuguese, Romanian, Spanish (https://spacy.io/usage/models)	-
polyglot	69 languages (https://polyglot.readthedocs.io/en/latest/Transliteration.html)	-
scikit-learn

pablodz / grafana install on ubuntu or debian.bash

Created July 1, 2020 18:48

	sudo apt-get install -y adduser libfontconfig1
	wget https://dl.grafana.com/oss/release/grafana_7.0.5_amd64.deb
	sudo dpkg -i grafana_7.0.5_amd64.deb

pablodz / initialize grafana as service.bash

Created July 1, 2020 18:52

	sudo systemctl daemon-reload
	sudo systemctl start grafana-server
	sudo systemctl status grafana-server

pablodz / postgresql apt.bash

Last active July 1, 2020 19:48

	# Create the file repository configuration:
	sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'

	# Import the repository signing key:
	wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \| sudo apt-key add -

	# Update the package lists:
	sudo apt-get update

	# Install the latest version of PostgreSQL.

pablodz / timescaledb debian postgresql.bash

Created July 1, 2020 19:56

	# Add our repository
	# Changed https://packagecloud.io/timescale/timescaledb/debian/ (Broken) to https://packagecloud.io/timescale/timescaledb/
	sudo sh -c "echo 'deb https://packagecloud.io/timescale/timescaledb/ `lsb_release -c -s` main' > /etc/apt/sources.list.d/timescaledb.list"
	wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey \| sudo apt-key add -
	sudo apt-get update

	# Now install appropriate package for PG version
	sudo apt-get install timescaledb-postgresql-12

pablodz / creating database postgresql.bash

Created July 1, 2020 20:35

	# Check postgres sql
	sudo -u postgres psql -c "SELECT version();"
	# Creating a new user in postgres
	sudo su - postgres -c "createuser your_username"
	# Creating the database
	sudo su - postgres -c "createdb your_database_name"
	# Enter postgres line command
	sudo -u postgres psql
	# Set the privileges of the user for the database
	# Maybe this part need to we copy&paste separetely

pablodz / change listen_addresses of postgres.bash

Last active July 1, 2020 20:38

	# open virtual editor to change file
	# Change 11 to the version that you are using
	sudo nano /etc/postgresql/11/main/postgresql.conf

pablodz / postgresql.conf

Created July 1, 2020 20:39

	#------------------------------------------------------------------------------
	# CONNECTIONS AND AUTHENTICATION
	#------------------------------------------------------------------------------


	# SCROLL DOWN UNTIL YOU FIND THE PART BELOW
	# MAYBE IS COMMENTED, SO UNCOMMENT ADD THE SYMBOL * AND SAVE
	# TO SAVE USE CTRL+X THEN TYPE LETTER 'Y', FINALLY ENTER

	# - Connection Settings -

pablodz / pg_hba.conf

Last active July 1, 2020 20:49

	# open virtual editor to change file
	sudo nano /etc/postgresql/11/main/pg_hba.conf

Pablo pablodz