Unpopular request. I am up to replace Ecto (at least, the query part) with queries generated out of pure SQL. What are my options?

This page summarizes the projects mentioned and recommended in the original post on /r/elixir

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • yesql

    An Elixir library for using SQL. (by lpil)

  • sqlc

    Generate type-safe code from SQL

  • I've realized that for me, the option to simply laying out my thoughts in SQL and using a generator to turn those into functions is the better way to go. In my Go projects, I am using sqlc, but I am yet to find a suitable alternative for Elixir. My quick research showed me these two options:

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • ayesql

    Library for using raw SQL in Elixir

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts