clodal

Run each of the following lines, replacing yourdomain.com and codehere with your details:

now dns add yourdomain.com @ TXT google-site-verification=codehere // optional if domain already in GSuite
now dns add yourdomain.com @ MX ASPMX.L.GOOGLE.COM 1
now dns add yourdomain.com @ MX ALT1.ASPMX.L.GOOGLE.COM 5
now dns add yourdomain.com @ MX ALT2.ASPMX.L.GOOGLE.COM 5
now dns add yourdomain.com @ MX ALT3.ASPMX.L.GOOGLE.COM 10
now dns add yourdomain.com @ MX ALT4.ASPMX.L.GOOGLE.COM 10
now dns add yourdomain.com @ TXT "v=spf1 include:_spf.google.com ~all"

clodal

defaults write -g ApplePressAndHoldEnabled -bool false
defaults write -g KeyRepeat -int 1
defaults write -g InitialKeyRepeat -int 9

clodal

Backup external mongodb mongodump -h <SHARD_0>,<SHARD_1>,<SHARD_2> --ssl -u <DB_USER> -p <DB_PASSWORD>

Restore to local mongorestore -d --drop

clodal

How to setup AWS SES with Zeit Now

1. Domain Verification Record

now dns add <NAKED_DOMAIN> _amazonses TXT <VALUE>

2. DKIM Record Set

now dns add  ._domainkey CNAME 

clodal

Speed up MacOS Screen Recordings with FFMPEG

Pre-requisites:

1. MacOS

Instructions

1. Install ffmpg: brew install ffmpeg. If it fails, go to step 4.
2. Use ffmpeg to speed up .mov file: ffmpeg -i input.mov -vf "setpts=(PTS-STARTPTS)/30" -crf 18 output.mov
3. Done!

clodal

Logging with now cli

Find logs in a certain period (e.g.from 2am to 2.05am). Remember that times are in UTC. now logs --since 2018-08-28T02:00:00.000Z --until 2018-08-28T02:05:00.000Z

clodal

➜ prod git:(master) ✗ now logs https://prod-lmnssdtqy.now.sh/ -n 100000 2018-08-19T07:20:11.692Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5ead64528708004d570fd4") }, { fields: {} }) 2018-08-19T07:20:11.721Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5eb95f528708004d571036") }, { fields: {} }) 2018-08-19T07:20:11.748Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5ed47a528708004d571078") }, { fields: {} }) 2018-08-19T07:20:11.776Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5ed56f528708004d571079") }, { fields: {} }) 2018-08-19T07:20:11.803Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5ee267528708004d5710b0") }, { fields: {} }) 2018-08-19T07:20:11.831Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5ee86e528708004d5710ba") }, { fields: {} }) 2018-08-19T07:20:11.858Z Mongoose: answers.find({ state: 'approved', question: ObjectId("5b5ef2c1528708004d5710c7") }, { fields: {} })

clodal

Debug Notes for Sequelize + PG max connections issue

The following are commands useful for debugging pool connections in a sequelize + pg setup:

---

Connect to local psql shell psql -d <DB_NAME>

Connect to remote psql shell psql --host= --port=5432 --username= --dbname=

clodal

Issue

https://stackoverflow.com/questions/51664907/typeerror-stylesheet-getname-is-not-a-function-when-importing-components-from-n

Conclusion

Abort.

This is currently not possible/supported. Doing extraction of static styles is very hard, for example consider a function interpolation: https://stackoverflow.com/questions/44916599/how-can-i-opt-for-react-styled-components-to-generate-a-physical-css-file

clodal

How to drop RDS database?

1. Connect to remote psql shell psql --host=<DB_HOST> --port=5432 --username=<DB_USER> --dbname=postgres
2. Enter db password if prompted
3. DROP DATABASE <DB_NAME>;
4. CREATE DATABASE <DB_NAME>;

Note: This assumes AWS VPC does not block the connection. Check to ensure that you have access through this port.