This Week's Trending
This Month's Trending
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
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
This Year's Trending
Lets say i have map like this fetching from my database
%{"_id" => #BSON.ObjectId<58eb1a7a9ad169198c3dXXXX>, "email" => "XX...
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
From another thread - making it a separate topic:
To make sure I understand correctly (because TFM seems ambiguous on this to me):
Wh...
New
WELL HOWDY Y’ALL!
Is it possible to replicate this query in Ecto?
SELECT unnest(ARRAY[5,10,15,20]) AS my_desired_column UNION ALL
SELE...
New
I have a schema that contains an embedded schema, which I would like to rename a field on. For example:
schema "menu_items" do
field...
New
If you provide a string to an :integer field you get
errors: [count: {"is invalid", [type: :integer, validation: :cast]}]
in a changese...
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
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
Working my way through the Phoenix in Action book at chapter 7.5.3, and I’m getting the following error:
iex(1)> Auction.list_items()...
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:
Sub Categories:
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.
Develop your skills with books, videos, and courses.
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!"