Nando
LightNews LightNews
banner
nando.ac
Nando
@nando.ac
59 followers 61 following 38 posts
Ruby | Go | Elixir

I use Bsky as a repository for my scripts and articles about:

🔄 sidekiq.nando.ac
🐘 postgres.nando.ac
🚄 rails.nando.ac

📍Paris - France
Posts Replies Media Videos
nando.ac
Vietnam ❤️
Picture of a coffee shop in Vietnam
May 16, 2025 at 12:59 AM
nando.ac
#postgres
April 9, 2025 at 3:36 PM
nando.ac
Old trick for debugging outgoing requests in #Ruby. It's especially useful when you need to ensure that you're sending requests correctly to third parties by showing them the raw request structure.

#Rails
require 'net/http' module Net class HTTP alias_method :initialize_without_timeout, :initialize def self.enable_debug! # raise "You don't want to do this in anything but development mode!" unless Rails.env == 'development' class << self alias_method :__new__, :new def new(*args, &blk) instance = __new__(*args, &blk) instance.set_debug_output($stderr) instance end end end def self.disable_debug! class << self alias_method :new, :__new__ remove_method :__new__ end end end end Net::HTTP.enable_debug!
October 15, 2024 at 5:57 PM
nando.ac
Instead of locking #Ruby in both .ruby-version and the Gemfile, you can read .ruby-version directly in the Gemfile:

ruby file: ".ruby-version"

#Rails
October 12, 2024 at 3:19 PM
nando.ac
To debug a #Rails app in #Docker with #Pry, set stdin_open: true & tty: true in docker-compose.yml. Then, add binding.pry in your code and run docker attach to interact with Pry in the container. #Rails #Docker #Debugging
app: tty: true stdin_open: true
October 8, 2024 at 7:41 PM
nando.ac
Friday
October 4, 2024 at 5:21 PM
nando.ac
#Heroku glory days & #Postgres vs the world, w/ Craig Kerstiens

www.youtube.com/watch?v=HMJk...
Heroku's glory days & Postgres vs the world, w/ Craig Kerstiens
YouTube video by Aaron Francis
www.youtube.com
October 3, 2024 at 3:14 PM
nando.ac
The day I found an issue in the #Golang standard library.

github.com/golang/go/is...
Thos is a screenshot from a GitHub issue page under the repository golang/go. The issue is titled “encoding/json: unexpected json.Unmarshal behavior with maps” and was opened on October 17, 2015. It includes a discussion about the behavior of the json.Unmarshal function in Go when unmarshaling JSON objects into a map. The user ‘nsoufr’ initiated the issue and provided a description along with code examples illustrating how the unmarshaling behaves differently from what the Go documentation describes. They point out an inconsistency with the map being replaced by an empty map before key-value pairs are added, which doesn’t align with the documentation. The discussion in the comments section seems to revolve around clarifying this behavior and possibly updating the documentation to reflect what actually occurs in the code
September 25, 2024 at 11:20 AM
nando.ac
Zero-downtime #Postgres schema migrations need this: lock_timeout and retries

postgres.ai/blog/2021092...
Zero-downtime Postgres schema migrations need this: lock_timeout and retries | Postgres.AI
Deploying DB schema changes in heavily loaded systems is challenging. In this article, we explore one of the challenges - how to avoid situations when DDLs get blocked, wait to acquire a lock, and dur...
postgres.ai
September 23, 2024 at 10:32 PM
nando.ac
Trabalhei em uma empresa por 10 anos, lá era Principal Engineer. Agora, fui para uma empresa bem menor, bem no começo da jornada.

Acho que a melhor dica que eu poderia dar nesse caso é não ser um cara chato, que chega e aponta que tudo está errado e que nada funciona.

