This Week's Trending
This Month's Trending
This Year's Trending
When running my tests, I sometimes see an error that looks like
[error] Postgrex.Protocol (#PID<0.788.0>) disconnected: ** (DBConn...
New
So I have been stuck for a alot of time tryi g to figure out how to get a vector db for parge vectors that can do KNN. Its suprisingly co...
New
Ok this is… more than weird
It’s also consistent during insert_all with conflicts. I’m trying to back fill some missing data from bac...
New
I need to communicate to an existing database. I would like to have a schema for the table that I will query. Do I need to create the sch...
New
Is there any way to do SQL type inference/value casting when I have a raw SQL statement without having access to the underlying Ecto sche...
New
Besides (over)logging every code-path leading to Repo.insert_all, is it possible to make Postgrex and/or ecto_sql log the exact, failing ...
New
Last Three Year's Trending
Hi all! First time posting, let me know if I can structure my question better.
I am using Ecto migrations on a project and need to add c...
New
I have raised an issue at ecto_sql issue_link
Adding it here to reach out to larger community.
I have updated my ecto_sql_3.0 to ecto_s...
New
How can I achieve such query in Ecto?
postgres=> SELECT * FROM (VALUES (1,2,3,4), (5,6,7,8)) AS foo (a,b,c,d);
a | b | c | d
---+--...
New
I need some help to understand writing test for async function
For example I have a function
def send_notification({:ok, nessage}, to, ...
New
According to page https://hexdocs.pm/ecto/getting-started.html:
NOTE: Your PostgreSQL database may be setup to
not require a username ...
New
Hi everyone :wave:, I know there’s a lot of other questions and discussions about this subject, but most of them were asked a long time a...
New
I’m working on debugging a TransactionRetryWithProtoRefreshError error that comes up from time to time on an app using CockroachDB. The ...
New
Hello community! I’m starting to implement an all-in-one library/SDK for Supabase services for Elixir and the roadmap can be seen on the ...
New
Is there a way to stream data TO the database with Ecto? I’m working on using the COPY command to load CSV data directly into Postgres.
...
New
I am trying to code a bank transfer service using Elixir/Erlang, Postgrex and PostgreSQL.
Erlang v 26
Elixir v 1.16.0
Postgrex v 0.17....
New
I’m getting an query error when attempting to apply a conflict strategy here at line 38: progress_track.ex · GitHub
The idea is that if ...
New
I use Repo.insert_all to bulk insert ~100m rows in chunks. After each chunk, some outdated data based on the insert’s RETURNING is delete...
New
With ecto_sql version 3.10.2 (for MySQL), the following code:
Repo.transaction(fn ->
Repo.query!("SET TRANSACTION ISOLATION LEVEL R...
New
Hey!
My team and I are migrating away from Mariaex and Ecto 2 to Ecto 3 and myxql.
We have all the main changes done and everything is ...
New
Why does removing on: true from a keyword query result in a warning?
missing :on in join, defaulting to on: true.
The :on option is d...
New
Trending Over Three Years
Hello everyone, I was working on a project and was faced with this problem and I’d like some input from you on the subject. Imagine this ...
New
Hello,
When one is within the Mix context it’s possible to run
$ mix run priv/repo/seeds.exs
Which will evaluate code like the followi...
New
{:ecto_sql, "~> 3.4"},
{:phoenix, "~> 1.5.8"},
{:phoenix_ecto, "~> 4.1"},
{:myxql, "~> 0.4.0"},
Currently ...
New
Hi everybody,
Edit for TL;DR:
How I can use SQL array_agg aggregate function with an Ecto fragment.
Particularly how I can nest the se...
New
I’ve noticed recently that the idle time for my queries is creeping up over 1k ms.
[debug] QUERY OK source="chats" db=0.8ms idle=1272.7m...
New
Hi,
We are using DBConnection and Ecto with a Postgres DB. Occasionally we get errors like below in the Postgres log:
2022-09-17 12:36:...
New
Hello,
I want to store a structured raw input in a JSONB column. This raw input is already in an embedded schema because it has been pre...
New
Hi, I am looking for a way to monitor connections pool of Ecto repo. Basically we want to measure maximum capacity of our application, so...
New
Hello,
I’m being curious about why Ecto needs explicit casting when passing arguments to a query. I faced the following situation:
amou...
New
We’ve got a kind of producer/consumer workflow happening, involving three processes.
The main process inserts a whole bunch of records i...
New
Hi. I have a query that looks like this:
from p in Payment, group_by: fragment("extract(hour from ?) as hour", p.inserted_at),
select: {...
New
Hi I am trying to preload associations for a subquery like such:
from(p in Post, distinct: [p.group_id], order_by: [asc: p.published_dat...
New
Are there some Ecto gurus here?
I have this SQL function which works amazingly well (using Postgres 11.6)
CREATE EXTENSION IF NOT EXIST...
New
Hi,
Looking at the documentation of the transaction/2 function it should return a {:ok, result} or {:error, reason} tuple. However, if I...
New
I need to set up a “audit” table in the database, where changes to records trigger an insert on some other table. Writing the trigger is ...
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.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Courses that'll move you from confusion to "Aha, now I get it!"