PG::ReadOnlySqlTransaction: ERROR: cannot execute SELECT in a read-only transaction

[bts (Brendan Schlagel)]

I haven’t used it yet but if for running direct SQL queries I believe this is what you’re looking for! —

New official direct SQL access API for Discourse (mini_sql)

I just finished “officializing” and “extracting” our direct DB access helpers in Discourse. I would like to cover what was done and what this means to plugin authors and core contributors. From the very first version of Discourse, @eviltrout introduced some helpers internally for safely executing direct SQL in Discourse. It looked like this. ActiveRecord::Base.exec_sql("select * from topics where id = :id", id: 1) # or Topic.exec_sql("select * from topics where id = :id", id: 1) This is a p…