katafrakt

katafrakt

I have really weird issue with Ecto connecting to Supabase. Perhaps someone faced something similar.

I recently deployed an app to fly.io with database on Supabase. The app deployed, the migrations were run, I can see the tables in Supabase UI.

However, now I wanted to seed the database from my local machine. I have a separate repo with seeds. I put the connection config (same as a deployed app) onto it, but when I try to run the seeds I see an error that a relation cannot be found. At the same time I can see that a table with that name exists in Supabase UI. I can connect using the same config via psql = I see the tables. Only when connecting via Ecto the tables cannot be seen.

I tried querying for search path - looks ok. I tried executing raw SQL with table name prefixed by a schema - table not found. I can query pg_catalog and information_schema - all show no tables (except built-in ones) when queried via Ecto.

Any ideas what might be wrong here? The libraries like Ecto and Postgrex are in most recent versions, if that matters. Elixir i 1.18.2 on OTP27.

Update: Tried also with different version of Elixir (1.16) and OTP (26), but still the same result.

Showing Posts 1 to 1

katafrakt

katafrakt OP

Ok, nevermind, I tried session pooler instead of direct connection and it worked now.

— All posts loaded —

Where Next? Top

Trending in Questions Top

Blokh
Hey guys, I’ve got a huge CSV ( around 10 GB ) that needs to be processed hourly Do you guys have any suggestions what is the best prac...
New
kszambelanczyk
Hello! Could someone please give me a help/sample code, how to delete a file from s3 using waffle/waffle_ecto from Phoenix app. I creat...
New
Onor.io
I have what I’ve heard referred to as a “lookup table” in my database. This is a way of assigning codes to common values. One common lo...
New
Trolleger
What approach to take when sending live updates to “random” users Hi! I have a question, I have a little chat app, and when I create a DM...
New
RemyXRenard
I’m seeing that a list inside a Kino.DataTable will be interpreted as a charlist, even if the Kino.configure() is set to charlists: :as_l...
New
matt-savvy
Anyone here using Honeybadger? My Honeybadger account is being overwhelmed with noise from some bots. Seeing a lot of Bandit.HTTPError...
New
samoloth
Hi, I’ve just set up an application with ash_authentication. There is only magic link strategy for now, so there is no confirmation add o...
New

Other Trending Topics Top

mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
garrison
Hobbes is a low-level distributed database for the Elixir programming language. Hobbes provides a simple, safe, and scalable storage lay...
New
mcass19
ExRatatui lets you cook up rich terminal UIs in Elixir, powered by Rust’s ratatui via Rustler NIFs. Build interactive terminal applicatio...
New
Damirados
Hello everyone. After busy few months I am happy to announce v0.1.0 of Emerge & Solve. They are GUI (Emerge) and State management (S...
New
netoum
Corex is an accessible, unstyled UI component library for Phoenix that integrates Zag.js state machines using Vanilla JavaScript and Live...
New
wintermeyer
There are three potential reasons for members of this forum to have a look at https://vutuv.de You are tired or annoyed of LinkedIn. Yo...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews