Below is the simple comparison of the two database as a service products.
supabase uses a relational database management system called PostgreSQL, it offers a free-tier hobby plan with:
Up to 500MB database & 1GB file storage
Up to 2GB bandwidth
Up to 50MB file uploads
Real time Postgres Changes
Unlimited API requests
sanity.io is a schemaless database built on top of Google cloud, it offers a free-tier plan with:
Up to 10k (1GB) Documents & 5GB assets
10GB Bandwidth (per month)
Real-time data access
5GB file uploads
500k API requests (per month)
Additional notes:
Sanity is comparable to Firebase in how they store data, where firestore allows you to store βdocumentsβ. sanity.io is also the same and they basically use their plan. Thus, it may also be a viable option to switch to Firebase.
Description: Basically, when you update the profile account detail on another device, the changes of the user object may not reflect the latest details of account if they are already logged in.
Potential solution: Get the latest account details on first startup.
When switching to another account, for example demo to user.
This only seem to happen on safari browser, on ios.
The pages will show the demo user's data instead of the user's data. It requires a manual refresh for the data to show.
A potential fix is to remove the @lib/demo.data file, and just query the demo data from sanity.
Edit: This might have to do with an issue with next-auth session not updating/clearing properly. See nextauthjs/next-auth#4612