nplusp

// install dependencies
brew install ffmpeg
brew install gifsicle

// add alias
alias gify='function _gify(){ ffmpeg -i "$1" -pix_fmt rgb8 -r 10 /tmp/{1%.*}_tmp.gif && gifsicle -O3 /tmp/{1%.*}_tmp.gif -o "${1%.*}.gif"; rm /tmp/{1%.*}_tmp.gif; unset -f _gify; }; _gify'

// run it
gify /path/to/file.mp4

nplusp

class Application < Rails::Application
  # Initialize configuration defaults for originally generated Rails version.
  config.load_defaults 7.0
  
  # ensure that `update(files: [uploaded_file])` will append, not replace
  config.active_storage.replace_on_assign_to_many = false
end

nplusp

How to deploy a Rails 7.1 app with Postgres and Kamal on a single server

I think you have looked at the tutorial from Mr. Heinemeier Hansson at least once or twice and have a similar setup.

rails new kamal_pg --css tailwind --skip-test --database=postgresql

cd kamal_pg

nplusp

# delete local tag '12345'
git tag -d 12345
# delete remote tag '12345' (eg, GitHub version too)
git push origin :refs/tags/12345
# alternative approach
git push --delete origin tagName
git tag -d tagName

nplusp

brew install libpq

gem install pg -- --with-opt-dir="/usr/local/opt/libpq"

bundle config --local build.pg --with-opt-dir="/usr/local/opt/libpq"
bundle install

nplusp

Keybase proof

I hereby claim:

• I am nplusp on github.
• I am nplusp (https://keybase.io/nplusp) on keybase.
• I have a public key whose fingerprint is 15FB 8132 60B8 3D73 44BC B9CF 5869 568A B841 34B0

To claim this, I am signing this object:

nplusp

ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

nplusp

# 1) Create your private key (any password will do, we remove it below)

$ cd ~/.ssh
$ openssl genrsa -des3 -out server.orig.key 2048


# 2) Remove the password

$ openssl rsa -in server.orig.key -out server.key

nplusp

cat /etc/postgresql/9.6/main/postgresql.conf | grep log_min_duration_statement
#log_min_duration_statement = -1	# -1 is disabled, 0 logs all statements
log_min_duration_statement = 100

sudo tail -f /var/log/postgresql/postgresql-9.6-main.log

nplusp

checkout:
  post:
    # Work around some silly configuration added by Circle that doesn't actually even do what they want it to.
    - git config --global --unset url.ssh://[email protected]:.insteadof