Latest #ecto_sql Threads 
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
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
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
Hey folks,
I’m back with a new library for y’all :slight_smile: Gonna x-post from my blog:
I’m excited to announce the latest addition...
New
I do like a lot the concept of errors as values, and the pattern match that can be done in Elixir. I’m building an Elixir app right now a...
New
Hey there, I wrote this low-level library recently, its goal is simply to lower the barrier between Elixir and SQL, and it does that by p...
New
Ecto currently supports some data-modifying WITH statements / CTEs for Postgres:
Options: […]
:operation - one of :all , :update_all ,...
New
Howdy howdy everyone!
After running into some issues formatting SQL for my EctoDbg library, I decided to go a new route and leverage the...
New
Why I’m getting this error when trying to dynamically connect to repo?
insert.ex file
{:ok, _} = Application.ensure_all_started(:req)
...
New
Hi! While working with JSON data the other day, I noticed that coalesce(q.field, []) is being translated to coalesce(f0."o", '{}') instea...
New
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
Ecto.DevLogger is an alternative logger of SQL queries in development
It inlines bindings into the query, so it is easy to copy-paste lo...
New
Hey there, I wrote this low-level library recently, its goal is simply to lower the barrier between Elixir and SQL, and it does that by p...
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
Hey folks,
I’m back with a new library for y’all :slight_smile: Gonna x-post from my blog:
I’m excited to announce the latest addition...
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
Ecto currently supports some data-modifying WITH statements / CTEs for Postgres:
Options: […]
:operation - one of :all , :update_all ,...
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
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’m working on debugging a TransactionRetryWithProtoRefreshError error that comes up from time to time on an app using CockroachDB. The ...
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
With ecto_sql version 3.10.2 (for MySQL), the following code:
Repo.transaction(fn ->
Repo.query!("SET TRANSACTION ISOLATION LEVEL R...
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
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
Howdy howdy everyone!
After running into some issues formatting SQL for my EctoDbg library, I decided to go a new route and leverage the...
New
I created an umbrella app as a template for a workshop I’ll give into my university. So I preferred to show an umbrella project to build ...
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
Hey all,
We have made an Ecto3 Adapter for SQLite3, ecto_sqlite3!
We have successfully on-boarded the full suite of integration tests (...
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
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
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #ash-questions
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #exunit
- #discussion
- #javascript
- #elixirconf
- #library
- #oban-questions
- #dialyzer
- #docker
- #onsite
- #authentication
- #podcasts
- #full-time-contract
- #umbrella
- #code-sync
- #ecto-query
- #phoenix_html
- #iex
- #graphql
- #genstage
- #elixir-ls
- #nerves-questions
- #podcasts-by-brainlid
- #supervisor
- #websockets
- #distillery
- #advent-of-code
- #blog-post
- #livebook-questions
- #processes
- #forms
- #api
- #metaprogramming
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.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"