I'm exploring RisingWave for my Trading project and I'm interested in using a Websocket Source for the lowest-latency approach. I'm considering two approaches:
I'm looking for guidance on whether RisingWave supports Websocket sources and which approach would be more suitable in terms of latency and design. Additionally, I'm open to contributing to a proof of concept if needed.
Bosco DSouza
Asked on Nov 27, 2023
Currently, RisingWave does not support Websocket sources directly. However, the team is actively considering adding this feature. For now, the suggested approach is to ingest data into RisingWave using the SQL INSERT command, which is more flexible and allows for custom business logic before writing the data. RisingWave is designed to handle large ingestion throughput, with an estimated capacity of 30k events per second per node. It's recommended to set latency expectations between 500ms to 1s for RisingWave. A proof of concept and real workload testing are encouraged to better understand performance.