[3.0] Investigate Supabase

[humphd]

I wonder if we could use a self-hosted https://supabase.com/, (project is on https://github.com/supabase/supabase). https://www.youtube.com/watch?v=WiwfiVdfRIc is a good overview.

One of my longer term goals is to move toward running Telescope in the cloud. I haven't figured out how to fund that (yet), so in the meantime we probably need to create our own cloud instead. Since we're already slightly invested in a Firebase-type model (see Users service, thanks to @chrispinkney), we could consider going toward Supabase and self-host our own instance via docker.

Currently they have:

• Database (built on top of postgres, adding REST APIs, websocket real-time) and Object Storage (like S3)
• Auth and user management (not sure how easy it would be to hook into this with our SAML auth)
• a killer dashboard UI to monitor and control things

They are working on adding functions, which would be a killer feature for us, since we could move toward servless. I like that it's also written in a tech stack that we could help fix (mostly TS/JS).

NOTE: I'm not saying we should do this. I'm just thinking out loud in issues :)

[humphd]

This is how to self-host: https://supabase.com/docs/guides/hosting/overview

[DukeManh]

If I remember correctly, self-hosted Supabase doesn't have a dashboard.

[humphd]

@DukeManh they open sourced it today! https://news.ycombinator.com/item?id=29401589

[DukeManh]

@humphd That's awesome news.

[cindyorangis]

I've been struggling with Next Auth and Prisma at work for who knows how long. This issue has motivated me to give Supabase a try. It actually looks super promising. If I get Supabase working at work, I'll share my knowledge with everyone at Telescope via blog post or Slack :)

[DukeManh]

I am very keen on Firebase and have worked with it for some time.
Because Supabase is a Firebase alternative I'd like to give this a try.

I'll investigate and come back here with what I learn.

[humphd]

Cool. Another option we can consider, if this ends up being too heavy-weight, is to add a db ourselves (postgres, sqlite, etc). We should only take this on if it gives us something we need vs. makes our setup and admin too complicated.

Thanks for looking into this. I think it might be cool to add this, esp. when they include serverless functions.

[chrispinkney]

@DukeManh Might be worth investigating Appwrite too! But it's very early stage AFAIK, but I think recently secured some funding which is cool?

[HyperTHD]

I know a little bit about Supabase, having used it a bit in one of my frontend projects on the side. I can help a bit with research here so putting myself in this journey

[humphd]

https://medium.com/@gracew/using-supabase-rls-with-a-custom-auth-provider-b31564172d5d looks useful

[cindyorangis]

Are we still investigating Supabase? I see it has been added to Telescope in #2743

[humphd]

Agree, closing.