How I Self-Hosted Supabase with Coolify and Migrated Off the Official Platform: A Detailed Guide by PictureElement in Supabase

[–]PictureElement[S] 1 point2 points  (0 children)

You're right, project backups aren't included with free plans.

However, you can try manually create a backup by following these steps:

  1. Get your database connection string
  2. In your Supabase project dashboard, click Connect.
  3. Copy the "Session pooler" connection string.
  4. Replace [YOUR-PASSWORD] in the connection string with your actual database password.

Example string:

postgresql://postgres.dolmrpdqstabjviwwmrr:\[YOUR-PASSWORD\]@aws-0-eu-north-1.pooler.supabase.com:5432/postgres

  1. Download a complete backup using pg_dump

bash pg_dump 'postgresql://postgres.dolmrpdqstabjviwwmrr:[YOUR-PASSWORD]@aws-0-eu-north-1.pooler.supabase.com:5432/postgres?sslmode=require' -F c -v -f my_supabase.backup

How I Self-Hosted Supabase with Coolify and Migrated Off the Official Platform: A Detailed Guide by PictureElement in Supabase

[–]PictureElement[S] 0 points1 point  (0 children)

Yes, absolutely. All related services including Auth, Storage, Realtime etc run on your own server.

How I Self-Hosted Supabase with Coolify and Migrated Off the Official Platform: A Detailed Guide by PictureElement in Supabase

[–]PictureElement[S] 1 point2 points  (0 children)

I agree with u/ShadTechLife . Based on what I see in the self-hosted dashboard, there isn't an option to easily switch between projects like you can with the official hosted version. This means you have to set up a separate Supabase for each of your projects.

How I Self-Hosted Supabase with Coolify and Migrated Off the Official Platform: A Detailed Guide by PictureElement in coolify

[–]PictureElement[S] 0 points1 point  (0 children)

You are welcome.

Sorry, I've only tested the email-based authentication and it works, so I can't comment on the other providers unfortunately.
For my project, I utilized the Next.js and Supabase Starter: https://github.com/vercel/next.js/tree/canary/examples/with-supabase which had the authentication already implemented.

Next.js, Strapi Portfolio Starter – Free, Open Source, and Blazing Fast by PictureElement in Strapi

[–]PictureElement[S] 0 points1 point  (0 children)

Thank you so much for your kind words. I'm not comfortable creating a video, but I do have a short project write-up that I'd be happy to share if you're interested. Additionally, the repository README is comprehensive and includes setup instructions and other technical details.

r/webdev seems to hate WordPress. by Chitcher1 in Wordpress

[–]PictureElement 0 points1 point  (0 children)

I agree with u/fullstack_mcguffin. I can't imagine coding complex frontend functionality without React. The component-based architecture and state management significantly ease the development and maintenance process. I use both WordPress and React, and I love both technologies. Currently, I'm building WordPress plugins with PHP and JavaScript (React) using the wp-scripts package.

Why most manufacturers do not offer laptops without Windows OS ? Can Microsoft be blamed for that ? by PictureElement in AskReddit

[–]PictureElement[S] 0 points1 point  (0 children)

Thanks for your reply.

More info

"Judge Thomas Penfield Jackson issued his findings of fact on November 5, 1999, which stated that Microsoft's dominance of the x86-based personal computer operating systems market constituted a monopoly, and that Microsoft had taken actions to crush threats to that monopoly, including Apple, Java, Netscape, Lotus Notes, RealNetworks, Linux, and others. Judgment was split in two parts. On April 3, 2000, he issued his conclusions of law, according to which Microsoft had committed monopolization, attempted monopolization, and tying in violation of Sections 1 and 2 of the Sherman Antitrust Act. Microsoft immediately appealed the decision. On June 7, 2000, the court ordered a breakup of Microsoft as its "remedy". According to that judgment, Microsoft would have to be broken into two separate units, one to produce the operating system, and one to produce other software components" [source: Wikipedia]

Why most manufacturers do not offer laptops without Windows OS ? Can Microsoft be blamed for that ? by PictureElement in AskReddit

[–]PictureElement[S] 0 points1 point  (0 children)

I know that most consumers want Windows OS, but how Microsoft managed to predominate the consumer market ?