Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

https://www.google.com/search?q=How+can+i+get+my+supabase+connection+url&oq=How+can+i+get+my+supabase+connection+url&aqs=chrome..69i57.200j0j1&sourceid=chrome&ie=UTF-8

Will there be an impact on performance if I create a function to filter the data and do complex things like `left join` and `pagination `and call this function whenever the user wants to fetch data and when it reaches 10 rows it calls the function again to fetch the other rows and so on...

As with so many use cases, it depends. JOIN statements do impact performance, and as you add more of them, the impact can become quite noticeable.

The more complexity you invoke, your more impact you'll see. This will only become more noticeable  so here's a few good tips:

 - Index your tables. PG performance can scale much better if it knows where to look for the data. It's much quicker for PG to index the data before you add anything to the table, but the write performance will suffer a little (but it shouldn't be noticeable in day to day usage)

 - Use partitions on large tables. This allow PG to break the data down into smaller logical chunks based on some specified criteria, and combined with indexes, it can turn a 4000ms query into a 400ms query in some extreme situations. For smaller tables, it's probably not gonna make much of a difference, but it definitely does for large tables (e.g. 500K+ rows).

 - Filter at the innermost level of your queries. This is something I see many people overlook - they'll write a query which does some filtering and joins across 4+ tables, but it'll take 1500ms+ to execute because they put their `WHERE` statements at the end. By moving those `WHERE` statements to the innermost query, it reduces the amount of data PG has to search through. Do this, and you can often improve the execution time of a query by 2 - 10x .

 - `LATERAL` is something that doesn't seem to be mentioned much unless you go looking for it. It allows you to reference other subqueries without having to nest queries inside each other and can make it much easier to debug and read your query code

and What do you suggest I do because I have a table for the `Posts `and another table called `PostsLikes `and I have created a function that fetches the posts sorted by the highest likes  and this function just like this :
`SELECT p.*, COALESCE(c.LikesCount, 0) LikesCount
FROM Posts p
LEFT JOIN (
    SELECT postId, COUNT(*) LikesCount
    FROM PostsLikes
    GROUP BY postId
) c ON c.postId = p.id
ORDER BY p.id DESC
LIMIT 0,10
`
Then when the user gets the first 10 I will fetch the other 10 rows and so on by calling this function.
But what I'm thinking is for each Post to have a column called `LikesCount `and create a `Trigger `that works when a new row is added in the table of `PostsLikes `and then increase the value of the `LikesCount `in the table of `Posts`. in This way I no longer need to create a function to do complex operations like LEFT JOIN and COUNT(*) the rows... but will triggers work well without performance issues or impacts.

Or, for example, what will happen if 1000 new rows are added at the same time or more. Will the trigger work, whose task will be to increase the `LikesCount `if a new row is added and if a row is deleted, the `LikesCount`will be decreased, So is this trigger likely to fail if too many requests occur at the same time?

Hiya folks, so we have an already working Postgres database and we'd like to use Supabase for auth/user management. Is there any way to connect Supabase with an already live database?

Hi folks, how do I get access to my HMACSHA256 secret?

Congratulations Supabase Team!⚡  
Supabase is awesome, thrilled for y'all!

Hi.
Does anyone has a working example that using Auth for connecting multiple auth provider? basically I want to able to login using email and then connect with provider or connect first with single sign in and then connect with email

Is there anyway to migrate tables/schemas from hosted supabase instance to a self hosted instance?

Hey peeps, we are doing a supabase nextjs builderio live coding on CodingCatDev. If you want to join <@349883597374881802>_io and I to try something just DM me and I will hook you up with a link!

https://youtu.be/yPohaXjNqxU

Congrats on series B folks! I wish there was a community round 😦

<@443116621054345226> Leo from Supabase. Do you have the support ticket number so I can look deeper into your issue?

I'm having trouble inviting someone into my organization. Apparently the user I want to invite needs to sign up first separately. He did that. But his name doesn't come up in the list when I enter his email. Is there anything I can do?

I think you can just enter the email and add him.

<@734164270350205079> we’re in the process of overhauling our invite system.. but in the meantime, I think our search is case sensitive 😅 might be why you have no results

If it continues, file a support ticket so we can track it and get the frontend team to look at it.

<@&844001800214020128> Hello! My supabase database isn't responding anymore (both on client and on dashboard). Anyone can help? It's an emergency, the app is in prod with thousands of users 😅

I saw your support ticket and am in the process of responding there.

Where will I see the reply? I see it's fixed, thanks, but I would like to understand how it happened and how to prevent it to happen again 😉

Your api (kps) server went down after a flurry of high activity.  You should get an email from the ticket with my reply.

Basically your server was maxed out on RAM, so you may want to upgrade one notch to a "small" instance which gives double the ram of the "micro" instance.

also your api server's disk is 66% full which is a little unusual, must be large logs somewhere

Hi all. I'm new and I come investigating some of the Supabase virtues. Some of you can throw some light about its. We have a webapp using Nextjs and vercel and I'm seeing the integration will be aparently easy. We need only a few features around a database so it is important to not introduce quite more complexity

Hey! What are you looking to do? Supabase and Next play really well together — a lot of Supabase is built off Next in fact. Happy to help answer any questions you have!

Hello, Terry thanks a lot to reply me. I am looking for different solutions for storage and my question was so generic, sorry for that. But what I what to know is why I should take, or what are the advantages of Supabase solution instead of, for example, having my own MongoDB hosting by Atlas. I mean, at the project status we only need a DB, will be worthy adopt now althoug we increase the complexity of the project

I really apreciate your opinion and time 🙂 thx

Happy to help! I'm pretty biased, but I think Supabase is really great to work with :^)  It's advantage over Mongo, on the most basic level, is SQL — if you prefer SQL to document stores that is.  Otherwise, Supabase is a great option for adding what you need as you go. Just need a DB to start? Perfect.  Need users and auth down the road, no issue. Discover you need some kind of storage later on? That's there too. Then of course there's edge functions and realtime as well. Supabase puts a lot of built-in functionality in your back pocket for when you need it. Happy to answer any questions you have!

Thank a lot Terry 🙂 !! Your comment will be really useful

Hi <:vmathi:937589524299677739>, please avoid mentioning the Team role, even more if it's not critical

Can someone explain or point to documentation about what this means and how it works?
thx

Is anyone using Supabase with c# and dotnet?

There's a big community effort around C#:  https://github.com/supabase-community/supabase-csharp

Also check our github discussions to find other csharp developers:  https://github.com/supabase/supabase/discussions?discussions_q=csharp

Hey <@845250139706753044> same problem as 1-2 days ago.. if I take a paid plan will it still happen? 😦

Sorry I can't remember the issue here, I'm juggling a bunch of different stuff 😕

Sorry I don't remember the issue here, I'm juggling a bunch of different stuff 🙂

I'll be happy to look at your project if you give me a ticket number.  That'll have the project ref # on it and all I need.  Thanks!

i have this table for posts and each post have publisher uuid.
it's possible to prevent the publisher from updating specific column.
How can I do this using the RLS.

Hi <@472336562709987338> you could do this with a function and disable direct updates to the table.

Lots of other ways to do it. Check here: https://github.com/supabase/supabase/discussions/656