ubuntu: add user to another group
source: https://www.howtogeek.com/50787/add-a-user-to-a-group-or-second-group-on-linux/ usermod -a -G examplegroup exampleusername
Category: uncategorized
mysql: extract domain from email
SUBSTR(email_addresses.email_address, INSTR(email_addresses.email_address, '@') + 1)
mysql: extract domain from url
SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(a0_custom_import_contacts.website, '//', '.'), '/', 1), '.', -2)
python imaplib: search emails with specific subject
result, numbers = mail.uid('search', None, '(SINCE "' + date_start + '" BEFORE "' + date_end + '") (SUBJECT "Failure")')
postgresql: incorrect table sizes
do a VACUUM FULL if you want to run this on python you need to set autocommit = True otherwise it […]
pgsql: clone database
pg_dump -Fc -f olddb.pgdump -d db_name createdb cloned_db_name pg_restore -d cloned_db_name olddb.pgdump
stock screeners
FINVIZ investing.com
esxi: search file format
find / -name "*ghetto*"
dr. caldwell esselstyn
cardiovascular health