Skip to main content

RisingWave dialect for SQLAlchemy

Project description

RisingWave dialect for SQLAlchemy

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. https://www.sqlalchemy.org/

RisingWave is a cloud-native streaming database that uses SQL as the interface language. It is designed to reduce the complexity and cost of building real-time applications. https://www.risingwave.com

Prerequisites

For psycopg2 support you must install either:

(The binary package is a practical choice for development and testing but in production it is advised to use the package built from sources.)

Install

Install via PyPI

pip install sqlalchemy-risingwave

Recommend install packages locally like below. If directly from PyPI, the version may not be the most updated.

python setup.py sdist bdist_wheel # generate dist
pip install -e . # install this package

Usage

sqlalchemy-risingwave will work like a plugin to be placed into runtime sqlalchemy lib, so that we can overrides some code path to change the behaviour to better fits these python clients with RisingWave.

See how to use with Superset: doc

Develop

Install pre-req.

pip install sqlalchemy alembic pytest psycopg2-binary

Test

We use pytest for unittest.

pytest # to run the test

Ref

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy-risingwave-1.1.0.tar.gz (12.2 kB view details)

Uploaded Source

Built Distribution

sqlalchemy_risingwave-1.1.0-py3-none-any.whl (11.5 kB view details)

Uploaded Python 3

File details

Details for the file sqlalchemy-risingwave-1.1.0.tar.gz.

File metadata

  • Download URL: sqlalchemy-risingwave-1.1.0.tar.gz
  • Upload date:
  • Size: 12.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.11.8

File hashes

Hashes for sqlalchemy-risingwave-1.1.0.tar.gz
Algorithm Hash digest
SHA256 72f34b0c46a70bfb8ad28b690b92bdf03b6fb025662c5b5da94a8b2220357454
MD5 50f7dc9c306143d449192e36e21f88d7
BLAKE2b-256 f6890efd833429e3f99b95e544f4501d60a2d42d08710cd6cdefcc09d38d2eea

See more details on using hashes here.

File details

Details for the file sqlalchemy_risingwave-1.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for sqlalchemy_risingwave-1.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 6159a6d4eb2e6cdeed7f5106818f3c98573c57ef0b66836fb5eb7bc3f95d8d68
MD5 422ce25a2c30516470d2cad250b9e9d2
BLAKE2b-256 fa3b24c4418c5f9b620f6ca2f05328e4acb6cc54182d3c32d5db6cc38d8e8ca4

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page