all-things-risingwave
How to connect to RisingWave from Java or Python for storing data in a streaming database and running SQL queries?
ML engineer looking to connect a Kafka consumer to RisingWave for storing ML model classifications in a streaming database and running SQL queries. Seeking documentation or examples on using JDBC drivers in Java or SQLAlchemy in Python with RisingWave.
Na
Nayan Shah
Asked on Oct 26, 2022
- RisingWave currently supports connecting via psql.
- For JDBC/Sqlalchemy, full support is on the roadmap, but users can connect by filling in parameters passed in psql.
- Python users can use psycopg2, and Java users can use JDBC with RisingWave.
- The process involves connecting, running simple queries, and reading results, similar to setting up an app to query a PostgreSQL database.
- No need to implement new drivers as JDBC support is already available in RisingWave.
Oct 26, 2022Edited by