Home Applications sqlalchemy-iris

sqlalchemy-iris

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
5
5 reviews
0
Awards
775
Views
0
IPM installs
5
6
Details
Releases
Reviews
Issues
Pull requests
Articles
An InterSystems IRIS dialect for SQLAlchemy

What's new in this version

  • Added support for the latest SQLAlchemy 2.0
  • Added support for Alembic (migration tool)
  • many bugfixes

sqlalchemy-iris

An InterSystems IRIS dialect for SQLAlchemy.

Pre-requisites

This dialect requires SQLAlchemy, InterSystems DB-API driver. They are specified as requirements so pip
will install them if they are not already in place. To install, just:

pip install sqlalchemy-iris

Usage

In your Python app, you can connect to the database via:

from sqlalchemy import create_engine
engine = create_engine("iris://_SYSTEM:SYS@localhost:1972/USER")

InterSystems IRIS

You can run your instance of InterSystems IRIS Community Edition with Docker

docker run -d --name iris \
 -p 1972:1972 \
 -p 52773:52773 \
 -e IRIS_USERNAME=_SYSTEM \
 -e IRIS_PASSWORD=SYS \
 intersystemsdc/iris-community:preview

Port 1972 is used for binary communication (this driver, xDBC and so on), and 52773 is for web (Management Portal, IRIS based web-applications and API’s).

The System Management Portal is available by URL: http://localhost:52773/csp/sys/UtilHome.csp

Read more
Made with
Version
0.10.002 May, 2023
Category
Frameworks
Works with
InterSystems IRISInterSystems IRIS for Health
First published
25 Oct, 2022