S
Supabase
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
JoinS
Supabase
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
JoinHow to secure the database data?
I want to setup the table data in the encypted form so that even I (supabase project owner) can't see the data using the Supabase UI.
Is it possible with supabase?...
N sitters per Company
Company can pay for N licences for users to use at the same time. How to control number of users using app at the same time per company?
1. Auth Hooks are not for this.
2. edge functions?
3. own backend app working as a proxy between supabase?...
Rate limit when deleting from storage in the UI
Why do I get rate limited when I want to delete all my files from a bucket?
How to force types on a query
[typescript] I have the following query:
const ticketsQuery = supabase.from('my_tickets').select(`
id,
status,...
Foreign key relationship isn't one to one
I have two foreign keys, both of which are set to primary in their respective tables. But when I generate the types, the filed "isOneToOne" is set to "false", and I'm getting an array type.
I'm using typescript...
AI assistant doesn't save chat's history
I'm using supabase's AI assistant on the admin dashboard for writing SQL and helping with backend, but whenever I logout from supabase and login again my chat history isn't saved. Not a single conversation with an assistant is showing, i can only start a new chat. Can I somehow turn chat history on?
I'm relatively new to supabase and I'm using a free plan at the moment.
Thanks....
Help additional permissions needed for creation
For some reason it need additional permission from my organization owner, which is me. I just can't figure it out, there is no messages nowhere. no github, gmail or somewhere else to approve. Its my first time so maybe im just doing it wrong. any advice would be appreciated.
Error status 502: An invalid response was received from the upstream server
I get this error when running npx supabase db reset after my supabase instance has been started.
I recently updated to the newest CLI version 2.62.10 and have been running into issues when running : npx supabase db reset command at this step:
Restarting containers......
Cannot deploy Edge Function
I've recently started seeing the following error for an Edge Function that used to work fine:
"worker boot error: Uncaught SyntaxError: The requested module 'https://esm.sh/contentful-management@11.41.0' does not provide an export named 'default'\n at file:///var/tmp/sb-compile-edge-runtime/transactional/contentful.ts:1:8"
Here is the offending code:
```...i need help ASAP pls
errors
Test connection failed: getaddrinfo ENOTFOUND db.exsarzogufvgvwpqwkoa.pooler.supabase.com self-signed certificate in certificate chain...
CLI not logging in
Failed to create login session: User can have up to 20 personal access tokens. Please remove the excess tokens to create new ones
I get this message when logging in via CLI but not sure where to remove these from...
Text column truncating data — only one of two identical columns affected
Hey all, weird issue. I have two text columns that store prompts. Same structure, similar length (~10k chars).
One saves fine. The other gets cut off.
character_maximum_length is NULL (no limit)
SELECT LENGTH() shows truncated...Querying Joins and Nested tables issue
I'm having an many-to-one issue on a query that I can't solve. Giving:
```sql
create table profiles {
"id" uuid primary key,
-- ......
# help please urgent help
I accidentally ran:
ALTER DATABASE postgres CONNECTION LIMIT 0
Now all connections are blocked, including SQL Editor and service role key connections.
Please reset the database connection limit so I can access my project again....
How to authenticate user session after 3rd party redirect?
Hi everyone, I’m trying to figure out the best way to automatically authenticate a user in Supabase after a third-party payment (Barion) redirect.
I’ve considered a few approaches, but I’m not sure which is the most reliable, especially in local development and production.
Using Supabase locally with Docker.
...
SQL Rapper SpiTupleTable error
I tried to change a connection string from a vault for an sql wrapper but couldn’t make it work.
So i deleted everything and tried to recreate, but there seems to be a problem.
I connected and sent some commands from DBvisualizer, in the past we had similar issues with UTC time being set by these clients.
...
Sessions out of sync after a Point-In-Time-Rollback - please help!
Hello - I performed a PITR on supabase, to a few hours ago, and now all of my users are unable to sign in or sign up - this is causing a major issue.
They try to sign-in and they get 'Database error granting user'
I've checked logs, seems to be a session/scopes issue (auth.sessions.scopes) - however, any SQL script I run is saying I must be the owner to change these tables. ...
Setting a New Password for Non-Authenticated Users
I am trying to set a new password for a user who is not currently authenticated. I couldn't find any information on this in the documentation https://supabase.com/docs/reference/javascript/auth-updateuser.
updateUser works only for an authenticated user, but in my opinion, it is not safe to automatically log in the user immediately after they click the "reset password" link sent to their email.
What is the recommended approach for updating the password for non-authenticated users?...Creating storage buckets by code (with migrations or config) and seeding files
is there any way to create storage buckets through config or migration SQL? And bonus points if anyone knows how to seed files automatically.
Right now when we run supabase db reset we have to recreate the buckets by hand, which isn’t great and sometimes they get set up wrong and cause issues. We also have a few files we always need for running some features of the application, and we’re adding those manually after every reset.
Would be awesome if this could all happen automatically like DB migrations/seeds. Anyone done this before?...