Supabase and Scalability
My question is: Does Supabase have the capacity to handle thousands of operations simultaneously in real-time? And is it a good practice to base my entire application on Supabase's real-time functionality, or is this considered a bad practice?
2 Replies
I don't have experience with Supabase, and I would like to know its capabilities regarding handling a large number of operations simultaneously. Is there a possibility of delays? And if so, what is the estimated delay time?
Postgres is very fast. Does that help? Probably not. There is no way to know without testing specific queries and loads. You might be able to do 500 operations a second on a free instance or 10 depending on complexity. You can scale compute to get more load.
Best to write a test and see.
Direct SQL will be faster than REST API.
Google on the web for Supabase and Postgres performance.
Example: https://pilcrow.vercel.app/blog/serverless-database-latency
Pilcrow
What's the fastest serverless database provider?
Measuring the latency of various database providers in a serverless environment.