# SQL Alchemy With Ignition

**URL:** <https://forum.inductiveautomation.com/t/sql-alchemy-with-ignition/36408>\
**Category:** Ignition\
**Tags:** database, ignition79\
**Created:** [July 6, 2020, 9:02pm UTC](https://forum.inductiveautomation.com/t/sql-alchemy-with-ignition/36408 "2020-07-06T21:02:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![william.ivey](https://avatars.discourse-cdn.com/v4/letter/w/aca169/32.png) [@william.ivey](https://forum.inductiveautomation.com/u/william.ivey)\
**Post date:** [July 6, 2020, 9:02pm UTC](https://forum.inductiveautomation.com/t/sql-alchemy-with-ignition/36408/1 "2020-07-06T21:02:01Z")

</div>

Does anyone have any experience installing and/or using SQL Alchemy with Ignition (Vision or Perspective)?

Can anyone provide any pointers to get it installed and setup for use?

Much appreciation in advance.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 6, 2020, 9:12pm UTC](https://forum.inductiveautomation.com/t/sql-alchemy-with-ignition/36408/2 "2020-07-06T21:12:06Z")

</div>

Buried in the compatibility, it looks like SQLAlchemy doesn’t support Jython in general:  
[https://docs.sqlalchemy.org/en/13/dialects/mysql.html#module-sqlalchemy.dialects.mysql.zxjdbc](https://docs.sqlalchemy.org/en/13/dialects/mysql.html#module-sqlalchemy.dialects.mysql.zxjdbc)  
Beyond that, you’re also highly likely to have problems with Ignition’s shared DB connection model - ORMs likely want to manage their own connection pooling, so even if you got the library working you’ll need to write some kind of bridge code between what SQLAlchemy expects and Ignition’s database connections - or else, end up duplicating connection pools, so that Ignition (the gateway) and Ignition (your SQL Alchemy connection(s)) are separately connecting to your database.

---

<div class="post-metadata">

**Author:** ![william.ivey](https://avatars.discourse-cdn.com/v4/letter/w/aca169/32.png) [@william.ivey](https://forum.inductiveautomation.com/u/william.ivey)\
**Post date:** [July 6, 2020, 9:37pm UTC](https://forum.inductiveautomation.com/t/sql-alchemy-with-ignition/36408/3 "2020-07-06T21:37:10Z")

</div>

Thanks so much for the reply Paul. I was reading where it looked like it may have been compatible with Jython, but i’ll yield to the experts advice on this one.

It would be great if Ignition offered some type of data modeling tool that could be used within scripting. Maybe a feature in the future?