Latest #postgresql Threads 
Hi,
I am building BeamTrail, a small BEAM library for durable business processes: retries, timers, signals, approval deadlines, operator...
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
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
An application wishing to store larger amounts of data typically has two options for doing so:
A new column on some table can be introd...
New
I’ve started working on a new library to run SQL queries and do basic business intelligence.
Think “Blazer for Elixir.”
Currently it fe...
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
The Oban docs state the following regarding Oban.Notifiers.Postgres:
However, it is not as scalable as other notifiers because because ...
New
Episode 258 of Thinking Elixir. News includes the first CVE released under EEF’s new CNA program for an Erlang zip traversal vulnerabilit...
New
Hi friends,
I am very new to Phoenix and PostgreSQL database. I am trying to deploy a simple very basic web app on fly.io to try to unde...
New
This Week's Trending
This Month's Trending
Hi,
I am building BeamTrail, a small BEAM library for durable business processes: retries, timers, signals, approval deadlines, operator...
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’ve started working on a new library to run SQL queries and do basic business intelligence.
Think “Blazer for Elixir.”
Currently it fe...
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
An application wishing to store larger amounts of data typically has two options for doing so:
A new column on some table can be introd...
New
Episode 285 of Thinking Elixir. News includes Software Mansion pushing the boundaries of Popcorn by running LiveView locally in the brows...
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
The Oban docs state the following regarding Oban.Notifiers.Postgres:
However, it is not as scalable as other notifiers because because ...
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
Last Three Year's Trending
Hi there. I am trying to implement the logic that does get_by(..) and if not exists, it should insert and return.
The first implementati...
New
When working with Stripe API (and dashboard), I got so used to their style of IDs.
For customer, it is something like cus_sd9f87gds987, ...
New
Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page “Notes f...
New
Hi everyone. I’m trying to wrap my head around using the CTE functionality in Ecto and I haven’t quite been able to figure it out by look...
New
I have raised an issue at ecto_sql issue_link
Adding it here to reach out to larger community.
I have updated my ecto_sql_3.0 to ecto_s...
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’ve seen this pattern used often in the Ecto documentation, Phoenix controller templates, and numerous other places. It’s not clear to m...
New
Hello,
I am looking for experiences / recommendations on worry-free managed PostgreSQL hosting with limitless and effortless horizontal ...
New
Episode 129 of Thinking Elixir. Tracking, analyzing and visualizing time series data can add a lot of business value to a project! We met...
New
Is there a way to stream data TO the database with Ecto? I’m working on using the COPY command to load CSV data directly into Postgres.
...
New
Hi! :wave:
I was thinking about this today and wanted to collect some feedback…
I have been working with an OLAP database for the past ...
New
Hi, my name is Henricus Louwhoff, originally from the Netherlands and moved for a job to Helsinki, Finland.
I’m currently looking for a ...
New
Phoenix Pub/Sub is great, but I often encounter usecases where I want topic-based message passing, but durable. In other words, if the me...
New
Hello,
I am using mix release to run a Phoenix app in production. However, when I start the app as described in the mix release and Phoe...
New
Hello, my name’s Maciej Lenc, originally from Poland but I live in Edinburgh (UK) nowadays.
I’m currently looking for a remote contract ...
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
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 have a model with field of type array defined:
defmodule QsiSearchService.Features.FeatureProperties do
use Ecto.Schema
import Ect...
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
How do I use the PostgreSQL JSON ? operator in Ecto? Assume that I have a table users that has a JSONB field data, and I want to test (in...
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
Hey guys. I’m pretty new to Elixir and Phoenix after swapping from NodeJS & MongoDB. Some of my requests are taking 1-2 seconds on th...
New
Hi,
We are using DBConnection and Ecto with a Postgres DB. Occasionally we get errors like below in the Postgres log:
2022-09-17 12:36:...
New
I am try to migrate elixir those days, so I have simple project to create GraphQL API’s with Phoenix. When I start the server like " iex...
New
I have a unqiue index over three columns where one is computed ([:file_id, :request_id, "(accessed_at::date)"]) and I can’t figure out ho...
New
Hi everyone!
I am playing with Ecto and PostgreSQL for my project, and, usually, I like to create some views to make my life easier when...
New
i am following along with the Phoenix Up & Running guide at https://phoenixframework.readme.io/docs/up-and-running
and when I try to...
New
Sorry for some similar posts – I’m narrowing the problems. I’m trying to get my PostGres database setup using Ecto migrations. This inc...
New
I have a fairly peculiar use case. Whenever a HTTP request is being handled in Phoenix app, I want to, from a plug mounted in router, set...
New
Hello,
I’m trying to convert a SQL query to the Ecto query, but I’m having hard time figuring out how to do that. I know I could simply ...
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
- #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.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"