Will we ever be able to use hosted supabase on GCP?

sure, will take a look tonight!

thanks for the PR 🙂

it would be very interesting.

how come you need this @User ?

Add a Documentation about how to USE

Database

with Python

seems like they are available in python discord but not in other servers

i'm building a ml pipeline with supabase storage (images + videos) and google tpus (hopefully), so using google cloud storage + google's servers makes sense for latency and data transfer costs

Would it be possible to have a "Bring Your Own S3" for object storage in hosted supabase? I'd love to use the storage features in supabase-js but having to move my CDN over entirely is... not something I'd be looking forward to

ah yes I see

maybe open an issue here: https://github.com/supabase/storage-api

apparently it's already supported in the storage-api, but I meant more like being able to also set a

S3_URL

when using

createClient

from supabase-js itself

when i get the time i can open an issue for that

If Supabase is going to be a firebase alternative, then we as a community should also plan on something for the PUSH notification service, which is heavily used in firebase.

- would be neat to see a cache layer that runs on top of the db that can be used to fetch data without having to read from the db directly. this is something i've done a million times with firebase and i've never really liked how counter-intuitive it is. running a query vs fetching from cache is bound to be faster in certain cases. - run joins, CTEs before realtime changes are streamed to the client.

how about using view https://supabase.io/blog/2020/11/18/postgresql-views

for #2?

you can't use a view if you do the join based on some data available at the client right?

I really want a good support to python version

You can improve it by contributing to the python package of supabase since it's open-sourced, @! Class self.PythonAddict = True.

yea but I can only do that when I know that

One thing you can do right now is sharing supabase to other python users. They will help improving the package for python when they use it as their main dependency to support their projects. @! Class self.PythonAddict = True

You can use a view along with a db function in this case.

I think a nice alternative to db caching is caching on the client instead, so you can cache certain information into localStorage or indexedDB

Btw DB caching is hard, even more hard when you are trying to create a universal solution for all users

would love to see some code for this, shoot me a DM when you've got time

not really referring to db caching, but a caching service that you could deploy on top of supabase's db that would play well with the db itself, aka cache management will be done via the consumer not supabase. kinda like if you'd use memorystore for firestore but with a less verbose api to get common work done easily, easy to setup etc.

Start a topic on the discussion board with the kind of query you are doing on the client and I will reply with a way of doing it with a view and db function. https://github.com/supabase/supabase/discussions

Looking forward it too.

Merged. Thanks for the PR 🙂