Article Henry Pereira · Sep 29, 2024 3m read Unleashing the Power of Vector Search with SQL-Embedding InterSystems IRIS 2024 recently introduced the vector types. This addition empowers developers to work with vector search, enabling efficient similarity searches, clustering, and a range of other applications. In this article, we will delve into the intricacies of vector types, explore their applications, and provide practical examples to guide your implementation. #Databases #Performance #SQL #Vector Search #InterSystems IRIS Open Exchange app 5 0 1 84
Article Henry Pereira · Aug 1, 2024 4m read Building a frontend using only Python Frontend development can be a daunting, even nightmarish, task for backend-focused developers. Early in my career, the lines between frontend and backend were blurred, and everyone was expected to handle both. CSS, in particular, was a constant struggle; it felt like an impossible mission. #Contest #Python #InterSystems IRIS Open Exchange app 5 3 2 363
Article Henry Pereira · May 18, 2024 5m read Imagine the Future of Medical Triage: MediCoPilot Current triage systems often rely on the experience of admitting physicians. This can lead to delays in care for some patients, especially when faced with inexperienced residents or non-critical symptoms. Additionally, it can result in unnecessary hospital admissions, straining resources and increasing healthcare costs. #Contest #Embedded Python #Interoperability #Vector Search #InterSystems IRIS Open Exchange app 2 0 0 145
Article Henry Pereira · Jan 16, 2023 14m read Create and Read MS Word documents with ePython In this article, I will show you how one can easily create and read Microsoft Word documents using InterSystems IRIS with the leverage power of embedded Python. Setup First things first, let’s install the Python module called python-docx. There are a lot of modules to write MS Word files in Python. However, this one is the easiest one to use. Just execute the following command on the terminal: #Embedded Python #InterSystems IRIS 14 7 6 1K
Question Henry Pereira · Oct 15, 2022 Metaprogramming in ObjectScript With $Property is possible to dynamically get and set values on property of an instanced class and with $ClassMethod is possible to invoke methods from a class. I would like to know: Is there an elegant way to do Write and Set dynamically on variables without using Xecute? #ObjectScript #Caché #InterSystems IRIS 0 6 0 280
Article Henry Pereira · Apr 6, 2022 7m read So, Where's my money? All of us know that money is important. We constantly need to monitor all expenses to avoid looking back to the bank statement and thinking: “So, where’s my money?” #Artificial Intelligence (AI) #Embedded Python #Vector Search #InterSystems IRIS 3 0 0 1.6K
Article Henry Pereira · Dec 1, 2021 5m read Data anonymization, introducing iris-Disguise First of all, what is data anonymization? According to Wikipedia: #Best Practices #InterSystems IRIS Open Exchange app 24 12 3 1.3K
Article Henry Pereira · Sep 10, 2021 3m read Pop Songs Analytics I really love documentaries! Last weekend I was watching a Netflix documentary called This is Pop, because it was Analytics Contest time and I thought: Why not creating a pop song analytics with InterSystems Iris? #Analytics #Contest #InterSystems IRIS Open Exchange app 4 7 0 411
Article Henry Pereira · Aug 2, 2021 8m read Let's fight against the machines! Easy, easy, I'm not promoting a war against the machines in the best sci-fi way to avoid world domination of Ultron or Skynet. Not yet, not yet 🤔 I invite you to challenge the machines through the creation of a very simple game using ObjectScript with embedded Python. #Artificial Intelligence (AI) #Best Practices #Embedded Python #Python #InterSystems IRIS 42 8 5 1.4K
Question Henry Pereira · Mar 12, 2021 Hierarchical Queries Hi community, I need to write an SQL query with hierarchical order, I have a table with a column referencing itself, similar as the sample bellow: #Caché 0 4 0 257
Question Henry Pereira · May 20, 2020 How to select a random row from a table? Hi community, I need to write an SQL query to fetch a random record from a table, that table has millions of data. In postgresql, for example, there is a RANDOM() function to do something like that: SELECT column FROM table ORDER BY RANDOM() LIMIT 1 Is it possible to do something like that in Caché? Thanks in advance #Caché #InterSystems IRIS 0 8 0 776
Announcement Henry Pereira · Mar 27, 2020 Give it a try on SQLBuilder tool SQLBuilder is a flexible and powerful SQL query string builder for InterSystems IRIS, With SQLBuilder you have nice and clean object oriented methods, instead of having to use concatenation and substituition to generate dynamic queries. A Dynamic SQL without SQLBuilder A Dynamic SQL with SQLBuilder #Contest #Docker #ObjectScript #InterSystems IRIS #InterSystems IRIS for Health #Open Exchange Open Exchange app 11 18 5 680
Article Henry Pereira · Sep 16, 2019 6m read Power BI Connector for InterSystems IRIS. Part I In an ever-changing world, companies must innovate to stay competitive. This ensures that they’ll make decisions with agility and safety, aiming for future results with greater accuracy.Business Intelligence (BI) tools help companies make intelligent decisions instead of relying on trial and error. These intelligent decisions can make the difference between success and failure in the marketplace.Microsoft Power BI is one of the industry’s leading business intelligence tools. With just a few clicks, Power BI makes it easy for managers and analysts to explore a company’s data. This is important because when data is easy to access and visualize, it’s much more like it’ll be used to make business decisions. #Analytics #Best Practices #InterSystems IRIS 9 9 2 2.9K
Article Henry Pereira · Apr 11, 2019 10m read Brief introduction to Test Driven Development with Caché and CosFaker Hello everyone, I was first introduced to TDD almost 9 year ago, and I immediately fell in love with it. Nowadays it's become very popular but, unfortunately, I see that many companies don't use it. Moreover, many developers don't even know what it is exactly or how to use it, mainly beginners. #Best Practices #Testing #Caché #InterSystems IRIS Open Exchange app 26 7 10 1.5K
Article Henry Pereira · May 16, 2017 3m read The COS Faker Hi Community,This post is to introduce one of my first project in COS, I created when started to learn the language and until today I'm keeping improve it. The CosFaker(here on Github) is a pure COS library for generating fake data. cosFaker vs Populate Utils So why use cosFaker if caché has the populate data utility? #Caché #Ensemble #ObjectScript 10 8 2 999