Today I stumbled across a pretty harmless-looking query in our application which turned out to be pretty harmful and...

makandra dev

All browsers implement an event named beforeunload. It is fired when the active window is closed and can be used...

I recently noticed a new kind of flaky tests on the slow free tier GitHub Action runners: Integration tests were...

makandra dev

Usually our code lives on GitLab, therefore our documentation for CI testing is extensive in this environment. If you are...

Sometimes you have a file that is related to a project, while not actually being part of it. You'd...

A Rails script lives in lib/scripts and is run with bin/rails runner lib/scripts/.... They are a simple tool to perform...

I, [2024-01-21T06:22:17.484221 #2698200] INFO -- : [4cdad7a4-8617-4bc9-84e9-c40364eea2e4] test

github.com

There are a few tools to combat the dreaded n+1 queries. The bullet gem notifies you of missing eager...

unpoly.com

Version 3.7.0 broke some things in complex forms. Sorry for that. Concurrent user input is hard. 3.7.1 This change fixes...

edgeapi.rubyonrails.org

The linked article suggests an interesting way to speed up tests of Rails + Postgres apps: PostgreSQL allows the creation of...

You can use pg_repack to do a VACUUM FULL without holding an exclusive lock during processing. There is still...

makandracards.com

A general overview about why and how we migrate can be found under Migrating from Elasticsearch to Opensearch

In Capistrano 3, your Capfile requires 'capistrano/rails/migrations', which brings two Capistrano tasks: deploy:migrate and deploy:migrating. The former checks...

#pluck is commonly used as a performant way to retain single database values from an ActiveRecord::Relation Book.pluck(:title, :price...

If you ever need to restore exact records from one database to another, Marshal might come in handy. Marshal.dump is...

docs.ruby-lang.org

The sprintf method has a reference by name format option: sprintf("% d : % f", { :foo => 1, :bar => 2 }) # => 1 : 2.000000

Creating Nagios Config with puppet Let's have a look at the classic way of managing Nagios configuration with exported...

stackoverflow.com

For some reason you have to pass the password hash if you want to create a role in postgres. To...

While upgrading CarrierWave from version 0.11.x to 3.x, we encountered some very nasty fails. Below are the basic...

TLDR Using .includes or .eager_load with 1-n associations is dangerous. Always use .preload instead. Consider the following ActiveRecord...

Given you have an array column like this: create_table "users", force: :cascade do |t| t.integer "movie_ids", default: [], array...

rfc-editor.org

Legt man im DNS beispielsweise einen CNAME-Eintrag an, sollte das Ziel am Ende einen Punkt haben, also z.b. d31337.cloudfront.net...

It's not possible to change the bwlimit of Proxmox storages via the Web-UI (at least in Proxmox 7...

The recommended additional setup of the spreewald gem, a useful set of cucumber steps, includes adding a file for defining...