PG::ReadOnlySqlTransaction: ERREUR: impossible d'exécuter SELECT dans une transaction en lecture seule

[bts (Brendan Schlagel)]

Je ne l’ai pas encore utilisé, mais si vous cherchez à exécuter des requêtes SQL directes, je pense que c’est ce qu’il vous faut ! —

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…