ferrao

# Encrypt files, not caching password
gpg -c --no-symkey-cache file.txt

# decrypt files, not caching password
gpg --no-symkey-cache file.txt.gpg

ferrao

### Keybase proof

I hereby claim:

  * I am ferrao on github.
  * I am ruiferrao (https://keybase.io/ruiferrao) on keybase.
  * I have a public key whose fingerprint is 6AB8 59DC 20D4 1D18 FCF8  C6DE 42E7 636B CF77 1773

To claim this, I am signing this object:

ferrao

Optimizing postgresql table for more than 100K inserts per second

• Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
• Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth on useless vacuuming of the table (since we never DELETE or UPDATE the table).
• Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
• Minimize the number of indexes in the table, since they slow down inserts. Usually an index on time timestamp with time zone is enough.
• Add synchronous_commit = off to postgresql.conf.
• Use table inheritance for fast removal of old data:

ferrao

Update fork from upstream

git fetch upstream master
git merge upstream/master

Deploy from branch

Overwrite local staging branch (tracking upstream) with master(upstream fork) :

ferrao

AWS IAM

aws iam create-user --profile <aws-cli-profile> --user-name <username> 
aws iam create-login-profile --profile <aws-cli-profile> --user-name <username> --password '<password>'
aws iam delete-login-profile --profile >aws-cli-profile> --user <username>

ferrao

AWS RDS - Postgres 11

Recreate Database

\c postgres
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'postgres'
  AND pid <> pg_backend_pid();
\c template1;

ferrao

# https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ec2-key-pairs.html#verify-key-pair-fingerprints

openssl rsa -in ~/.ssh/privatekey -pubout -outform DER | openssl md5 -c
openssl pkcs8 -in path_to_private_key -inform PEM -outform DER -topk8 -nocrypt | openssl sha1 -c

ferrao

Arch Linux 2019.02.01-x86_64 on the Thinkpad X230

Documenting all my install steps

Useful Links

• https://www.reddit.com/r/linux/comments/37uoya/easiest_way_to_move_complete_linux_install_from/
• https://wiki.archlinux.org/index.php/Lenovo_ThinkPad_X230
• http://www.thinkwiki.org/wiki/Category:X230
• https://bbs.archlinux.org/viewtopic.php?pid=1393759#p1393759
• https://www.digitalocean.com/community/tutorials/understanding-systemd-units-and-unit-files
• https://raw.githubusercontent.com/windelicato/dotfiles/master/why_bspwm.gif

ferrao

title_page:
  logo_image: image:logo.png[]
page:
  layout: portrait
  margin: [3.2cm, 2cm, 2.2cm, 2cm]
  size: A4
base:
  font_color: #333333
  font_family: Helvetica
  font_size: 12

ferrao

#!/usr/bin/ruby
# Create display override file to force Mac OS X to use RGB mode for Display
# see http://embdev.net/topic/284710

require 'base64'

data=`ioreg -l -d0 -w 0 -r -c AppleDisplay`

edids=data.scan(/IODisplayEDID.*?<([a-z0-9]+)>/i).flatten
vendorids=data.scan(/DisplayVendorID.*?([0-9]+)/i).flatten