Latest #sql Threads 
Announcing Turxo! Turxo is a library (hex, git repo) for bindings to the Turso database, a SQLite compatible in-process database written ...
New
Polyglot-Ex Rust and wasmex bindings for polyglot.
State: Pre-release
Hi there,
I am starting a thread for my humble bindings library ...
New
One thing I’ve been missing from python ecosystem was an ability to connect to a remote Apache Spark cluster from a locally running noteb...
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
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
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 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, 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
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
This Week's Trending
This Month's Trending
Announcing Turxo! Turxo is a library (hex, git repo) for bindings to the Turso database, a SQLite compatible in-process database written ...
New
This Year's Trending
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
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
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
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
Link to HexDocs Page
Motivation
I was building a toy rest-api using plug-cowboy and wanted a way to turn query parameters such as name: ...
New
From here: Work with pipe query syntax | BigQuery | Google Cloud Documentation
HN: SQL pipe syntax available in ...
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
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
- Follow
- Join
- Shape
the conversation
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
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #genstage
- #ai
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #hex
- #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.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"