Description
It takes more time to load the site when the page is not specified. This is because the app needs to send two requests in order to know which page to display. The first request is to find the website id, and the second one is to find the default page.
We can speed up the process by creating a Postgres function in Supabase that will handle those two things so the app only has to send one request to get the default page.
Requirement
Create a Postgres function in Supabase that accept the subdomain or domain as an argument and return the default page object
Acceptance Criteria
The app only need to send the domain/subdomain to Supabase to get the default page
Description
It takes more time to load the site when the page is not specified. This is because the app needs to send two requests in order to know which page to display. The first request is to find the website id, and the second one is to find the default page.
We can speed up the process by creating a Postgres function in Supabase that will handle those two things so the app only has to send one request to get the default page.
Requirement
Create a Postgres function in Supabase that accept the subdomain or domain as an argument and return the default page object
Acceptance Criteria
The app only need to send the domain/subdomain to Supabase to get the default page