Right now we're 100% focused on moving to Beta, but next we are investigating how to do storage and functions. Let us know what you want us to work on - we rely on the community to help us prioritize
I havent played around with supabase yet but the functionality thats important for my use case would be to sort on multiple columns and filter on multiple columns using >,<, =, <> and array_in. Thats whats currently available in firebase. Are all this capabilities currently available?
that's great! Are there any comparisons of latency of various read and write operations compared to firebase do you know? or do you plan to make that available? Also, thinking about long term how scalable is this solution? I know firebase has been around for a while and has scaled well at high request rates with low latency. Cost can sometimes be huge depending on how you pull content. How does supabase compare? Is there any documentation around this?
One other question regarding subscription. I saw on your website that you're able to read events on a specific table as well as for specific operation such as INSERT, UPDATE, DELETE etc. What I did not see was an example of subscribing to a query results. Is there a way to subscribe to a results of a query such as "select * from customers where name='xxx' and age='xx' order by dateCreated" so that the client gets real time data of this resulset everytime without having to refresh? I know that you can do this in firebase but I didn't see a similar example on your site.
Thanks so much in advance! This will be super useful as the answers to this questions might just convince me to move from firebase to supabase :)
read and write operations compared to firebase
Since it's just Postgres, it will be a lot faster
Cost can sometimes be huge depending on how you pull content. How does supabase compare? Is there any documentation around this?
At the moment we are free to use because we're in Alpha. We will likely be cheaper than Firebase at scale. They of course have a very generous free tier. We will have a free tier too, but we are still working out the details.
Is there a way to subscribe to a results of a query
No, unfortunately not (at least not yet). Something we're working on :)
Ah ok. Very helpful. Thanks so much Copple!
That very last point is HUGE for our use case. That's in fact why we're using firebase. I'll be keeping an eye on Supabase until that feature is available. :)
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Can you discuss what are the features of firebase you are working on next?
Right now we're 100% focused on moving to Beta, but next we are investigating how to do storage and functions. Let us know what you want us to work on - we rely on the community to help us prioritize
I havent played around with supabase yet but the functionality thats important for my use case would be to sort on multiple columns and filter on multiple columns using >,<, =, <> and array_in. Thats whats currently available in firebase. Are all this capabilities currently available?
yes we have all of that! supabase.io/docs/library/get
that's great! Are there any comparisons of latency of various read and write operations compared to firebase do you know? or do you plan to make that available? Also, thinking about long term how scalable is this solution? I know firebase has been around for a while and has scaled well at high request rates with low latency. Cost can sometimes be huge depending on how you pull content. How does supabase compare? Is there any documentation around this?
One other question regarding subscription. I saw on your website that you're able to read events on a specific table as well as for specific operation such as INSERT, UPDATE, DELETE etc. What I did not see was an example of subscribing to a query results. Is there a way to subscribe to a results of a query such as "select * from customers where name='xxx' and age='xx' order by dateCreated" so that the client gets real time data of this resulset everytime without having to refresh? I know that you can do this in firebase but I didn't see a similar example on your site.
Thanks so much in advance! This will be super useful as the answers to this questions might just convince me to move from firebase to supabase :)
We're setting up benchmarks now github.com/supabase/benchmarks
Ah ok. Very helpful. Thanks so much Copple!
That very last point is HUGE for our use case. That's in fact why we're using firebase. I'll be keeping an eye on Supabase until that feature is available. :)