LevelSoft1165

Yes

That's awesome! You'll definetly see some stuff you should apply! Enjoy

Yeah its hard to adapt to each different paradigm because there are so many!

This is not AI slop at all my dude, Its like the 2nd time I have done this kinda thing and people love it.

Yes so I plan to make a video per project and then every month maybe make a recap of the 4 previous ones and their intersection, follow here :) [https://www.youtube.com/@theointechs](https://www.youtube.com/@theointechs)

For sure send me a DM.

Check your message requests because I sent you a message already!

I helped a lot of clients to migrate to self hosted for over a year now. Most don't regret and you save a lot of costs which is one of many advantages. I have a tutorial here: [https://youtu.be/ME3\_sT6b-Zs](https://youtu.be/ME3_sT6b-Zs) or if you wish you can DM me for more info.

I really suggest having at least 2 environments: dev and prod. For dev you can use the local docker setup (https://youtu.be/BceVcpiOlKM) or have a full fledge multiple environment setup that is isolated, this one shows how to have 3 environments (https://youtu.be/VH9KsGd-Uok).

Hey thank you, really appreciate it!

Vercel is free for a simple option, but if you want to play with a VPS and Linux you can use the Oracle Cloud Free Tier.

ahaha for sure!

You need to do it via the env variables, its the only way.

Yes totally!

Don't hesitate if you have any questions!

First off, Data Control which is a big one. OS control, it can really boost performance if you tweak the linux OS page file sizes and max ulimit, even postgres buffer sizes. Im just scratching the surface

I never had any problems with them even in self hosted and mirgation to prod...

Completly agree, you should know what you are doing at a minimum.

Time, because you need to manage it.

I suggest even better to add partioning by list (based on tenant) so you get full data isolate in terms of performance. I made a video about it: [https://youtu.be/6vLSMwOJXiE](https://youtu.be/6vLSMwOJXiE)

I really like this, I also feel like pganalyze is for big tech and also very expensive.

Send me a DM we can talk about it!

How does it differentiate from pganalyze which is open source?

I have a guide on this, its pretty simple: [https://youtu.be/ME3\_sT6b-Zs](https://youtu.be/ME3_sT6b-Zs)

Feel free to dm me!

Wow that's crazy lol

Sure see it here: [https://www.youtube.com/@theointechs](https://www.youtube.com/@theointechs)

That's a pretty cool setup you've got there with Supabase Edge Functions and Database Webhooks. It’s great to see a use case where you can bypass typical third-party solutions and still get real-time notifications directly to your iPhone. By using Supabase Edge Functions to quickly POST to a push notification API, you ensure that those notifications are promptly sent, which is essential for keeping up with critical, time-sensitive app events. Plus, leveraging Database Webhooks to trigger these functions on specific events without altering your app's code is a streamlined way to manage notifications. If anyone's curious about digging deeper into how Supabase Webhooks work, there's a helpful video called "Supabase Webhooks Finally Explained" that breaks down the concepts and practical applications really well. It might help you understand how to further expand on or optimize this notification setup. Here's the link to the video for reference: https://www.youtube.com/watch?v=Xmbd5f7tvCQ. This kind of setup can really elevate an app's real-time communication features while keeping the implementation neat and efficient.

Many developers find that Supabase scales quite well for small to medium-sized side projects, and it effectively handles tasks like authentication, database operations, and storage. However, the point where some begin to outgrow Supabase usually ties back to specific needs like complex data relationships, intricate transaction systems, or when the project's scale demands granular control over the server infrastructure. Performance might also become a concern as user count increases, although for many, the built-in scalability of Supabase suffices for quite a while. Pricing can also be a factor; as with most scalable solutions, you may find costs ramping up as you add more users or require more advanced functionalities. There's also the consideration of specific tooling or ecosystem compatibility, especially if there's a need to migrate to certain technologies that Supabase might not support as seamlessly. For a comprehensive understanding of how Supabase can fit into your workflow, especially during initial setups, the video "Ultimate Supabase Local Development Beginner Guide" offers great insights on tailoring your local development environment when working with Supabase. Check it out here: https://www.youtube.com/watch?v=BceVcpiOlKM. It can give you a clear idea of how to maximize Supabase's potential for your side projects.

A lot of the struggles you're facing with self-hosting Supabase are unfortunately pretty common. The lack of proper documentation and clear guidance on necessary workflows like migrations and storage setup can be really frustrating. Many users have reported similar issues, especially concerning the disconnect between self-hosting and the cloud version. A detailed guide like the one in the "Ultimate Supabase Local Development Beginner Guide" video could be really helpful. It walks through local development which might provide some insights into dealing with common pain points experienced during self-hosting, even if it's not an exact fit for a full production setup. While it won't solve the doc issues or guarantee you're fully aligned with Cloud features, it could offer some workarounds and help you navigate the parts of Supabase that are under-documented. Here's the link to check it out: https://www.youtube.com/watch?v=BceVcpiOlKM.

Migrating just the authentication piece while keeping the Supabase database is an interesting move, especially when you're not fully severing ties with the platform. The organization-level features you mention are critical for multi-tenant apps, and it's impressive how quickly you could integrate those with Clerk. Swapping out the auth provider does sound like a bit of a dance with updates to user ID types, JWT integration, and session flows. That catch about how intertwined Supabase's auth is with their RLS policies is crucial to know beforehand. You might appreciate how the video "FULL Database Access with Supabase MCP Server (Cursor)!" dives into leveraging Supabase's powerful database features while potentially complementing your setup with external tools. It gives a solid overview of how to maintain flexibility with your database layer while exploring different paths for other services, similar to your approach with Clerk. Understanding your database's capabilities can be a big help as you continue this hybrid setup. Here's the link to that video if you're interested: https://www.youtube.com/watch?v=lhnozwcHn7A. Your insights could be invaluable for those contemplating a similar shift. Being aware of how deeply integrated features like auth can influence your overall architecture is something not everyone anticipates, so thanks for sharing your experiences!

I made a guide on this, it might help you: [https://youtu.be/BceVcpiOlKM](https://youtu.be/BceVcpiOlKM)

I know I answered on the original post but for others I have a video to help on that: [https://youtu.be/Xmbd5f7tvCQ](https://youtu.be/Xmbd5f7tvCQ)

This sounds like a timeout issue, did you check the error message in the logs?

You should reach out to the Supabase team, maybe its something they'd want to implement in their CLI tool!

Interesting!

This is probably a auth issue, I have a video about webhooks on my YouTube channel if you want: [https://youtu.be/Xmbd5f7tvCQ](https://youtu.be/Xmbd5f7tvCQ)

Very interesting!

sirduke is right about that, having a computer science degree myself I totally agree that UML and entity diagrams are really powerful. I personally suggest a good old PlantUML or Draw IO can do the job.

I agree

I do have a video on exactly that If you need: [https://youtu.be/VH9KsGd-Uok](https://youtu.be/VH9KsGd-Uok)

Im already in SupaSquad.

Nothing beats pure C code, change my mind.

I have a video that could help people too I think: [https://youtu.be/ME3\_sT6b-Zs](https://youtu.be/ME3_sT6b-Zs)

I do agree, a lot of UI features are hidden and require activation or settings via ENV variables which makes it an incredible pain. I even had a client this week tell me he didn't want to use the local supabase instance because he hated it not being the same as his staging or prod environment.

I have a full guide if it interests you: [https://youtu.be/ME3\_sT6b-Zs](https://youtu.be/ME3_sT6b-Zs)

I made a video on that exact topic and I think it explains exactly what you want: [https://youtu.be/VH9KsGd-Uok](https://youtu.be/VH9KsGd-Uok)

I made a video on that exact topic and I think it explains exactly what you want: [https://youtu.be/VH9KsGd-Uok](https://youtu.be/VH9KsGd-Uok)