Skip to main content

Supabase Sync

Sync data using a free PostgreSQL cloud database.

What is Supabase?​

Supabase is an open-source Firebase alternative that provides a free PostgreSQL database and object storage.

Advantages​

  • ✅ Generous free tier (500MB database + 1GB storage)
  • ✅ Cross-platform (iOS/Android)
  • ✅ Real-time sync
  • ✅ Full data control

Configuration Steps​

1. Register Supabase​

Visit supabase.com to create an account.

2. Create Project​

  1. Click "New Project"
  2. Enter project name
  3. Set database password
  4. Select region (Asia recommended for Asian users)
  5. Create project

3. Create Storage Bucket​

  1. Click "Storage" in the left menu
  2. Click "New bucket"
  3. Enter bucket name: beecount-backups
  4. Do not check Public bucket (keep it Private)
  5. Create bucket

4. Configure RLS Policies​

To allow the app to read and write data properly, you need to configure RLS (Row Level Security) policies to ensure users can only access their own data:

  1. Go to "Storage" → Select beecount-backups bucket
  2. Click the "Policies" tab
  3. Create the following 4 policies:
Policy NameOperation
Allow user SELECTSELECT
Allow user INSERTINSERT
Allow user UPDATEUPDATE
Allow user DELETEDELETE

Each policy should be configured the same way:

  • Target roles: Select authenticated
  • Policy definition: Enter the following expression
((bucket_id = 'beecount-backups'::text) AND ((storage.foldername(name))[1] = 'users'::text) AND ((storage.foldername(name))[2] = (auth.uid())::text))

This policy ensures users can only access files in the beecount-backups/users/<their-user-id>/ path.

5. Get Configuration Info​

In "Project Settings" → "API", find:

  • Project URL - Project address
  • anon public key - Public API key

6. Configure BeeCount​

  1. Go to "Me" → "Cloud Service"
  2. Select "Supabase"
  3. Enter Project URL
  4. Enter anon key
  5. Enter Storage Name: beecount-backups
  6. Save and test connection

Notes​

  • Free tier has some limitations, but sufficient for personal use
  • Inactive projects may be paused (log in within 7 days to restore)
  • Recommend regular data export backups