ElixirStatus offers insights into Elixir programming language, OTP framework, and functional programming principles, providing articles, tutorials, and community updates for Elixir enthusiasts. By exploring ElixirStatus's curated content, developers can learn about concurrency primitives, fault-tolerance mechanisms, and metaprogramming techniques for building scalable and fault-tolerant distributed systems. Whether you're a backend developer, system architect, or Erlang/Elixir enthusiast, ElixirStatus offers resources to deepen your understanding of Elixir and Erlang ecosystem and contribute to the vibrant community of Elixir developers.

ElixirStatus

Explores an alternative approach to database access that embraces raw SQL instead of abstracting it away with ORMs. Introduces Squirrel, a library for Gleam that uses code generation from SQL queries to provide type-safety and good developer experience without sacrificing performance. Demonstrates how developers can write plain SQL while maintaining the benefits of static typing in functional languages, avoiding common ORM pitfalls like N+1 query problems.

You Don't Need an ORM

Welcome to ScopeSpace, a dedicated space to collaborate, share knowledge, and discuss topics that matter to us!

scopespace

Disagreed. ORM’s are fine to use for simple, repetitive queries. Raw queries know their place as well. Like anything in programming tools and languages, the answer is not black or white.

Generating type-safe code from raw SQL is so much better than ORMs. It’s better for performance and resources, easier to debug, and it “forces” the dev to actually learn the language the database uses.

Here’s a counterpoint. Use store procedures. Then use something like <a href="http://ADO.NET" target="_blank" rel="noopener nofollow">ADO.NET</a> or its equivalent for your language and make your own simple DAL where all you do is make the queries. It’s my favourite approach.
It does not work always. I could write plenty of cases where it does not work, because you require flexibility, but it’s great when it does though.
What I’m saying… you don’t need an ORM, sometimes. You can build your own ORM in the DAL.

Great Article. Not everything has to be an Object.