Article Heloisa Paiva · Mar 15 5m read How to start Using VsCode Introduction In the next few weeks, my coworkers are planning to start using VSCode to code with InterSystems' products. Among the many advantages of that, I would emphasize being able to connect with other technologies, such as GitHub, with ease. Besides, VSCode also offers an extensive extensions store, where you can find many free add-ons that make coding faster and more efficient. Last but not least, to conquer the heart of every developer, it is open source. #Debugging #GitHub #JSON #ObjectScript #Open Source #Studio #Tools #Tutorial #VSCode 9 2 2 399
Article Heloisa Paiva · Feb 6 7m read About the idea of Using Python Class Definition Syntax to create IRIS classes Introduction Not so long ago, I came across the idea of using Python Class Definition Syntax to create IRIS classes on the InterSystems Ideas Portal. It caught my attention since integrating as many syntaxes as possible gives visibility to InterSystems’s products for programmers with experience in many languages. #Interoperability #Multi-model #Python #Tutorial #InterSystems Ideas Portal #InterSystems IRIS 8 3 0 423
Article Heloisa Paiva · Nov 14, 2023 7m read Example of Flask application with SQLAlchemy-IRIS - Part 2 Why should you connect Flask to InterSystems IRIS? The first thing that comes to mind when we think about combining Flask with IRIS is a portal to interact with your clients and partners. A good example would be a website for patients to access their clinical exams. Of course, this case would require a whole new layer of security, which we did not cover in our last article. However, we can effortlessly add it with Werkzeug, for instance. #Innovatium #Python #InterSystems IRIS #Open Exchange Open Exchange app 5 0 0 331
Article Heloisa Paiva · Oct 25, 2023 20m read Example of Flask application with SQLAlchemy-IRIS - Part 1 Index Part 1 Introducing Flask: a quick review of the Flask Docs, where you will find all the information you need for this tutorial; Connecting to InterSystems IRIS: a detailed step-by-step of how to use SQLAlchemy to connect to an IRIS instance; Part 2 A discussion about this kind of implementation: why we should use it and situations where it is applicable. #Innovatium #Python #InterSystems Ideas Portal #InterSystems IRIS #Open Exchange Open Exchange app 6 2 0 600
Article Heloisa Paiva · Sep 21, 2023 1m read New application iris-size-django on OpenExchange Why to use it This app offers an easy interface to analyze storage: Filter by database (namespace), global name, used size, or allocated size; View a sum of the used and allocated sizes for the filters applied; Export the table to JSON, CSV, or XML. How to use it Follow the instructions on the README file from the GitHub repository, and configure the settings to connect to your instance. #Innovatium #InterSystems IRIS #Open Exchange Open Exchange app 5 0 1 188
Article Heloisa Paiva · Aug 30, 2023 6m read Using SQLAlchemy to transfer tables to and from IRIS Case description Let’s imagine that you are a Python developer or have a well-trained team specialized in Python, but the deadline you got to analyze some data in IRIS is tight. Of course, InterSystems offers many tools for all kinds of analyses and treatments. However, in the given scenario, it is better to get the job done using the good old Pandas and leave the IRIS for another time. #Best Practices #Innovatium #Python #SQL #InterSystems IRIS #Open Exchange 4 3 2 586
Article Heloisa Paiva · Aug 23, 2023 18m read A portal to manage storage made with Django - Part 2 Our objective Today we continue expanding our last article by sharing information about some features we added to our portal. We will include a pinch of CSS to visualize the available data better and export it. Finally, we will study how to add some filtering and ordering options. By the end of this article, you should be able to display a complete simple query beautifully. #Innovatium #InterSystems IRIS 8 2 2 249
Article Heloisa Paiva · Jul 4, 2023 10m read A portal to manage storage made with Django - Part 1 Our objective In the last article, we talked about a few starters for Django. We learned how to begin the project, ensure we have all the requisites, and make a CRUD. However, today we are going a little further. Sometimes we need to access more complex methods, so today, we will connect IRIS to a Python environment, build a few functions and display them on a webpage. It will be similar to the last discussion, but further enough for you to make something new, even though not enough to feel lost. #Cloud #Innovatium #Python #InterSystems IRIS 4 0 1 266
Article Heloisa Paiva · Jun 12, 2023 11m read Examples to work with IRIS from Django Introducing Django Django is a web framework designed to develop servers and APIs, and deal with databases in a fast, scalable, and secure way. To assure that, Django provides tools not only to create the skeleton of the code but also to update it without worries. It allows developers to see changes almost live, correct mistakes with the debug tool, and treat security with ease. To understand how Django works, let’s take a look at the image: #Innovatium #Python #InterSystems IRIS 12 9 3 727
Article Heloisa Paiva · May 3, 2023 10m read Change Message Viewer trace to JSON instead of XML Programming and languages Being a programmer nowadays is basically the geek version of being a polyglot. Of course, most of us here, in the InterSystems Community, “speak ObjectScript”. Howeever, I believe this wasn’t the first language for many people. For instance, I had never heard about it prior to getting the appropriate training at Innovatium. #Innovatium #JSON #REST API #Tutorial #XML #InterSystems Ideas Portal #InterSystems IRIS #Open Exchange Open Exchange app 8 8 3 756
Article Heloisa Paiva · Mar 17, 2023 2m read Types in Python and in ObjectScript Why I've decided to write this In my last article I've talked about returning values with Python. But returning them is simple, what can make it harder is what I'm going to talk about today: where the value is treated. Python object in IRIS Following the example of the last aricle, we have the method: #Embedded Python #Innovatium #Python #InterSystems IRIS 6 0 2 402
Article Heloisa Paiva · Mar 10, 2023 3m read Creating an ODBC connection - Step by Step Introduction This article is intended to be a simple tutorial on how to create ODBC connections and working with them, since I found starting with them a little bit confused, but I had amazing people to take my hand and walk me through it, and I think everyone deserves that kind of help too.I'm going to divide each little part in sections, so feel free to jump to the one you feel the need to, although I recommend reading everything. #Innovatium #ObjectScript #ODBC #SQL #Tutorial #InterSystems IRIS 10 0 1 620
Article Heloisa Paiva · Mar 9, 2023 2m read SQLAlchemy - the easiest way to use Python and SQL with IRIS's databases Introduction In some of the last few articles I've talked about types between IRIS and Python, and it is clear that it's not that easy to access objects from one side at another. Fortunately, work has already been done to create SQLAlchemy-iris (follow the link to see it on Open Exchange), which makes everything much easier for Python to access IRIS' objects, and I'm going to show the starters for that. #Innovatium #Python #SQL #Tutorial #InterSystems IRIS #Open Exchange Open Exchange app 15 3 2 1.3K
Article Heloisa Paiva · Mar 2, 2023 3m read Quick sample database tutorial Introduction This is a simple tutorial on the quickest way I found to create a sample database for any purposes such as testing, making samples for tutorials, etc. Creating a namespace Open the terminal Write the command "D $SYSTEM.SQL.Shell()" Write "CREATE DATABASE " and the name you want for your namespace. Now you have a new namespace in a faster way than creating it from the Management Portal - which of course offers way more configuration options. #Innovatium #SQL #Tutorial #InterSystems IRIS 9 5 1 338
Article Heloisa Paiva · Feb 22, 2023 4m read Export to JSON - relationships and inheritance Why I've decided to write this Once again I had a challenge that costed me some time and a lot of testing to reach the best solution. And now that I've managed to solve it, I'd like to share a little bit of my knowledge. What happened? In a namespace there were a lot of similar classes, so to make them simpler there were a superclass with comon properties. Also, there are relationships between them. I had to export one of them to JSON, but I couldn't change the superclasses, or I would break down the flow of many other integrations. #Innovatium #JSON #Tools #InterSystems IRIS 4 0 1 345
Article Heloisa Paiva · Feb 17, 2023 2m read Returning values with python Why am I writting this? Last year I made an article for starters on using embedded python. Later, it started a little discussion on how to return values with python and I found some interesting observations that are worth writing a little article. Also, hopefully I can reach more people by writing this. Possible situations There are two things you'll need to care about when returning a value with python. The first is the type you're trying to return and the second is where you're returning it. #Embedded Python #Innovatium #Python #InterSystems IRIS 3 0 0 431
Article Heloisa Paiva · Jan 16, 2023 7m read Token Authentication - Basics you need to start coding Why I decided to write this Recently I had the challenge to create a secure authentication method to authorize access to some data, but unfortunately I had zero experience with those security configurations and I felt that I was missing some basic concepts to have a better understanding of the official documentation. After studying and managing to deliver the classes that I was asked to develop, I'd like to share a little bit of my new knowledge, which helped me follow the topics in the documentation. #Access control #Authentication #Innovatium #InterSystems IRIS 6 0 1 391
Article Heloisa Paiva · Sep 22, 2022 4m read Python and IRIS in practice - with examples! Here you'll find a simple program that uses Python in an IRIS environment and another simple program that uses ObjectScript in a Python environment. Also, I'd like to share a few of the troubles I went trough while learning to implement this. Python in IRIS environment Let's say, for example, you're in an IRIS environment and you want to solve a problem that you find easy, or more efficient with Python. You can simply change the environment: create your method as any other, and in the end of it's name and specifications, you add [ Language = python ]: #Best Practices #Innovatium #Python #InterSystems IRIS 11 9 5 1.8K
Article Heloisa Paiva · Sep 2, 2022 4m read Interoperability - Step to step on creating and connecting business hosts I recently started to study interoperability and I found the official documentation very helpful in understanding how it works, though I still had some trouble implementing it myself. With the help I got from my coworkers, I managed to create a Demo of a system and learn through practice. Because of that, I decided to write this to help others with "getting their hands dirty" and share the help I got. #Innovatium #Interoperability #InterSystems IRIS 3 3 0 389