Squash Expected Behavior
I just tried squashing. My result was this:
Local | Remote | Time (UTC)
[lots...]. times.... [squashed]. ...
[lots...]. times.... [squashed]. ...
Composite key foreign key issue
I created a table where the primary key is a composite key from :
```
CREATE TABLE lab_members {
user_id,
lab_id,...
Migration History
Hi everyone! I have something strange happening with migration history:
<- [things look perfect]
<- [last 20 remote migrations are missing]
<- [things look perfect]...
npx supbase migration list
npx supbase migration list
npx supbase migration list --local
npx supbase migration list --local
npx supbase migration list --linked
npx supbase migration list --linked
Restart database
very complex query going which i tried stopping couldn't stop it, or get synced back to everything. So i went to the project settings to do fast database reboot and its taking quite a while to see my tables. At this moment im not seeing any of my tables
Can you add a unique to an existing table? supabase + drizzle
I am using supabase and drizzle in my Next.js application and unfortunately noticed a year later I forgot to add a
unique().on() for a table that holds voter ballots. š« I thought everything was fine and dandy and no duplicates were being inserted into the DB until this week when I noticed some. š¬
The schema for this table looks like
```ts...Noob dev question on FastAPI + Supabase best practices for security + image storage
Hi!
I'm a first-time dev trying to learn Fastapi and Supabase. I'm setting up a project where users can order personalised products but I am getting really confused and frustrated about the best way to handle security between my backend and the database.
My Core Dilemma:...
Has someone used https://jsr.io/@astral/astral successfully with edge functions?
I would like to implement an edge function, which should take HTML, width and height for the viewport, and create a screenshot after rendering the HTML on a browser.
My current Python code doing this work with Playwright:
```
with sync_playwright() as p:...
Feature Request. Add schema exposure to config.toml
```toml
[api]
schemas = ["public", "governance", "pages", "schema_harbor", "portal"]
Grant permissions for the listed schemas
...
Should staging use a db reset or be treated like production?
Hey guys, I need some assistance with how I should use a staging environment.
My plan was to have a
supabase db reset in my staging environments gh action file, so each time I push something I get a fresh staging env with all the migrations and seed data (seed.sql + Python script for images in buckets).
But this is giving me some trouble because, contrary to what happens locally (supabase db reset also cleans up all the buckets), the buckets in staging stay where they are. That means Iād have to clean them up manually after each push, or my GH Action will fail when trying to recreate a bucket (buckets are created as DB entries and thus are part of the migrations)....My payment is not getting processed for my Supabase Pro plan.
The payment is not getting processed. Its redirecting to withorb portal but payment isnt processed.
AUTH - email
Hi I have set up a new project to test the use of email auth. I have invited a user, who receives the invitation, when clicking on "Accept the invite" the url
https://{project}.supabase.co/auth/v1/verify?token=87762ba307ce4f0ca1e12ce5586729d194f7288b1e71c6a3a29036d6&type=invite&redirect_to=https://{project}.supabase.co
produces...
Edge Function Report
Though we use Edge Functions a lot, the report does not show any Edge Function record. How do I make it visible?
Snowflake foreign data wrapper is not getting integrated
Following error I keep getting - I have made sure that all the steps are followed correctly and also taken help from AI assistant.
```
Chart
...
Best way to (quickly) reset between tests/after all tests?
Are there alternatives to
npx supabase db reset if I want to reset my database to the seeded state for local testing?
I'd imagine transactions could perhaps solve this, but I can't use those with the supabase-js client.
If I run supabase db reset, then I get the functionality I want, but the entire Docker stack is reset, which takes quite a long time (comparitively, for simple testing).
I can manually track the changes I think I'm making, and then try and invert those changes and use the service_role key to delete/un-update etc, but this doubles the amount of code to write, and potentially requires specific code in tests that I'd rather avoid......Unable to add third party auth to supabase branch using cli or rest api
I create Supabase branches of my development database for every PR made in GitHub.
However, the auth settings (Iām using Clerk) arenāt copied over, so I have to manually add them in the dashboard for each branch to work.
Iāve tried several workarounds, but unfortunately to no avail. It seems that neither the Supabase CLI nor the REST endpoints support modifying third-party auth clients.
...
Pausing a project issue
Hi Supabase Team,
My free-tier project is stuck in āpausingā state and I canāt delete it via dashboard or API.
Project Ref: qonnqowxikdbndjymlzc...
Feature Request: Raise the 2 project free tier limit on Supabase
Web ide's like lovable, bolt and v0.dev have connected their services to supabase via official integration.
THis has been a huge benefit for me and others in the community using these tools. As a result we have switched to supabase as our primary backends. The integrations are fantastic and ive been incredibly impressed with how powerful the tools are. So big thanks to the team for making this possible.
However ive been running into issues with the free tier cap.
...