#CarreiraDev
#BolhaDev
September 10, 2024 at 5:46 PM
nando.ac
Counting how many items the queue has per #Sidekiq Job.
#ActiveJob #Rails
require 'sidekiq/api' queue_name = 'low' queue = Sidekiq::Queue.new(queue_name) queue.each_with_object(Hash.new(0)) do |item, memo| memo[item['wrapped']] += 1 puts memo end { "ArtifactIndexerJob" => 817, "FieldJob" => 183, "WebhookJob" => 19435, "EmbeddingsJob" => 122, "UpdaterJob" => 526280, "EventCacheWarmupJob" => 140 }
September 10, 2024 at 12:50 PM
nando.ac
This is how you build an image with credentials from a #1Password shared vault.

In this example, I'm passing the #Sidekiq private gem server credentials to be used on the image-building process for a #Rails application.

More info:
developer.1password.com/docs/cli/sec...
$ docker-compose build \ --build-arg CONTRIBSYS_GEM_SERVER_USERNAME=$(op read "op://Shared/Sidekiq Pro - Contribsys/username") \ --build-arg CONTRIBSYS_GEM_SERVER_PASSWORD=$(op read "op://Shared/Sidekiq Pro - Contribsys/password")
September 9, 2024 at 6:35 PM
nando.ac
How to Monitor and Fix #Postgres Database Locks in #Rails

pawelurbanek.com/rails-postgr...
How to Monitor and Fix PostgreSQL Database Locks in Rails
PostgreSQL database locks usually work seamlessly until they don't. Before your Rails app dataset and traffic reach a certain scale, you're unlikely to face any locks-related issues. But if your app s...
pawelurbanek.com
September 6, 2024 at 8:43 AM
nando.ac
Scaling #Rails & #Postgres to Millions of Users at Microsoft: Lessons & Takeaways

stepchange.work/blog/scaling...
Scaling Rails & Postgres to Millions of Users at Microsoft: Lessons & Takeaways – StepChange
Do you have a Rails app built on PostgreSQL and need to scale it to millions of users? In this interview, I speak with Andrew Atkinson, one of StepChange's expert consultants, who brings deep expertis...
stepchange.work
September 6, 2024 at 8:39 AM
nando.ac
Passing variables to the middle of URLs using #cURL
curl --request POST \ --variable studyId=$studyId \ --expand-url https://api.host.co/studies/{{studyId}}/candidates \ --header 'Accept: application/json' \ --header 'Content-Type: application/json' \ --header 'Authorization: Bearer xxxxxxx' \ --data @payload.json
September 6, 2024 at 8:37 AM
nando.ac
How to remove #Sidekiq jobs from retry set by class name:
set = Sidekiq::RetrySet.new items = set.each do |item| item.delete if item.klass == "MyHeavyJob" end; nil
September 5, 2024 at 9:58 PM
nando.ac
How to cut network round trip latency and improve enqueueing #performance in #Rails applications using #Sidekiq:

This is extremely useful, and you're processing things in batches.

More info:
github.com/sidekiq/side...

#BolhaDev
September 5, 2024 at 9:12 PM
nando.ac
This #Markdown tag helps you clearly describe #pull-requests when content is too large.


Vulnerabilities
.....Large content


#Github #BolhaDev
September 5, 2024 at 7:20 PM
nando.ac
For #macos users:

Easily access #iCloud files on the #terminal.

$ ln -s ~/Library/Mobile\ Documents/com~apple~CloudDocs/ ~/icloud

It creates a symlink from the hidden iCloud dir to the $HOME directory.
September 5, 2024 at 3:13 PM
nando.ac
This is how you export a #postgres query to a #csv using #psql

psql $DATABASE_URL -c "\copy (SELECT account_id, email, COUNT(*) AS duplicate_count FROM customers GROUP BY account_id, email HAVING COUNT(*) > 1) TO '.' WITH CSV HEADER;"
September 5, 2024 at 12:53 PM
nando.ac
How to identify slow queries on your Postgres database

SELECT
pid, now() - pg_stat_activity.query_start AS duration, query
FROM
pg_stat_activity
WHERE
(now() - pg_stat_activity.query_start) > interval '2 minutes' order by duration desc;

#postgres
September 5, 2024 at 12:48 PM