Is the dashboar/portal down?
I got signed out with a JWT error which I've not seen in a year plu.s Trying to sign back in with gmail. Not getting forgot password email.
Data API 406 with Accept-Profile custom schema (‘seocc’), PostgREST serving stale schema list
Trying to use a custom schema ‘seocc’ via Data API (supabase-js v2, per-query .schema('seocc')) for CRUD on seocc.websites (RLS in place;
public.profiles.company_id set).
Issue
...
Why does [auth] need to be enabled to get the service key
I feel like I am about to ask a really dumb question, but why does the [Auth] Service need to be enabled in config.toml in order for the supabase CLI to print the service role key?
My understanding was that the auth service provides functionalities around user management, e.g. enabling sign up to my app and restricting access to certain resources like their own profiles etc.
In what way is the auth service involved in things related to the anon key or service key that should just interact with the rest api (at least from my current understanding)....
Realtime token usage
I have a table which 3 users need to edit in realtime. The process used to be a google sheet.
we have about 20 columns, and roughly 10 of them needs 2-5 updates per row, across 1500 rows a day.
My question is this. When we update a single cell, and send it from 1 user to 2 others, does the entire row, including all the columns, count as a realtime message, or is it just the one cell that was updated, which is being counted?...
Natural language database search
Hey, I have a Flutter mobile app running. Its a real estate reservation app. In the database we currently have around 12k listings, where each listing has around 50 data points. Client wants me to implement a "chatbot" of some sort, which would allow the user to search the database with natural language.
example: "I am searching for a flat in Sydney, pet friendly and cheaper than 500k".
My first approach was to basically use openAI API to construct a SQL query and then run that query to get the listings. The issue now is that the datapoints are not only numerical values / enums etc. but rather text columns with semantic data, so querying with raw SQL is not enough anymore. I cannot also dump the whole database to the API, because its too much tokens....
Has the `supabase db pull` changed?
My workflow the last 6 months was to make changes on staging branch of the database, pull the changes localy so I can then push it to github. This allowed me to make quick changes for frontend developer and it was working perfectly until last week when the pull command started to act differently.
Now when I pull I usually get this or similar error:
```
error diffing schema: error running container: exit 1:
[select_097e65a]: Executing query failed: SASL: SCRAM-SERVER-FINAL-MESSAGE: server signature is missing...
ABORTED REQ on storage resumable upload
Hello, we are building a react native app and need to upload an audio file (26mb) and realised it was more appropriate to use resumable uploads. Now we get this issue on failure and dont see any documentation around it. Pls help 🙂
Upload code in comment...
Recursive schema
Hi,
Cant find any documentation on whether Supabase declaritive schema is recursive. So am I allowed to have folders in my schema folder for better organizing?...
Can't `supabase db pull` Error: SSL connection is required
I found this issue on github - https://github.com/supabase/cli/issues/1969
Tried
supabase logout, supabase login, supabase unlink, supabase link --project-ref <project-id>, supabase db pull --debug
But I still get the error SSL connection is required...Unknown Error on Channel for realtime subscriptions after updating to latest libraries
I updated everything yesterday and have started getting errors from the realtime subscriptions in my test env:
...
Subscription error: Error: "Unknown Error on Channel"
Subscription error: Error: "Unknown Error on Channel"
Can't load any tables
I can't load any tables on the browser or when I try doing it from CLI. Is there downtime rn?
new Branch is empty, does not have tables, RLS, buckets
I am trying to create a branch of the existing database. First of all its forcing me to connect the github, which I did. but the new branch does not even have the database schema. I am trying to follow this video https://www.youtube.com/watch?v=AMQqhHxz5UI&ab_channel=Supabase
can anyone please help?...
Multiple Projects on Single Self-Hosted Supabase Instance
Can I run multiple projects on self hosted supabase on my vps, or do I have to install another one for each unique project? And also a new and unique port for each supabase stack?
Read-replica promotion + PostgREST version
Hey Supabase team,
I hope you're doing well.
I don't see the option to promote our read-replica to be the new primary database.
Am I missing something or is it not something we can do from the Supabase dashboard?
Also our current version of PostgREST is 11.2.0 (as seen in the infra tab in the dashboard)....
tried to get data from supabase its not getting any
keys = UptimeKeysL.select("*").execute()
print(keys)
data=[] count=None...
Excel connection via ODBC
Hello guys!
I'm losing my mind here... I need to connect an Excel (Office 2019 and Office 365) file to a Supabase DB (currently free tier).
I installed Postgres driver for odbc connection and configured it correctly (I assume). the "test" button says the connection was successfull....
How to connect Firebird 3.0 ERP database to Supabase (near real-time sync)
Hi everyone 👋
I’m connecting to an existing ERP system that runs on Firebird 3.0 (with Object Pascal). I’m building a separate app that depends on this ERP and needs to stay in sync with it, almost in real time.
What’s the best way to connect a Firebird database to Supabase for this kind of setup?...
Syncing Branch: "Your database schema is out of date"
When creating a PR via the UI from my persistent branch into main, I get a message saying "Update this branch to get the latest changes from the production branch."
When I do that, I get the error "Workflow failed
Consider creating a fresh branch from the latest production branch to resolve potential conflicts."
...
"The schema must be one of the following: api"
I am moving from public schema to api schema. So I made the schema api also exposed api in config.toml and set it as extra search path
Made this function:
```sql
CREATE OR REPLACE FUNCTION api.get_user_profile_with_subjects()...
Insanely Annoying Bug
There is a bug I have noticed in my app that whenever you leave the tab, then come back, you can no longer do any update/delete/insertions. Its really annoying, has anyone experienced this or know any potential causes? Please help thank you