I wanted to share an exercise I did that I found useful for refining my knowledge of SQL internal implementations and list comprehensions: GitHub - halostatue/sqltoy_elixir
This is an Elixir implementation of Joshua Weinberg’s SQLToy which is an exploration of how to implement the logic behind core SQL behaviours using in-memory data structures. I found it very useful for becoming more comfortable with Elixir list comprehensions as I implemented it (I implemented with Enum.reduce/3
and converted later to list comprehensions).
Be sure to read the upstream SQLToy Wiki when comparing the implementations.