Latest #ecto Threads 
terminusdb_ex is an Elixir client for TerminusDB, designed to make working with documents, schemas, graphs, and queries feel natural on t...
New
SuperAPI will be hosting the Melbourne Elixir meetup this Thursday, July 2nd. The event will be held at Level 9, 505 Little Collins Stree...
New
Hi everyone,
I’m available immediately for short-term Elixir/Phoenix contract work, especially technical debt remediation, production de...
New
Tired of waiting for slow Ecto sandbox tests ?
At work, we have 45,000 tests - taking 12 minutes on a fast laptop and ~45 minutes of ela...
New
Episode 307 of Thinking Elixir. Mark shares a bittersweet housekeeping update. The Thinking Elixir Podcast is winding down, with the fina...
New
This is how I currently use binary IDs in my Phoenix apps.
Generate the app:
mix phx.new path/to/app --binary-id
Configure Ecto and mi...
New
Hey, I know this has been discussed ad nauseum, but I couldn’t find a definitive answer or at least some consensus around this, so let me...
New
Introducing LiveFilter: Composable, URL-driven filtering for Phoenix LiveView with Linear/Notion-style UI filters and PostgREST-compatibl...
New
Environment
Elixir 1.18.3-otp-27 / OTP 27.3.4
Oban 2.20.2
Phoenix 1.7.x
db_connection 2.8.1 / Postgrex 0.21.1
Infrastructure: Google Cl...
New
How do y’all handle multiple changes without using multiple database requests. This is something I came up with but I am wondering if the...
New
This Week's Trending
terminusdb_ex is an Elixir client for TerminusDB, designed to make working with documents, schemas, graphs, and queries feel natural on t...
New
SuperAPI will be hosting the Melbourne Elixir meetup this Thursday, July 2nd. The event will be held at Level 9, 505 Little Collins Stree...
New
This Month's Trending
Flop is an Elixir library that applies filtering, ordering and pagination parameters to your Ecto queries.
offset-based pagination with...
New
Torus is a plug-and-play Elixir library that seamlessly integrates PostgreSQL’s search into Ecto, streamlining the construction of advanc...
New
Finally, after several months of work, 480+ commits, and nearly 190 PRs, I’m proud to announce the first release of Aurora UIX:
Aurora U...
New
Hey, I know this has been discussed ad nauseum, but I couldn’t find a definitive answer or at least some consensus around this, so let me...
New
Episode 307 of Thinking Elixir. Mark shares a bittersweet housekeeping update. The Thinking Elixir Podcast is winding down, with the fina...
New
This is how I currently use binary IDs in my Phoenix apps.
Generate the app:
mix phx.new path/to/app --binary-id
Configure Ecto and mi...
New
Tired of waiting for slow Ecto sandbox tests ?
At work, we have 45,000 tests - taking 12 minutes on a fast laptop and ~45 minutes of ela...
New
Hi everyone,
I’m available immediately for short-term Elixir/Phoenix contract work, especially technical debt remediation, production de...
New
This Year's Trending
Lets say i have map like this fetching from my database
%{"_id" => #BSON.ObjectId<58eb1a7a9ad169198c3dXXXX>, "email" => "XX...
New
Hello!
tl;dr Announcing Oban, an Ecto based job processing library with a focus on reliability and historical observability.
After spen...
New
Hello guys,
I have finally made it. I created an admin interface for a framework. It’s been on my todo list for years and with the curre...
New
Hey guys! I have an Album module with an Ecto schema. The schema has a cover_url virtual field that depends on the cover column to return...
New
My dev environment is my MacBook and my prod environment is on Fly with a Postgres database I have configured via Fly.io.
I cannot run m...
New
I have a situation similar to create and insert 2 associated models.
In my case User has_many Others and Others belongs_to User.
I want...
New
Hi,
Trying to make :utc_datetime the global default for Ecto schemas and migrations in our app, and use timestamptz as default datetime ...
New
I’ve recently started a new Phoenix project using Elixir 1.11, Phoenix 1.5 and Ecto 3.5.
Everything runs smoothly but there is a recurre...
New
Given a list of structs based on a schema
[ %App.Car{model: “E”}, %App.Car{model: “X”}, %App.Car{model: “Y”} ]
Is there no way to ins...
New
Hello people!
I have a requirement to perform a select query with IN clause using tuples. I am using PostgreSQL. Example:
select * from...
New
I couldn’t find an option in the Repo.update function that would skip setting updated_at. Is there a way?
New
If I want to get the first error message from Ecto.Changeset, here’s what I have to do:
error_msg = changeset.errors
|> hd()
...
New
Hi,
I’m trying to set up client SSL validation with Google Cloud SQL, and things are not going well for multiple reasons.
First off, I ...
New
Hello :wave:
I published a library that brings support for polymorphic/dynamic embeds in Ecto.
Ecto’s embeds_one macro requires a speci...
New
I think I’ve tried 5 different graph database libraries in the last two days and not a single one has been able to connect to a remote/lo...
New
Last Three Year's Trending
Hi all,
I've just started learning Elixir and Phoenix Framework, so please pardon my n00bness at this stage.
I'm trying to use Postg...
New
Okay, I'm having a heck of a time trying to figure out how to best handle the validation of belongs_to associations in Ecto. I'm sure I'...
New
What is the way to convert
[ %{id: 7, name: "A", count: 1}, %{id: 8, name: "B", count: 1}, %{id: 9, name: "C", count: 0} ]
to
[ ...
New
I’ve been experiencing a bit of timeout in production with respect to my queries. I’ve going through the docs and a few resources here, I...
New
I seems like sqlite is kind of a no-go in phoenixworld - why is this the case? Certainly for development or smaller apps sqlite does very...
New
Hi,
Repo.insert, Repo.update and Repo.delete all return {:ok, resource} or {:error, changeset}.
But Repo.get and Repo.get_by return res...
New
I’m currently using a model button that referended is to another list of objects called items
When I make a POST call to the service it ...
New
I am trying to use where exists (), which requires a fragment in ecto. I need to use a different table name for the subquery in different...
New
I have an Entry with a many-to-many relationship to Tag. Like so:
defmodule Tag do
...
schema "tags" do
field :name, :string
...
New
There is a nice table showing the available data types used in Ecto Schemas: https://hexdocs.pm/ecto/Ecto.Schema.html#module-primitive-ty...
New
Recently we partitioned a table with 28 million rows by its ULID to improve query speeds and reduce query timeouts. To do this I ended up...
New
Hi everyone,
I finally had a bit of time to followup on this post: Best way to handle associations in single html form
In my previous p...
New
There are unique fields in the User table which can cause conflicts. So we introuduced the on_conflict: :nothing.
Repo.insert_all(
Use...
New
The new(ish) project that I’m working on started with Ecto 2 so I had access to many_to_many, however I had issues actually using it so I...
New
According to the stock example cited in elixir Ecto 3.4.6 docs …
post = MyRepo.get!(Post, 42)
post = Ecto.Changeset.change post, title: ...
New
Trending Over Three Years
After calling mix ecto.create I get this error:
17:00:32.162 [error] GenServer #PID<0.412.0> terminating
** (Postgrex.Error) FATAL...
New
I am using Ecto timestamps with postgres, I can see the timestamps() use the :naive_dateime but for my use case I wanted to store the ti...
New
Hi,
I have to write a raw query for one of my project. But till now I have used ecto queries and don’t have much experience writing raw ...
New
Hi there,
I am working with Ecto-Postgresql and I need to call all of the records from a specific table but the table has 40,000 record...
New
Hi, I have the following ecto query: post_query = from p in Post, where: p.id == ^id, join: c in assoc(p, :comments), join: u in assoc(c,...
New
Good day to you all.
I have been struggling to get a query involving like and ilike to work.
Can anyone assist me on this, please?
pro...
New
Forgive me if this is obvious, but how does one delete a database record WITHOUT selecting it first? https://hexdocs.pm/ecto/Ecto.Repo.h...
New
In templates/appointment/index.html.eex:
<%= for appointment <- @appointments do %>
<tr>
<td><%= appoi...
New
Is there a way to rollback a specific migration and only that one ("skipping" all the other ones)?
Would
mix ecto.rollback -v 2008090...
New
I want to create a simple application (But one that is not tightly coupled with Phoenix). One of the things I am considering, is whether ...
New
** (DBConnection.ConnectionError) connection not available and request was dropped from queue after 2733ms. You can configure how long re...
New
Hello, I get Persian date from my client and convert it to normal calendar like this:
def jalali_string_to_miladi_english_number(persi...
New
I have a User schema with a :from_id field set to type :string:
defmodule TweetBot.Repo.Migrations.CreateUsers do
use Ecto.Migration
...
New
Hi all,
Trying to get some more clarity over utc_datetime and naive_datetime for Ecto:
https://hexdocs.pm/ecto/Ecto.Schema.html#module-...
New
I’m working on defining a simple Ecto schema for a table (in PostGres), but I don’t see where I can define a column as NOT NULL. Conside...
New
Latest on Elixir Forum
Get money off!
The Pragmatic Bookshelf
35% off any eBook
Manning Publications
45% off any item
ElixirCasts
10% off for life
The Pragmatic Studio
20% off any course
AppSignal
10% off for 12 months
Honeybadger
10% off for 12 months
Simply use coupon code "devtalk.com" or "elixirforum" at checkout!
Filter by Type:
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #exunit
- #elixirconf
- #discussion
- #javascript
- #podcasts
- #code-sync
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #api
- #processes
- #forms
- #metaprogramming
- #security
- #performance
- #hex
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"