Andrew Atkinson

@peterc I think this has been a problem forever in open-uri. Do you have a recommendation for what to do here? I tried adding this gem that monkey patches open-uri...

Ok. I'll mess around with the user-agent and try out a separate HTTP library. Thanks for the ideas!

Hi @bensheldon I've installed PgHero a handful of times and mucked around a bit in the source code. Can you link up the demo app and just to clarify, are...

Speculating here @fatkodima @eileencodes, but I see the database name and role name are included in the message, so I was thinking about errors for those. Would it mainly be...

Ah thanks, I didn't read through the linked issue. In general I often find StatementInvalid is very broad and am interested in more specific errors for things like constraint violations...

I was searching PRs labeled PostgreSQL and noticed that tag wasn't on this PR, and isn't getting much use in general. Can that tag be added to this PR? Can...

@seanlinsley At work we have a fairly large Rails 6.1 codebase (~100K LOC) and use PostgreSQL, PGSS, PgHero, and I advocate for more usage of it. Commonly we have these...

Crunchy Data also has an example comparing IN with ANY: > From the definitions, expression IN (...) is equivalent to expression = ANY (...) but for the parameter type! https://www.crunchydata.com/blog/postgres-query-boost-using-any-instead-of-in...

@seanlinsley Would you need to update https://github.com/rails/rails/blob/main/activerecord/lib/arel/visitors/to_sql.rb#L338 to handle the `ANY` keyword?

In case it's useful, I wanted to add one report of running the provided benchmark. I copied the contents of the benchmark above into `any_benchmark.rb` in the `bug_report_templates` directory, checked...