hello

i needed some help

i want to add google login to my python flask webpage

or any other third party login

how can i do it

@User I would say #843999948717555735 is the best place. Also insted of lots of tiny messages put your question into one sentence/message that way people can help you better! 😄

okay. sorry for tiny messages.

Np

Stored Procedures

Hey! How is everyone?

What templating system is used the the email body?

Just saw this message while searching. CK apes strong 🦍✨

No examples but I guess you would just use the SDK with the service role as the key

a friend is working on a small personal project and needs someone to do frontend - paid gig christianvidebaek@outlook.com tell him I sent you 😋

is it possible to return multiple rows with a postgres function rpc call? i only see the single record type

https://www.postgresql.org/docs/current/sql-createfunction.html last example on this page

but there's no table return type in supabase 😦

Return multiple rows with Postgres function

congrats to the winners 🔥 🥳

Has this been answered?

How can I delete rows that are linked to eachother by a token? When I delete them I get this error and on refresh the rows reappear. Tried deleting the rows in both tables and they both reappear. https://prnt.sc/1w9l6io

cascade row

🤔

Any advice on how to support the money type in supabase? https://www.postgresql.org/docs/current/datatype-money.html

If its built in you can use a sepparate SQL client or the SQL snippets in the UI

Is it good practice to combine something like Supabase and Strapi? Basically I have a marketing VA who I don’t want messing around in Supabase. But I need to sometimes get some items from the database by id and those ID’s need to be set externally. So essentially I have an await call from Strapi to get a certain ID and then an await call for Supabase by that ID. Does that slow things down too much? Or are others doing this too? 🙂

From what I understand strapi can be a supabase replacement that sacrifices things like the real-time database for a better GUI. But you don't need both. You're going to hear, "you shouldn't make more trips to the server then necessary." My opinion: unless you're dealing with 100,000+ customers already, I'd say you're probably fine making two calls and having your users wait an extra 0.25s and invest your time in animating a fascinating spinner. Only fix things when you find a problem, don't optimize too early. And if you have 100,000+ users, hire an engineer to take a week and implement the best solution possible. In my project, I have just accepted that I will make multiple calls to supabase because it's just easier to develop in javascript rather than using their SQL editor to develop functions and call those. It works very well, even when I test a throttled connection. I get responses even with 6+ queries on a throttled connection in less than 3 seconds. For double ids, you might engineer some system that uses UUIDs generated on the client to push the same id record to both databases at once if you want to get really fancy with it, then you can query both databases with the same ID and can avoid the double trip. But that seems like a lot and if one fails even after a few retries. Then you'd have to delete the change on the other database and try again after fixing the connection to make sure things stay in sync. I am getting a headache just talking about that. If I were you, I'd just pick one or the other and make regular backups while the VA is touching things so they can't screw things up too much. It's a good excuse to make sure you're backing up your database anyway. Which supabase does on their paid plans for you.

Tbh I'd rather backup the database myself.

Or have both me and supabase do backups.

Noted! Yeah so right now I’m making on e API call to Notion.so to get 1 post id that’s like a featured post on the homepage. THEN I will call Supabase and query the post with that ID. I was curious what the impact would be. Thanks for sharing your thoughts. I might consider giving the VA access to Supabase. Al though I’m still hesitant.