ExTutor

Interactive Elixir learning platform for practicing data transformations and Ecto queries against a sandboxed in-memory SQLite database.

Features

• Data Reshaping - Practice Enum, Map, and functional transformations
• Ecto Practice - Write real Ecto queries against a sandbox database
  • Basic CRUD (Repo.all, Repo.get, Repo.insert)
  • Query building with where, order_by, select
  • Joins (inner, left, multi-table)
  • Aggregations and group_by
  • Subqueries and nested queries
  • Preloading associations
  • Upserts with conflict handling

Setup

mix setup

Development

mix phx.server

Visit localhost:4000

Available Schemas (Ecto Practice)

Schema	Fields
User	id, name, email, age, status
Post	id, title, user_id
Comment	id, body, user_id, post_id
Order	id, total, status, user_id

Difficulty Levels

• Easy - Basic queries: fetch all, get by id, insert, count, select fields
• Medium - Filtering, ordering, preloads, updates, aggregations
• Hard - Joins, subqueries, multi-table operations, upserts