Pocketbase: Single File Backend That Actually Scales

# Run Pocketbase on port 8090 instead of 80
./pocketbase serve --http 0.0.0.0:8090

# Set up reverse proxy (Nginx) to handle SSL and CORS
server {
    listen 443 ssl http2;
    server_name api.yourdomain.com;

    ssl_certificate /path/to/cert.pem;
    ssl_certificate_key /path/to/key.pem;

    location / {
        proxy_pass http://localhost:8090;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
        proxy_set_header X-Forwarded-Proto $scheme;

        # CORS for mobile
        add_header 'Access-Control-Allow-Origin' '*' always;
        add_header 'Access-Control-Allow-Methods' 'GET, POST, PUT, DELETE, OPTIONS' always;
        add_header 'Access-Control-Allow-Headers' 'Authorization, Content-Type' always;
    }
}

// Flutter code to fetch posts with expanded user relation
final records = await pb.collection('posts').getList(
  expand: 'user',  // This is the key! Tell Pocketbase to expand relations
  filter: 'published = true',
);

// For multiple relations
final records = await pb.collection('posts').getList(
  expand: 'user,category,tags',  // Comma-separated list
);

// Access expanded data
for (var record in records.items) {
  final user = record.expand['user'];  // Access expanded relation
  print('Post by ${user['name']}');
}

// Alternative: Use expand on specific fields
final record = await pb.collection('posts').getOne(
  recordId,
  expand: 'user',  // Works for single record too
);

// Flutter realtime subscription setup
// Subscribe to posts collection updates
pb.collection('posts').subscribe('*', (e) {
  switch (e.action) {
    case 'create':
      print('New post created: ${e.record['title']}');
      break;
    case 'update':
      print('Post updated: ${e.record['title']}');
      break;
    case 'delete':
      print('Post deleted: ${e.record['title']}');
      break;
  }
}, filter: 'published = true');  // Optional: filter events

// Important: Handle connection state
pb.collection('posts').subscribe('*', (e) {
  print('Event received: $e');
}, onError: (error) {
  print('Subscription error: $error');
});

// In Pocketbase admin UI, ensure API rules allow subscription:
// Settings → API Rules → Posts → Set "View" rule to allow access
// For public subscriptions, set: "id = @request.auth.id || published = true"

// Keep subscription alive (Flutter lifecycle)
@override
void dispose() {
  pb.collection('posts').unsubscribe();
  super.dispose();
}