Test SSE adapter implementation for database realtime table broadcast

[SOG-web]

Description

We need to thoroughly test the SSE adapter implementation for database realtime table broadcast to ensure it works correctly in various scenarios and environments.

Testing Requirements

Unit Tests

• Test SSEManager class methods
• Test RealtimeAdapter interface implementation
• Test permission handling without fieldCheck rules
• Test pub/sub functionality

Integration Tests

• Test with NestJS application (using the existing integration in nest-test)
• Test with Express application
• Test with other HTTP server frameworks
• Test client-side SDK integration

Performance Tests

• Compare performance between WebSocket and SSE adapters
• Test with high message volume
• Test with many concurrent connections

Browser Compatibility

• Test in Chrome, Firefox, Safari, and Edge
• Test in mobile browsers
• Test behind proxies and load balancers

Edge Cases

• Test reconnection behavior
• Test with slow connections
• Test with connection interruptions
• Test with malformed messages

Acceptance Criteria

• SSE adapter works correctly in all tested environments
• Performance is comparable to or better than WebSocket adapter for read-only scenarios
• Client-side SDK can seamlessly switch between WebSocket and SSE adapters
• Documentation includes clear examples and best practices

Related Issues

• Implement SSE adapter for database realtime table broadcast #75 Implement SSE adapter for database realtime table broadcast