Finding and killing long running queries on PostgreSQL

From time to time we need to investigate if there is any query running indefinitely on our PostgreSQL database.

These long running queries may interfere on the overall database performance and probably they are…

Unique partial indexes with PostgreSQL

How to use unique partial indexes to avoid conditional duplication

When you need to deal with concurrency and unique records databases are your friend. Unique indexes are the best way to avoid data inconsistence and duplication.

Time difference in Ruby on Rails

How many minutes has passed since the beginning of this job? How many hours do we have to wait? If you’ve asked these kind of questions while programming on Ruby on Rails you’ll probably get no answer on Rails docs. But there is a solution.

Using helper methods inside your controllers

Have you ever needed to use a helper method inside your controller? I did, a few…

The Postgres RETURNING clause

How to return data related to updated rows.

The problem

Here is my situation. I have a products table and each product needs to be approved by someone.

The initial solution

Writing Command APIs in Ruby — Part 1

How to setup a new command application

How to compare version strings in Ruby

Sometimes you need to support different versions of an API inside your ruby code. And, sometime, you will need to compare version strings in order to make a feature available.

Time range operations with Rails

Returning basic time ranges using ActiveSupport methods.

How many times you needed to return a specific time range in order to use it on a query?

Crystal, TDD and Conway’s Game of Life.

How I learned a new programming language having fun and using tests.