dorian-marchal
Is there a way to prepend comments to SQL queries generated by Ecto?
I’d like to instrument my queries with Sqlcommenter in order to have more insights when I debug them.
For example:
SELECT * from USERS /*action='foo',
controller='bar'*/
I can’t find anything in the documentation, but I wonder if a workaround exists for that?
See:
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Error tracking, logs, APM, uptime and cron monitoring in one dev-friendly platform. Find and fix problems before your users notice.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #ai
- #elixirconf-us
- #blog-post
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #elixirconf-eu
- #metaprogramming
- #hex
Our Sponsors
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
**Building the future of software with AI, trust, and human connection.**
The deployment platform built for Elixir: PaaS ease, VPS control.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First Post!- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
gmile
Ability to “tag” queries using comments in Ecto would be quite convenient indeed
Most Liked
hubertlepicki
First thing to check would be if this is even possible. I am assuming you use PostgreSQL since you linked to CloudSQL for postgres, and Ecto uses “binary” protocol to talk to it:
And this differs from other clients in several ways, for example in the way that timestamps are returned (always UTC). Being a binary protocol, it may not support comments at all. You should probably check if you can add a comment to
MyApp.Repo.query!(...)and see if it even gets passed to PostgreSQL before you move any further.sbuttgereit
For PostgreSQL proper at least,
Repo.query(and friends) should work fine.I pass in some fairly gigantic
DOblocks which include PostgreSQL single line comments, multi-line comments, “dollar-sign quoting”, nested dollar-sign quoting, etc. into individualRepo.querycalls and I’ve had no issues.I would expect that anything “within reason” in this regard shouldn’t cause problems.