Latest #sql Threads 
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
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
I wanted to share an exercise I did that I found useful for refining my knowledge of SQL internal implementations and list comprehensions...
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
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
This Week's Trending
This Month's Trending
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
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
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 wi...
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
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
Episode 166 of Thinking Elixir. Most of us have created our own filtering, sorting and pagination code before in one project after the ot...
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
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
I wanted to share an exercise I did that I found useful for refining my knowledge of SQL internal implementations and list comprehensions...
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 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
Hi,
I have built a simple elxiir app which receives request like:
curl "http://localhost:8085/pass" -H Content-Type: application/json; ...
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
Hi all!
I don't know what to do to make Ecto happy to run the following query:
sql = "" <>
"SELECT chat_user_notification_k...
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 tri...
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.es...
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
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 am trying to the following:
query =
from s in State,
group_by:
fragment("date_part(?, ?)", ^group, s.timestamp_start),
...
New
I have a simple relational database structure I want to do simple CRUD operations on.
Open the database, create a new record, open a re...
New
I’m struggling to produce a valid ecto query and feel like I might be overlooking something simple, would really appreciate someone takin...
New
I'm trying to build a query builder that takes as input a bunch of JSON and parses it out into a valid Ecto query. I've got most of the a...
New
I am using Mariaex without Ecto to query a MySQL database for one of my projects, I get results like this:
%Mariaex.Result{
columns: [...
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.
Enabling companies to succeed by building software people love.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"