Latest #postgresql Threads 
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
Episode 258 of Thinking Elixir. News includes the first CVE released under EEF’s new CNA program for an Erlang zip traversal vulnerabilit...
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
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,
We recently did some optimizations on a slow query in our system, and found the following article from dba exchange that has a ni...
New
My name is James Edward Gray II (JEG2 on various parts of the interwebs) and I’ve been building web applications for over twenty years no...
New
Hi elixir fam! :wave:
I’m running into some interesting errors with trying to implement a custom Postgrex Type Extension and I’m really ...
New
Hi Elixir community!
Name: Kodi
Location: India
Time zone: IST (UTC+5:30)
Work Mode: Remote preferred
Team Experience:
Combined 7...
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’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
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
Last Three Year's Trending
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
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
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, 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, my name’s Maciej Lenc, originally from Poland but I live in Edinburgh (UK) nowadays.
I’m currently looking for a remote contract ...
New
Heyo, it is me - and I’m looking for a job!
I’m an experienced leader & product-minded engineer deeply interested in collaboratively...
New
Hi,
I wrote longer article about multiple approaches for search in PostgreSQL and Ecto/Elixir. There are example in SQL and also in Ecto...
New
Hi!
When debugging slow Ecto queries (I’m using postgres), because Ecto uses named prepared statements which may use a different generic...
New
When using a relational DB (such an Ecto schema with a Postgres table), usually a foreign key field has to be pre-defined with a referenc...
New
Hi elixir fam! :wave:
I’m running into some interesting errors with trying to implement a custom Postgrex Type Extension and I’m really ...
New
Hey everyone, I’m looking for some contract work.
I am a full-stack software developer working in the industry since 2012. I’m used to w...
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
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
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 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
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
Hi Everyone! :slight_smile:
I’d really appreciate if I could get some help with this issue I ran into.
I’m trying to allow searching on...
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
We have an application running on EC2 which connects to a database on RDS.
Over the past couple of weeks, we noticed the connections to ...
New
I’m wondering if I’ve wandered into trouble with my Ecto schemas. I have one that describes files in S3. For convenience (e.g. for REST...
New
Environment:
Windows 10
Using WSL2 with Ubuntu Server via Windows Terminal to run setup
Database URL: ecto://postgres:postgres@l...
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.
Producing high quality Elixir screencasts since 2017.
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!"