Hacker News Reader

Take a look at Ecto (kind-of-orm for elixir), didn't even hear about anything comparable for other languages (which is sad)

* No impicit N+1 and stuff like that (elixir is functional with immutable variables)

* Whole "orm" is really fast, thanks to macros (compile-time metaprogramming)

* Can express very complex queries, allowing raw sql then necessary

https://hexdocs.pm/ecto/Ecto.html

View on HN

I agree, Ecto is a great.

Ive always appreciated ORMs, but disliked how people tend to forget about the database behind them.

Ecto gives you a lot of power and flexibility, and its very easy to remember there is SQL behind there.

Compose-able queries are awesome.

Schemaless queries are awesome.

Not tying your "model" or "context" directly to a table or letting it be a portion of a table is awesome.

Backing "validations" with database constraints is awesome.

That Ecto team kills it.

Not just allowing raw SQL - allowing raw SQL fragments in your code, mixed in with regular ORM usage! Turn those fragments into a function and you have nicely reusable components with which to build advanced queries.

Reply on news.ycombinator.com