Product setup guide: Ember

To begin, navigate to Supabase. Here, you will need to create an organisation. This is essential as it serves as the container for your projects. Fill in the required details, such as the organisation name, and click on the "Create" button. Once created, you will be redirected to your organisation dashboard.

After setting up your organisation, head to Supabase Projects. Click on the "New Project" button. You will be prompted to enter a project name, select a database password, and choose a region for your database. Ensure that the project name is unique within your organisation. Once you have filled in the details, click "Create Project" to proceed.

Once your project is created, navigate to the SQL Editor. Here, you can execute SQL commands to set up your database schema. Copy the SQL script from this Pastebin link and paste it into the SQL editor. After pasting, click the "Run" button to execute the script. This will create the necessary tables and relationships in your database.

Go to Supabase API Settings and copy your three API keys (URL, Anon public, and Service Role) into your .env file.

If you want to use the invoice feature with Stripe, you will also need to copy your Stripe secret key into the .env file.

Go to User Management and create a new login by clicking "Add user". Then, copy the ID of the new user, go to Table Editor, open the "panel_settings" table, add a new row with that user ID, and set the license_active to true/false, depending on whether you want the user to have access or not.

If you wish to implement row-level security policies for your tables, refer to this guide. Row-level security allows you to control access to rows in your tables based on user roles. This is particularly useful for applications that require different access levels for different users. Follow the instructions in the guide to set up the necessary policies.