Question José Pereira · Sep 3 Autocommit pandas dataframe rows into IRIS Hi, I'm getting an unexpected behavior when using pandas function to_sql(), which uses sqlalchemy-iris. After the first execution, a transaction seems to be opened and all rows inserted are lost after closing the connection: #Python #InterSystems IRIS 0 2 0 63
Article José Pereira · Aug 2 28m read Text to IRIS SQL with LangChain An experiment on how to use the LangChain framework, IRIS Vector Search, and LLMs to generate IRIS-compatible SQL from user prompts. This article was based in this notebook. You can run it with a ready to use environment with this application in OpenExchange. Setup First, we need to install the necessary libraries: #Best Practices #Databases #Python #SQL #Vector Search #InterSystems IRIS Open Exchange app 10 8 4 329
Article José Pereira · May 14 11m read Q&A Chatbot with IRIS and langchain TL;DR This article introduces using the langchain framework supported by IRIS for implementing a Q&A chatbot, focusing on Retrieval Augmented Generation (RAG). It explores how IRIS Vector Search within langchain-iris facilitates storage, retrieval, and semantic search of data, enabling precise and up-to-date responses to user queries. Through seamless integration and processes like indexing and retrieval/generation, RAG applications powered by IRIS enable the capabilities of GenAI systems for InterSystems developers. #Artificial Intelligence (AI) #Generative AI (GenAI) #Python #Tools #Unstructured Data #Vector Search #InterSystems IRIS Open Exchange app 4 3 2 331
Article José Pereira · Jan 30 5m read Converting generic data into FHIR with IRIS-FHIRfy Background In 2021, I participated as an InterSystems mentor in a hackathon, where a newcomer to FHIR asked me if there was a tool to transform generic JSON data containing basic patient information into FHIR format. I informed her that I didn't know anything like that, unfortunately. But that idea stays in my mind... Several months later, in 2022, I came up with an idea to experiment: to train a named entity recognition (NER) to identify FHIR elements into generic texts. The training involved synthetic FHIR data generated by Synthea and the spaCy Python library. #FHIR #Large Language Model (LLM) #InterSystems IRIS for Health Open Exchange app 3 2 0 285
Article José Pereira · Jul 9, 2023 3m read Using iknowpy to do analytics on logs from iris-fhir-generative-ai As said in the previous article about the iris-fhir-generative-ai experiment, the project logs all events for analysis. Here we are going to discuss two types of analysis covered by analytics embedded in the project: #Artificial Intelligence (AI) #Analytics #FHIR #Generative AI (GenAI) #Natural Language Processing #InterSystems Natural Language Processing (NLP, iKnow) #InterSystems IRIS BI (DeepSee) #InterSystems IRIS for Health Open Exchange app 2 0 1 221
Article José Pereira · Jul 3, 2023 11m read An experiment on generative AI and FHIR This project is an experiment to use OpenAI API to answer to user prompts in the healthcare domain using FHIR resources and Python code. #Artificial Intelligence (AI) #FHIR #Generative AI (GenAI) #Large Language Model (LLM) #InterSystems IRIS for Health Open Exchange app 8 11 0 1.6K
Question José Pereira · Dec 11, 2022 Can't get a valid access token in FHIR Server with OAuth2 Hi! I'm playing with OAuth2 with FHIR Server, but returned tokens cause 401 or 403 errors when trying to get FHIR resources. I tried using fhir-client.js and Postman. Access tokens returned have been failing for both, with a 401 when trying through fhir-client.js and a 403 using Postman. Here are my settings: #FHIR #OAuth2 #InterSystems IRIS for Health 0 0 0 340
Article José Pereira · Nov 29, 2022 12m read IS technologies supporting the Pregnancy Symptoms Tracker app In this article, I’d like to present details of which technologies we had been using to develop our application for the IRIS for Health Contest: #FHIR #REST API #Access control #InterSystems IRIS Open Exchange app 1 0 0 286
Article José Pereira · Sep 13, 2022 10m read IRIS Flow - Updates for Interoperability Contest: Building Sustainable Solutions TL;DR: you can try the chatbot created with IRIS Flow here; if you'd like to understand how it was created, read this article. If you prefer, you can follow the tutorial within this article in this video: #Interoperability #InterSystems IRIS Open Exchange app 3 0 0 197
Article José Pereira · Jun 5, 2022 6m read The Flow Editor application IRIS Megazord In the first article about IRIS Megazord, Henrique explains what drove us to create such an application. It basic is a composition of these previous project which we did: #Interoperability #InterSystems IRIS Open Exchange app 2 0 0 289
Article José Pereira · May 2, 2022 16m read gRPC - what is it and a hello world Introduction This article aims to give an introduction to what gRPC is and an example of how to play with the official Hello World using IRIS Embedded Python. You can find all the code exposed here, in this project repo. #Embedded Python #InterSystems IRIS 12 5 0 1.9K
Question José Pereira · Apr 7, 2022 Inserting an index without reconstruction Hi! I'd like to know if there are any issues if an index is inserted into a table without running the %BuildIndices() method. It's important to note that data inserted before the index is not important for retrieval, so it's not a problem data inserted before the index don't show up in queries. The reason why I'm asking this is that I'd like to avoid index reconstruction on big tables which I need to inser such index. I'm using Cache 2018.1. Thanks, José #Databases #Indexing #SQL #Caché 0 8 0 310
Article José Pereira · Apr 5, 2022 4m read Serializing Python objects in globals Motivation This project was thought of when I was thinking of how to let Python code deal naturally with the scalable storage and efficient retrieving mechanism given by IRIS globals, through Embedded Python. My initial idea was to create a kind of Python dictionary implementation using globals, but soon I realized that I should deal with object abstraction first. So, I started creating some Python classes that could wrap Python objects, storing and retrieving their data in globals, i.e., serializing and deserializing Python objects in IRIS globals. #Data Model #Embedded Python #Globals #Python #InterSystems IRIS #Open Exchange Open Exchange app 6 1 1 2.3K
Article José Pereira · Jan 13, 2022 2m read A practical example on using Python with ObjectScript I'd like to share an example on how the new Embedded Python feature in IRIS helped me in my daily routines. While I’m participating in the iris-kaggle-socrata-generator project with Henrique Dias, I got to unzip datasets from Kaggle in order to import them. #Embedded Python #Python #InterSystems IRIS Open Exchange app 5 2 0 829
Article José Pereira · Dec 27, 2021 12m read Using Python to Implement an IMAP Client in InterSystems IRIS In the previous articles, we learned the basics of using IMAP protocol to handle messages from mailboxes in an e-mail server. That was cool and interesting, but you could take advantage of implementations created by other ones, available in libraries ready to use. #Embedded Python #Interoperability #Python #InterSystems IRIS 3 1 1 595
Article José Pereira · Dec 22, 2021 5m read ZAP API scan GitHub action What about having your IRIS REST APIs scanned every push you did and being reported on possible vulnerabilities? This is what I am going to show you in this article. #API #GitHub #REST API #Security #InterSystems IRIS #Open Exchange Open Exchange app 7 0 0 1.4K
Article José Pereira · Dec 21, 2021 8m read IntegratedML hands-on lab Have you tried the InterSystems learning platform lab for IRIS IntegratedML? In that lab you can train and test a model on a readmission dataset and be able to predict when a patient will be readmitted or not, or calculate its probability of being readmitted. You can try it without any installation on your system, all you have to do is start a virtual lab environment (Zeppelin) and play it around! #IntegratedML #InterSystems IRIS 9 2 2 561
Article José Pereira · Oct 23, 2021 4m read A brief introduction on how to draw diagrams with mermaid library Hello everyone! Me and @Henrique.GonçalvesDias proposed a new way to visualize messages in IRIS Interoperability in a recent update of MessageViewer. In such an update, we tried to give users a visualization based on a UML sequence diagram. You could get more information on the previous article. #Frontend #Interoperability #JavaScript #InterSystems IRIS Open Exchange app 2 0 0 1.3K
Article José Pereira · Sep 15, 2021 10m read Implementing an IMAP Client in InterSystems IRIS - part II In the first part we got a quick introduction on the IMAP protocol commands, now it's time to use IRIS and implement them and create our own IMAP client! #InterSystems IRIS 4 0 1 643
Article José Pereira · Sep 1, 2021 6m read Implementing an IMAP Client in InterSystems IRIS - part I This article explains how to use the InterSystems IRIS platform to write a basic IMAP client. First, we present an overview of IMAP, then we discuss the main IMAP commands and client implementation. Finally, we offer a simple use of this IMAP client on the IRIS interoperability application. #InterSystems IRIS 5 0 1 653