Tag: heroku

  • Let’s encrypt (il buono), rails (il brutto) and heroku (il cattivo)

    This article is just paraphrasing this one with a bit more accuracy, corrections and cynicism. First step: Update your rails code on heroku The route /.well-known/acme-challenge/KEY  should be added to your config/routes.rb  file like so get ‘/.well-known/acme-challenge/:id’ => ‘CONTROLLER#letsencrypt’ where CONTROLLER  is the controller of your choice, in which the method should look like this  def letsencrypt…

  • Slow Query with “LIMIT 1” in Postgresql

    Recently I had issues on a production database running slow on tables with more than 1M rows. This is a complex Ruby on Rails app connected to a Postgresql database, I went through the whole stack to figure out that it’s a simple index problem. Very few or no related doc was found about this…