Phil Pirozhkov

Hey @djezzzl 👋 Thanks for giving it a shot. There's this deficiency with a redundant `lower` that needs to be fixed on the Rails side. At this stage I don't...

This is not actually about consistency of DB schema with ORM mapping, it's an alternative approach. It has its pros: - performance - integrity - race condition proofness) and cons,...

You're raising very good points. Let me take my time to respond in detail, and let's think how we can turn this idea into something actionable for `database_consistency`. > if...

I'm up to send a PR with a new checker that would detect `dependent: :delete`/`dependent: :delete_all`/`dependent: :nullify` and suggest changing FKs to use `on_delete: :cascade`/`on_delete: :nullify` instead. Is this a...

Hey guys! :wave: I've realized I've crossed an enum-related issue just recently. It only happens when `prepared_statements:` option is set to `false`. This is typical and [recommended by Rails when...

Filed https://github.com/djezzzl/database_consistency/issues/103 instead.

It feels that there needs to be two checks: 1. Check if there's a `case_sensitive: false` uniqueness validation on the model, and check if either the column type is `citext`...

Hey @djezzzl ! All good points. We should check non-unique indexes, too. According to the [latest Posrgres docs](https://www.postgresql.org/docs/current/citext.html), citext is not a panacea, and to specifically make both case-sensitive and...

This happened to me, and all I had to do is to exit all tmux sessions. Outside tmux sessions there were no issues, only inside tmux.

I guess it depends. ```ruby # good - related in groups def ready_to_rock? slept_well? && full? && in_good_mood? && turned_furnace_off? && turned_kettle_off? end # good - all unrelated def hero?...