Latest #postgres Threads 
Episode 278 of Thinking Elixir. News includes the Curiosum Elixir survey closing soon, ReqLLM reaching 1.0 with standardized LLM API supp...
New
This deep-dive into Postgres’ Write-Ahead Log (WAL) covers how to track database changes without changing a single line of application code!
New
I’m excited to share FeistelCipher and AshFeistelCipher, PostgreSQL-based libraries that provide encrypted integer IDs using the Feistel ...
New
Episode 273 of Thinking Elixir. News includes Chris McCord releasing a shell-based web browser tool for LLMs extracted from phoenix.new, ...
New
Hey everyone – after coming off of 3 years building with Ecto, I’ve been working non-stop on Typegres, a new query builder that strongly ...
New
I realized I could really use something like this in my Phoenix project:
I asked Claude 4 Sonnet if a port exists - it said no, and ga...
New
I’m starting to follow the book Engineering Elixir Applications, and immediately ran into an issue installing PostgreSQL 15.2 on macOS 15...
New
Hello :wave:
I’m using Ecto along with PostgreSQL. I’ve been trying to add a field containing a 2-tuple to an Ecto schema, but can’t see...
New
Episode 248 of Thinking Elixir. News includes a new Elixir case study about Cyanview’s camera shading technology used at major events lik...
New
Moderator note: This was split from Elixir-postgresql-message-queue - Pure PostgreSQL Message Queue for Elixir
What is the correct way t...
New
This Week's Trending
This Month's Trending
This Year's Trending
Hello!
tl;dr Announcing Oban, an Ecto based job processing library with a focus on reliability and historical observability.
After spen...
New
Has anyone ever tried out the Large Object feature of Postgres?
I have a blob column in my table, and was wondering what data type to us...
New
I’m excited to share FeistelCipher and AshFeistelCipher, PostgreSQL-based libraries that provide encrypted integer IDs using the Feistel ...
New
Hey everyone – after coming off of 3 years building with Ecto, I’ve been working non-stop on Typegres, a new query builder that strongly ...
New
This deep-dive into Postgres’ Write-Ahead Log (WAL) covers how to track database changes without changing a single line of application code!
New
Episode 273 of Thinking Elixir. News includes Chris McCord releasing a shell-based web browser tool for LLMs extracted from phoenix.new, ...
New
Episode 278 of Thinking Elixir. News includes the Curiosum Elixir survey closing soon, ReqLLM reaching 1.0 with standardized LLM API supp...
New
Ecto currently supports some data-modifying WITH statements / CTEs for Postgres:
Options: […]
:operation - one of :all , :update_all ,...
New
Last Three Year's Trending
I’ll post this here, It might help someone in the future.
Feedback is greatly appreciated.
I use it with direnv on NixOS, It should wor...
New
Hi all,
I’ve added a unique constraint across all columns of my project_roles table, which successfully prevents a row being added with ...
New
Hi all, I’m using a managed DB service where I can optionally set up a connection pool using PgBouncer and set max connections.
Is there...
New
Hi everyone, it seems I can’t get out of this forum this week :sweat_smile: (you guys are awesome btw).
So, I got surprised by this beha...
New
Hello,
I am coming back to Elixir world after one year and I wanted to learn also new stuff so I decided to use Docker to my development...
New
Hey everyone,
Excited to share a new open-source project built with Elixir. Sequin combines Elixir and Postgres into a feature-rich mess...
New
Hello.
I don’t know what the best place is, hoping to find any help with the problem I’ve been facing in production for about 3 days.
I...
New
I’m using an AWS Aurora PostgreSQL Serverless v2 database cluster with Ecto. It can auto-scale between 0.5 and 16 ACUs (Aurora Capacity U...
New
We’ve been working on an open source multi-tenant Postgres connection pooler here at Supabase for the last few months.
It’s been rolled ...
New
In my Ecto schema, I have a User who has_many Items. An item has a boolean field active:
User module:
schema "users" do
field :na...
New
Moderator note: This was split from Elixir-postgresql-message-queue - Pure PostgreSQL Message Queue for Elixir
What is the correct way t...
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
I’m currently trying to mimick a database migration from another system that needs to live in ecto in the future.
I’m trying to implemen...
New
Objectives
I am trying to parallelize a little bit of database workload with Elixir and Ecto. There is no data inconsistency expected, as...
New
Hi, I am getting a connection timout with Ecto when connecting to Neon. Neon suspends their Postgresql instances and the timeout happens ...
New
Trending Over Three Years
After calling mix ecto.create I get this error:
17:00:32.162 [error] GenServer #PID<0.412.0> terminating
** (Postgrex.Error) FATAL...
New
This should be a simple problem but I just can’t seem to figure it out. I have a standalone Elixir app that won’t find the database.
Dep...
New
why i’m getting this while configuration?
** (Postgrex.Error) ERROR 58P01 (undefined_file) could not open extension control file "/usr/s...
New
I’m using a Neo4j database to supplement my Postgresql database. Postgres is used to store the entities themselves (e.g. users), and shou...
New
My team at work is seeing some rather poor performance, especially on update queries, from an application we’ve built using Ecto and Post...
New
Hello all,
Does anyone know if you create a unique_index in postgres for two fields on a table, does that mean you DON’T need to create ...
New
My use case is perfectly served by the update ... from syntax for Postgres as per the query below:
update test as t set
column_a =...
New
Postgres is complaining that I am inserting invalid UTF8 into a text type:
(Postgrex.Error) ERROR 22021 (character_not_in_repertoire) in...
New
I have a migration that modifies a table, flushes, and then migrates the data in that table. This worked fine locally, but in CI it fails...
New
I'm using Phoenix and Ecto. I need to check if a difference between "now()" and a certain date less than 3 days. Exactly I'm trying this:...
New
I apologize for the not-really-Elixir-specific post, but I’m currently working solo and y’all are the only programming community I engage...
New
With this Ecto migration:
defmodule Migrations.Foo do
use Ecto.Migration
def change do
create table(:foo, primary_key: false) d...
New
How can I write this query in Ecto?
SELECT
*,
(SELECT COUNT(o.id) FROM tenant_versilov.orders o
LEFT OUTER JOIN...
New
I’m managing my Postgres database with Ecto and I have come across a situation: In some of the fields for some of my records, I save empt...
New
I insert a list of entities in the DB, say articles, for a user. Primary keys are UUIDs.
To sort the articles just as they were initiall...
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.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Courses that'll move you from confusion to "Aha, now I get it!"