How to use EXPLAIN ANALYZE in Rails 6

Category: Ruby :: Published at: 06.07.2025

As you might now, Rails 7 allows us to use explain with parameters.

From now on, we can use it for example with analyze: true flag, which gives us much more information about the query.

In Rails this option is not available, but we can use some tricks to show the result simply.

Read more

How CSRF Tokens work in Ruby on Rails?

Category: Ruby :: Published at: 16.12.2024

All modern frameworks offer protection against CSRF attacks, so these attacks are not as common anymore.
However, this does not mean we don't need to understand what they are and how to protect ourselves from them.

In this article, I will explain what a Rails engineer needs to know about CSRF.

Read more

How to reinstall MySQL on MacOS ARM M1 (and not only)

Category: SQL :: Published at: 09.12.2024

If you have any issues with MySQL and want to completely reinstall it on your machine,

This is a quick guide on how to do it:

Read more

How to easily connect your docker container with a postgres on EC2 instance

Category: Ruby :: Published at: 11.10.2024

Let's say you have a Rails app packed inside a docker container. You also have a pg server installed directly on your virtual machine (well, just to save your money). This can be a problem because on production, you should allow only specific IPs to have a connection to your database.

How can you do it then? This is a tutorial.

Read more

How to renew SSL certificates with Certbot

Category: Ruby :: Published at: 29.09.2024

If you are using Amazon Linux 2 and want to install SSL Certificate for your domains, certbot is a right call.

This is how you can do it, and also additional info about how you can renew existing certificate

Read more

Problem with NGINX - Unprocessable entity localhost

Category: Engineering Insights :: Published at: 09.06.2024

When you try to run application, for example on Amazon Linux server, and trying to connect it
with a domain with the use of NGINX you can encounter some problematic issue.

You're starting server but, and it works, but when you try to make POST request, you're getting 422 Unprocessable Entity error.

This is because your application is still sending localhost Header, an this is not recognized by the app.

To fix this you need to modify your NGINX configuration

Read more