Latest #ecto_sql Threads 
Overview
SqlKit came about when I wanted to execute SQL inside .sql files at work without having to pollute my context functions with Fil...
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
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
Hi! :wave:
I was thinking about this today and wanted to collect some feedback…
I have been working with an OLAP database for the past ...
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
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.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
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
Overview
SqlKit came about when I wanted to execute SQL inside .sql files at work without having to pollute my context functions with Fil...
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
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
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
Hi,
I’m new to nerves but already managed to build the Weather Station (and also read the Binary-Clock-Book).
Now I want to modify the ...
New
Hi! :wave:
I was thinking about this today and wanted to collect some feedback…
I have been working with an OLAP database for the past ...
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 there,
I think Ecto development should consider this recommendations:
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
During the winter storm here in Texas, I was couped up without reliable electricity so I was bored and started working on an sqlite3 nif ...
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.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"