Author: robin

0

Upgrade docker-compose

I got stuck with one of the docker-compose.yml that was using v3.8 and my docker-compose version was old. It did not support v3.8 files only v3.3 and below was supported. RaspberryPi at the time of writing only had docker-compose version...

0

Random data generator with Python

Faker is a python library that will generate random data. What can it generate? faker.providers faker.providers.address faker.providers.automotive faker.providers.bank faker.providers.barcode faker.providers.color faker.providers.company faker.providers.credit_card faker.providers.currency faker.providers.date_time faker.providers.file faker.providers.geo faker.providers.internet faker.providers.isbn faker.providers.job faker.providers.lorem faker.providers.misc faker.providers.person faker.providers.phone_number faker.providers.profile faker.providers.python faker.providers.ssn faker.providers.user_agent Example Related posts:...

0

Out of disk space in VirtualBox

Background Was working on compiling mysql server from source on a Oracle Linux 6 virtual machine and the root partition got full. Now what are my alternatives?   Options Increase space by resizing the .vdi disk file Tried and failed.....

0

Sqoop – Data import & export

Data import using Sqoop Teradata example $ sqoop import –connect jdbc:teradata://server_name/DATABASE=db1,LOGMECH=LDAP,CHARSET=UTF8 –driver “com.teradata.jdbc.TeraDriver” –username <user1> –password <password1> –query “select a.*, b.* from a inner join b on a.a_id=b.a_id where \$CONDITIONS AND a.f1 in (‘A’,’B’,’C’) group by 1” –null-string ‘\\N’ –null-non-string...

0

RaspberryPi

Basic Steps Increase swap partition $ less /etc/dphys-swapfile $ ll /var/swap -rw——— 1 root 100M Aug 20 06:58 /var/swap $ sudo dphys-swapfile swapoff $ sudo vi /etc/dphys-swapfile # add below line for 2GB swap partition CONF_SWAPSIZE=2048 $ sudo dphys-swapfile setup...

0

Extracting table and column names from SQL query

(Not original article) sql-metadata is a Python library that uses a tokenized query returned by python-sqlparse and generates query metadata. This metadata can return column and table names from your supplied SQL query. Here are a couple of example from the sql-metadata github readme:...

0

MacOS tips

Hide a user account in MacOS https://support.apple.com/en-us/HT203998 https://www.reddit.com/r/macsysadmin/comments/emxph7/catalina_create_a_hidden_user/ https://github.com/gregneagle/pycreateuserpkg Creating user account https://apple.stackexchange.com/questions/226073/how-do-i-create-user-accounts-from-the-terminal-in-mac-os-x-10-11 https://sterlingit.com.au/how-to-create-a-user-or-admin-user-in-osx-apple-mac-via-terminal-commands-in-9-simple-steps/ https://mackeeper.com/blog/post/356-using-various-types-of-user-accounts-on-mac/   Find files created or modified by an installer http://hints.macworld.com/article.php?story=20091223115101622   Take backup of startup entries I’d take a before and after snapshot to identify...

0

JMeter test plan automation

This automation script runs JMeter test plan with multiple input files specified by JMeter. It also has ability to send email before working on an input file and once the input file processing is complete. This is a working attempt...