Latest #postgres Threads 
I’m currently building an event ticketing system in Elixir and I’m looking for advice on properly handling race conditions around ticket ...
New
Hi everyone,
I have been working on a large-scale, open-source platform for orchestrating and governing AI workloads on the BEAM (curren...
New
I’ve been wondering for some time now if there is a way to instruct ecto to run all, not yet applied, migrations inside a single transact...
New
I’ve been working on pgRx: a query engine that uses BEAM lightweight processes instead of PostgreSQL’s fork-per-connection model.
The nu...
New
Hi everyone,
I’m posting because I assume this must be a common issue, but I’ve been going in circles and haven’t
found a clean, reliab...
New
Postgres 18 adds support for generating UUIDv7s out of the box; no extensions required. Unfortunately, it’s less obvious how to use these...
New
Episode 290 of Thinking Elixir. News includes Elixir v1.20.0-rc.1 with important type system improvements, not one but two new Elixir-nat...
New
Blink is a library for fast bulk data insertion into PostgreSQL databases using the COPY command. It provides a clean, declarative syntax...
New
I was reading postgres wiki about freebsd and freebsd/aio and it wasn’t clear to me what is better, the same or worse compared to hosting...
New
Episode 285 of Thinking Elixir. News includes Software Mansion pushing the boundaries of Popcorn by running LiveView locally in the brows...
New
This Week's Trending
This Month's Trending
Torus is a plug-and-play Elixir library that seamlessly integrates PostgreSQL’s search into Ecto, streamlining the construction of advanc...
New
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
Just posting this here in case it helps anyone else in future.
on mix ecto.create I was getting:
00:54:48.033 [error] GenServer #PID<...
New
Building off of this older post:
What I need to do is to create a few case-insensitive columns in PostGres. I’ve been following this po...
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
Introduction
Ash seems to be great with regular relational data. However when I tried it out for a hobby project, where I had to represen...
New
I’m excited to share FeistelCipher and AshFeistelCipher, PostgreSQL-based libraries that provide encrypted integer IDs using the Feistel ...
New
Blink is a library for fast bulk data insertion into PostgreSQL databases using the COPY command. It provides a clean, declarative syntax...
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
Hello community.
I am trying to perform the following query in Ecto
SELECT *
FROM table t
where ARRAY[2, 12] <@ list_of_ids ;
The ...
New
Postgres 18 adds support for generating UUIDv7s out of the box; no extensions required. Unfortunately, it’s less obvious how to use these...
New
Hi everyone,
I have been working on a large-scale, open-source platform for orchestrating and governing AI workloads on the BEAM (curren...
New
I’ve been wondering for some time now if there is a way to instruct ecto to run all, not yet applied, migrations inside a single transact...
New
Episode 285 of Thinking Elixir. News includes Software Mansion pushing the boundaries of Popcorn by running LiveView locally in the brows...
New
Hey all,
I’ve got two machines running, one for phoenix and the other for postgres. I decided to mix things up and wanted to connect to ...
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
I want to store books details in a PostgreSQL table. There will be a field with unique constraint holding book’s ISBN-13 number (example ...
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
Postgrex doesn't send password? "(Postgrex.Error) FATAL 28000 (invalid_authorization_specification)"
Hello everyone!
I’m trying to deploy my blog application into production, and I’m facing a very weird issue: Postgrex doesn’t want to co...
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
(I have about 10 books of Phoenix and Elixir that I bought, so this ongoing headache right at the start is important for me to solve. I’v...
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
Hello friends!
So I’ve been ticking away at a project to showcase the possible use case for using Ash and Phoenix at my place of work.
...
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
aws_rds_castore
Enable verification of server certificates in AWS RDS DB connections, e.g. through EctoSql. Includes the latest private r...
New
Moderator note: This was split from Elixir-postgresql-message-queue - Pure PostgreSQL Message Queue for Elixir
What is the correct way t...
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
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
In templates/appointment/index.html.eex:
<%= for appointment <- @appointments do %>
<tr>
<td><%= appoi...
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 have noticed that the primary_key field (id field) of tables in PostgreSQL doesn’t guarantee auto-incremental values. The rows keys can...
New
I want to sort the people by the boolean value i.e., whose field will be true will come first then false one.
How I modified the followi...
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 problem running my dockerized phoenix application with postgresql.
I specified my docker-compose.yml file to include two servic...
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 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
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
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.
Develop your skills with books, videos, and courses.
The deployment platform built for Elixir: PaaS ease, VPS control.
Courses that'll move you from confusion to "Aha, now I get it!"