What is RisingWave?

RisingWave is an open-source SQL streaming database designed for processing and analyzing real-time data streams at scale. Built with cloud-native architecture, RisingWave simplifies stream processing with standard SQL, enabling businesses to extract valuable insights from streaming data without the complexity of traditional streaming frameworks.

Key Features

  • SQL-Based Stream Processing: Uses familiar SQL syntax for stream processing tasks
  • Materialized Views: Continuously updated views that reflect the latest state of your data streams
  • Event Time Processing: Process events based on when they occurred rather than when they arrived
  • Scalable Architecture: Easily scales horizontally to handle growing data volumes
  • Exactly-Once Semantics: Ensures reliable processing even in the face of failures
  • Integration with Data Sources: Connects seamlessly with Kafka, Pulsar, Redpanda, and other data systems
  • Low-Latency Analytics: Delivers millisecond-level insights on streaming data

Common Use Cases

  • Real-Time Analytics: Monitor business metrics and KPIs as they change
  • Anomaly Detection: Identify unusual patterns in streaming data
  • IoT Data Processing: Process and analyze data from connected devices
  • Financial Data Analysis: Track market movements and trading patterns in real-time
  • User Behavior Tracking: Understand how users interact with applications

Connecting

To connect to RisingWave in VS Code using DBCode, follow these steps:

  1. Open the DBCode Extension: Launch Visual Studio Code and open the DBCode extension.
  2. Add a New Connection: Click on the “Add Connection” icon in the sidebar.
  3. Complete the connection form:
    • Select “RisingWave” as the database type
    • Enter your host address
    • Specify the port (default is 4566)
    • Enter your username (default is root)
    • Enter your password if configured
    • Optionally specify a database name
  4. Save and Connect: Click the save button to establish your connection.
  5. Start Managing Your Streaming Data: Once connected, you can browse database objects, write and execute SQL queries, and visualize your streaming data results.

For detailed instructions on connecting to RisingWave and other databases, refer to the Connect article.

Working with RisingWave in DBCode

After connecting to RisingWave, you can:

  • Create and manage materialized views to continuously transform streaming data
  • Write SQL queries to analyze real-time data
  • Set up source connectors to ingest data from Kafka, Pulsar, and other systems
  • Create sinks to output processed data to external systems

By using RisingWave with DBCode, you can connect to your streaming databases, query and manage your real-time data streams, and visualize your results, all directly from Visual Studio Code.

For more information about RisingWave, check out RisingWave or visit their GitHub repository.