Connect to IRIS with Python?

Python, InterSystems IRIS

I have seen the Cache Python binding documentation and would like to know if it's also possible with IRIS so I can write data and also read/get it from the DB? The cachesys folder does not contain any python libraries.

Answers

Answer by Vitaliy Serdtsev 16 July 2018

Components Installed by Setup Type: ^{IRIS, Caché}

Unfortunately, Perl/Python Binding supported only on the x86-32 bit platform, but IRIS is only supported for x86-64.

Comment by Jasenko Donlagic 17 July 2018

Thanks. I assume I could still connect with something like this if I get it to work? https://pypi.org/project/JayDeBeApi/#usage

Comment by Vitaliy Serdtsev 17 July 2018

REST, JDBC - of course.

+ 2

Comment by Benjamin DeBoe 23 July 2018

or leveraging pyspark, as explained in this article

+ 1

Comment by Jasenko Donlagic 24 July 2018

Thanks, I will look into this, for now I'm getting the desired results with REST and CURL.

Comments

Comment by Athanassios Hatzis 24 July 2018

You can definitely compile and install cache-python binding module on x86-64 machines. I have done this on Ubuntu and it produced (pythonbind3-1.0-py3.6-linux-x86_64.egg). I am not sure I understand why it cannot be installed on IRIS x86-64bit platform. If you install python binding on IRIS I will be also interested in testing my CacheORM object-relational mapper.