Ecto → Raw SQL Have you ever wanted to chuck an ecto query into your sql tool of choice? Here’s a handy snippet that will output your ecto query into a state that you can directly copy/paste to sql. :all |> Ecto.Adapters.SQL.to_sql(Repo, <insert ecto query here>) |> Tuple.to_list() |> Enum.at(0) |> String.replace("\"", "") |> Kernel.<>(";") |> IO.inspect(label: "QUERY HERE") Example output: QUERY HERE: "SELECT l2.id, d4.geo_point, d4.zip_code FROM ….. WHERE (d4.

If you have written Elixir with me, or have been subjected to one of my pull request reviews, you’ll know that one of my favorite ways to refactor code is by adding the capture operator when an anonymous function is required. What is the capture operator? Well, you may know it as the ampersand or “&” character, but when writing Elixir it takes on a special meaning. The capture operator ("&") gives us the ability to create an anonymous function with shorthand syntactic sugar.

There are a lot of things that I love about my job. As a software engineer for Cars.com, I get to work on cool problems with great people on an awesome tech stack. One of the best parts of our tech stack is our heavy reliance on open source software. We rely on a myriad of different technologies that leverage software that is written to be shared, free of charge, with the outside world.

Often I have encountered developers who use source control as a part of their daily workflow that are intimidated by git. This seems especially true when a rebase goes south, or really anything occurs that deviates from the normal git behavior. I recognize this intimidation, because it is one that I myself suffered from. However, one of the greatest gifts I received when I first started working as a software professional was a crash course from a senior developer on the use of the reflog.

Viewing debug text while running a server can be challenging. This holds true while running a Phoenix server. Thankfully there is a fantastic module included with the Elixir standard library. IO.ANSI provides an easy way to inject colors into your terminal text. As server output text flies across your terminal, being able to color not only debug text, but the background of the text as well is extremely helpful. You can quickly play with this functionality in iex.