Introduction #
SmartChart supports SQLAlchemy as a universal database connection method. SQLAlchemy provides ORM-level access to various databases including MySQL, PostgreSQL, SQL Server, Oracle, SQLite, and more through a unified interface.
Supported Databases #
| Database | Driver Example |
|---|---|
| MySQL | mysql+pymysql://user:pass@host:3306/db |
| PostgreSQL | postgresql://user:pass@host:5432/db |
| SQL Server | mssql+pyodbc://user:pass@host/db |
| Oracle | oracle://user:pass@host:1521/db |
| SQLite | sqlite:///path/to/db.sqlite |
Usage #
Create a connection pool with the SQLAlchemy driver URL, then write SQL queries normally in the dataset editor.
Use Cases #
- When the standard SmartChart driver doesn’t support your database
- When you need ORM-level database access
- For databases that only have Python SQLAlchemy drivers available