Thank you! I'll check it out

How do i build a paswordless login page , that send a pin to your email for authentication and making an account ?

It’s called Magic Link. See https://supabase.com/docs/guides/auth/auth-magic-link

Hello. Has anyone used Postgraphile to wrap their Supabase db? Really enjoying supabase for many reasons, but not really getting on with the api, and postgraphile seems like it would be an awesome match... is it possible? Thanks https://www.graphile.org/postgraphile/

can you please point at my mistake? im doing

with au as (SELECT set_config(
  'request.jwt.claims',
  '{ "sub": "MY UID from auth table ", "email": "MY EMAIL from auth table" }',
  false
))
select * from auth.uid();

and it always returns

null

Random UI Question for everyone: Generally speaking, do you: A.) Query your data with subscriptions so that likes/votes/bookmarks (or whatever) get updated automatically on click (and always stay updated) B.) Query your data with promises and update the page optimistically on click C.) Query your data with promises, but somehow use a hybrid solution (please explain if you do this) I keep going back and forth on best practices here...

UI-Data interaction - Best Practice

We are minting our own jwt using our secret key from supabase. However, when we pass this in to the getUser call it says that it can't read the user claim

Is this intended behavior?

whats the default supabase uses for creating postgres columns "" or ''

Setting JWT claims manually from a SQL workbench

Docs indicate that I have to set alter table "your_table" replica identity full; in order for DELETE events to trigger in subscription. How do I do this?

Run that command in the SQL editor (replace

"your_table"

with the name of your table without quotes)

@User thx, got a "Success. No rows returned". but DELETEs still not firing. It there another step?

Delete subscription not working

Hey peeps, what's cooking?

My Raspberry pi 2 in its official case

Hi there, does anyone know if there is a way to log slow queries on supabase?

How advanced is the project regarding self-hosting?

Is it actually possible to build a serious project with it?

Self-hosting

I have a general question about pricing. I see that there is a Pro and Pro Pay as you go plan. I was wondering for the Pay as you go plan, do we get what is include in the pro plan and when we exceed the limits we pay for the extra usage? For example: In the pro plan i get 100GB of storage. So with the Pay as you go plan i will start paying 0.021$/gb of storage after i reach 100GB?

log slow queries

Pricing question

const avatarFile = event.target.files[0]
const { data, error } = await supabase
  .storage
  .from('avatars')
  .upload('public/avatar1.png', avatarFile, {
    cacheControl: '3600',
    upsert: false
  })

What does the filepath refer to here? Anyone? Edit: This is from the

yo is there a wrapper for golang

Supabase golang - client libs

Hi all, any tips for having a dev and a prod database?

Any way to keep them in sync and do you use two separate projects or just use two versions of every database table?

I use two projects, and run a cron job each day with https://github.com/ankane/pgsync to sync prod data into staging