This Week's Trending
This Month's Trending
This Year's Trending
I learned C/C++ in college before learning about Algorithms. And thinking about time complexity in C/C++ came naturally to me because I h...
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
Last Three Year's Trending
I am working on a small hobby project which uses ETS/(Am)nesia to learn more about how these systems work.
One thing I am struggling wit...
New
I’m back with another SQL / database structure question. I feel it’s related to polymorphism, STi and all those concepts, but seems inver...
New
I have an sqlite database (Chinook, iTunes-like data), for which I have setup a simple Phoenix project.
The birds eye view:
Repo: Musi...
New
Hello, I am trying to do a postgrex query with the sql library where I get the first entry from a table sorted by last_visited and exclud...
New
I saw that Ecto repo have the function Repo.stream, but I dont know what the steps happens when a trigger the Stream.run. A query like SE...
New
Hello All,
I don’t know how to ask this question or if I am asking it in the right place, but I need some suggestions/guidance. I am cur...
New
Hi folks, I am very new to Elixir and Ecto and struggling to express an SQL query in Ecto where I have to select computed values from a C...
New
So I have this tables setup where I’m receiving foreign data and need to insert it into my database.
These elements I receive can have a...
New
Trending Over Three Years
I have this SQL query:
SELECT DISTINCT ON (b.id) b.id as book_id, r.id as record_id, r.due_for_return, r.returned_at
FROM books b
left j...
New
Hi,
I have built a simple elxiir app which receives request like:
curl "http://localhost:8085/pass" -H Content-Type: application/json; ...
New
I can’t seem to figure out a good way of doing this safely. I need to do a find-or-create, so I first check to see if a given row exists ...
New
I’m attempting to replicate an INSERT … SELECT in Ecto. This appears to be supported by both postgres and mysql (I’m using postgres). I’v...
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 have the following query:
{account, {inflow, outflow}} =
Repo.one(from account in App.Account,
left_join: t0 in App.Transa...
New
Hi all!
I don’t know what to do to make Ecto happy to run the following query:
sql = "" <>
"SELECT chat_user_notification_key...
New
I know this can be achieved using raw SQL and Ecto.Adapters.SQL.query() but what is the Ecto way to it? Any help is highly appreciated, t...
New
TL;DR The problem I’m trying to solve is analogous to building an Ecto.Query, say, for posts that includes n number of latest associated ...
New
Hi All,
I’m trying to perform the following SQL query:
SELECT t.*, d.*, u.* FROM
(
SELECT x.* FROM trips AS x
INNER JOIN trips...
New
So I have a gnarly query in my open source Phoenix app I was trying to make dramatically more efficient.. in its current form it brings i...
New
Hi there,
I am trying to set up a simple Elixir project on Windows 10 with the following dependencies:
sqlite_ecto
ecto
My mix.esx:
...
New
Hello, I have a single SQL table looking as follow:
create table("git_commits", primary_key: false) do
add :oid, :binary, primary_key:...
New
Is it possible to program backend with pure elixir (direct SQL in BD) without frameworks? What are the challenges or problems?
New
I have a table with documents with separate categories and I want to have a number column which auto increments after adding a new docume...
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
- #elixirconf
- #exunit
- #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
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
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.
Real-time error tracking, performance insights, and observability for devs.
Develop your skills with books, videos, and courses.
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!"