inouire

Pick a date, pick a branch, here you go

git checkout `git rev-list -n 1 --first-parent --before="2019-07-27 13:37" master`

inouire

List all tables referencing a target table using a foreign key

SELECT tc.table_schema, tc.constraint_name, tc.table_name, kcu.column_name, ccu.table_name
AS foreign_table_name, ccu.column_name AS foreign_column_name
FROM information_schema.table_constraints tc
JOIN information_schema.key_column_usage kcu ON tc.constraint_name = kcu.constraint_name
JOIN information_schema.constraint_column_usage ccu ON ccu.constraint_name = tc.constraint_name
WHERE constraint_type = 'FOREIGN KEY'
AND ccu.table_name='name_of_your_target_table_here'

inouire

Ruby heap size rules of thumb

GC.stat[:heap_live_slots]

• <1 million = don't sweat it
• 1mil->3mil = Pretty average
• 3mil->5mil = Typical of Big Chonker Monoliths
• 5mil->10mil = Something probably wrong, fix to reduce RSS usage + speed up your GCs

inouire

# config/initializers/i18n.rb

require 'i18n'

# Configure it as you want
I18n.load_path      = Dir["config/locales/**.yml"]
I18n.enforce_available_locales = true
I18n.default_locale = "en"
I18n.backend.load_translations

inouire

<?php

namespace MetarDecoder\Service;

use MetarDecoder\Exception\DatasetLoadingException;

class DatasetProvider
{
    private $base_dir;