Salman Mahmud salmanx

PSQL

Magic words:

psql -U postgres

If run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).

Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*

$ docker

Add gem 'rails_12factor' to your Gemfile. This will add error logging and the ability for your app to serve static assets.
bundle
Run RAILS_ENV=production rake db:create db:migrate db:seed
Run rake secret and copy the output
From the command line: export SECRET_KEY_BASE=output-of-rake-secret
To precompile your assets, run rake assets:precompile. This will create a folder public/assets that contains all of your assets.
Run RAILS_ENV=production rails s and you should see your app.

Remember to clobber your assets (rake assets:clobber) and re-precompile (rake assets:precompile) if you make changes.

Optional - Set format on save and any global prettier options

npm i -D eslint prettier eslint-plugin-prettier eslint-config-prettier eslint-plugin-node eslint-config-node

show dbs

	var OFF = 0, WARN = 1, ERROR = 2;

	module.exports = exports = {
	"env": {
	"es6": true
	},

	"ecmaFeatures": {
	// env=es6 doesn't include modules, which we are using
	"modules": true

	### DigitalOcean Ubuntu 18.04 x64 + Rails 5 + Nginx + Unicorn + PostgreSQL9.6 + Capistrano 3

	SSH into Root

	$ ssh root@123.123.123.123

	Change Root Password

	$ passwd