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.
• The OpenExchange Application: if you are not interested in the development of this example, you can go directly to this section and learn how to use it as a template for your flask-iris application.
• Bonus: some errors I have faced

Hey Community!

Welcome to the 8th edition of the InterSystems Ideas news bulletin! Here's what you can expect from it:

​​​​✓ New video describing all pages of the Ideas Portal  

✓ Ideas implemented since the previous news bulletin

⏯Watch the video: Join the Hall of Fame

Attention all developers!

Get ready to revolutionize your testing process with iris-tripleSlash, the ultimate unit test solution.

Say goodbye to boring and repetitive unit testing and hello to effortless and efficient testing.

With iris-tripleSlash, you can easily generate unit test cases using the power of automatic documentation.

For several years now Visual Studio Code has supported the notebook coding paradigm with a maturing UX and an API that is enabling a notebook extensions ecosystem to grow. One of the best-known notebook platforms is Jupyter Notebooks. A Microsoft team publishes an extension that allows VS Code to handle .ipynb notebook files. These can either work against a local Python environment or connect to a Jupyter Server, which typically hosts remote Python environments with beefier resources.

What if your InterSystems IRIS environments, whether local on your workstation or remote in your organization / cloud, could operate as Jupyter Servers? And not only for Embedded Python but also for ObjectScript and SQL

"If we build it, will they come?"

In today's landscape, enterprises have grown substantially in scale, amassing vast amounts of data. This data is collected from a plethora of sources including different applications, databases, and other channels. Given the diversity and volume of this data, it's only logical for these enterprises to seek a deeper understanding of what their data entails. Some of the data can be stored in IRIS, and it can be reasonable to be able to add this data to a data lake too.

The Internet now offers many different tools for such tasks, that do not yet support IRIS, but it's achievable. 

What do you

Hi Community
In this article, I will introduce my application IRIS-FlaskBlog.
IRIS-FlaskBlog Application is a real-world application that leverages the functionality of Flask web framework, SQLALchemy ORM, and InterSystems IRIS. The application contains user registration and authentication with the help of Flask-Login python library, a responsive user interface to create and edit posts.
 

Application Features

• User registration and authentication
• Creation of a data structure with SQLALcemy model classes
• Responsive user interface to create, edit, and delete posts
• Like and add comments to the

Hi Community!

Our 2nd InterSystems Idea-A-Thon has come to an end and resulted in 29 brilliant ideas dedicated to the topic of the contest:

💡 Run solutions fast, safe, and green with InterSystems IRIS 💡 

Thank you all for your ideas, comments, and votes!

And now it's time to announce the winners...

Hey guys,

I do love Global Masters (and all the rewards that I get from it) and one of my favourite activities is answering quiz questions. And just now I've had a really cute question What is the result of: WRITE "99" + "cents"? which brought a smile to my face (because I do love to add questions like this to the tests for my students). This made me think that I would really like to somehow show my appreciation to the author of this question. 

Thus, I created an idea to add something like a 👍 to a quiz question.

Hi Developers!

We’re happy to invite you to the contest dedicated to your bright ideas related to InterSystems technology:

🎁 The 2nd InterSystems Idea-A-Thon 🎁

Post an idea according to the topic of this Idea-A-Thon between August 01 and August 21 and receive a guaranteed prize.

Both InterSystems employees and Community Members are invited to participate!

>> SUBMIT YOUR IDEA HERE <<

When creating custom Business Hosts, it's often necessary to add properties to the class for additional settings that will be used in the initialization or operation of the host. The property name itself isn't always very descriptive, so it's an advantage to have a custom caption display with the field.

In Caché, it was fairly straightforward:

TEST> Set^CacheMsg("EnsColumns","en-us","<property name>") = "<caption>"

But It involves a bit more effort in IRIS ...

In IRIS, the caption names of business host and production properties are stored in ^IRIS.Msg("EnsColumns"), which is normally mapped

There are several ways of classifying cryptographic algorithms: 1) Secret Key Cryptography (SKC) - Uses a single key for both encryption and decryption. It is also called symmetric encryption. Primarily, it was used for privacy and confidentiality; 2) Public Key Cryptography (PKC) - Uses one key for encryption and another one for decryption. It is also called asymmetric encryption. Initially, it was utilised for authentication, non-repudiation, and key exchange; 3) Hash Functions - Uses a mathematical transformation to irreversibly "encrypt" information, providing a digital fingerprint.

Hey everyone, 

Here we are again. New year, new contest, new project, old reasons.

Triple Slash is in the house!

Some time ago I introduced a new driver for Django for IRIS. Now, let's see how to use Django with IRIS in practice.

Hibernate is the most popular framework to do ORM (Object Relational Mapping) projects.With Hibernate a software can use the main DBMS in the market, including the capability to change the database vendor any time, without source code impact.This is possible because the Hibernate supports dialects.Each database product has a different dialect that can be assigned into a configuration file.So, if a software is using Oracle and is looking to evolve to InterSystems IRIS, just change the configuration file with connection and dialect information.

Hi Developers!

Welcome to the 7th edition of the InterSystems Ideas news bulletin! Read on to learn what has happened on the Ideas Portal since the previous bulletin:

​​​​✓ More than 200 ideas are already on the portal 

✓ Idea was implemented by a Community member

✓ Implement an idea and get a tech bonus on the Grand Prix 23 Contest

✓ Ideas posted recently

REST API for Security Package

Hi community,

In this article, we will learn how to set up a REST API for the IRIS Security Package. We will be able to create users, roles, add applications, etc... by simple HTTP requests as well as generate a client application in ObjectScript.

Requirements

We need :

1. An IRIS instance (installation kit or docker).
2. ObjectScript package manager (ZPM).
3. (Optional) A second IRIS instance to generate an ObjectScript client.

We will use a set of existing applications and libraries on OpenExchange. The package manager (ZPM) will make their installations much easier.

Hey Community!

Welcome to the 6th edition of the InterSystems Ideas news bulletin! This time you can read about:

​​​​✓ Ideas implemented last month by Community members

✓ How to create a new idea on InterSystems Ideas

✓ New ideas created recently

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.

The most fascinating part of this is that even though we are able to learn any language and become fluent in it, we will always have our favorites – the ones we feel more comfortable and familiar with, and, as a rule, it has a lot to do with the

Apache Superset is a modern data exploration and data visualization platform. Superset can replace or augment proprietary business intelligence tools for many teams. Superset integrates well with a variety of data sources.

And now it is possible to use with InterSystems IRIS as well.

An online demo is available and it uses IRIS Cloud SQL as a data source.

Hey Community!

Here is a short article on how to create an idea on InterSystems Ideas. 

0. Register on Ideas Portal if you aren't a member yet or log in. You can easily register using your InterSystems Developer Community ID.

1. Read carefully Portal Guide page on the Ideas Portal, especially "Idea promotion rules" section. All posted ideas are moderated following these rules.

2. Click on the "Add a new idea" button

and you will see the form to add the idea.

3.First, provide a one-sentence summary of the idea which is the required field.

It is a recommended security practice to login into sensitive Administrator Portals without any input passwords. Thus, it is necessary to identify and authenticate the users correctly. A common technique employed by web portals and mobile applications is to use Google social login. Today, Google Gmail has 2 billion users (source:https://www.usesignhouse.com/blog/gmail-stats). Therefore, it is a perfect shared login service to utilize to login InterSystems IRIS users when they need to manage their instances. This article will detail all the steps to embed Google Login into your InterSystems Management Portal.

Register your InterSystems instance in the Google Console

1. Go to https://console.cloud.google.com and log in with your Google user account.
2. On the header click Select a project:

Hi All, 

We are excited to announce that, starting on February 22, 2023, you will earn Global Masters points for your product ideas on the InterSystems Ideas Portal!

Hi Developers!

Welcome to the 5th issue of the InterSystems Ideas News! This time you can read about:

​​​​✓ Hall of Fame - a new page on the Ideas Portal

✓ Integration with Global Masters - get points for your ideas

✓ List of ideas that are planned for implementation

Hi everybody!

Many developers prefer a dark version of applications. Not surprisingly, @Guillaume Rongier posted an idea of making a dark version for the Developer Community. 

So we look forward to hearing from you.

Please send us your feedback by using this Poll on the Ideas Portal, and by voting and commenting on the relevant idea.

Thank you in advance for your votes and have a good day!

Hey Community!

Welcome to the 4th edition of the InterSystems Ideas News bulletin!

Here's what you can expect from it:

• Support your teammates with their ideas and votes.
• Users implemented ideas and gained tech bonuses for a contest.
• Dark version for InterSystems Developer Community: Yay or Nay?
• Recently added ideas.

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Understanding your InterSystems Login Account & Where to Use It @ Global Summit 2022

Hi Community,

In the first part, we describe all packages, used libraries and REST services.

Now, I would like to add some details about converter and validator services.

By default, OpenAPI-Suite sends an HTTP request to converter.swagger.io if the specification version is less than 3.0 and another HTTP request to validator.swagger.io to simplify the structure of the specification document.  

Although the usage of online utilities is convenient, in some cases it could be better to have our own instance of the converter and validator.  For example, if OpenAPI-Suite is provided on a server in an organisation for ObjectScript developers, it may be preferable to avoid requests to external services (privacy, avoid request rate limits). 

Just run: 

docker run -d -p 8085:8080 --name swagger-converter swaggerapi/swagger-converter:latest
docker run -d -p 8086:8080 --name swagger-validator-v2 swaggerapi/swagger-validator-v2:latest

Hey community! 

It's time to elevate your unit tests to the next level with iris-TripleSlash new solo feature!

We are bring to the game Setup and Tear down events!
Just add description on class, with special tags like:

• beforeAll
• beforeOne
• afterAll
• afterOne

The tripleSlash will turn it to:

• OnBeforeAllTests
• OnBeforeOneTest
• OnAfterAllTests
• OnAfterOneTest

And that's not all! The new double dot abbreviation feature allows you to effortlessly call methods and simplify your code, i.e.:

///<example>/// Write ..TheAnswerForEverything()/// 42///</example>

TripleSlash will automatically

Hey Community! 

Welcome to the 3rd edition of the InterSystems Ideas news bulletin! Curious about what has happened on the Ideas Portal since the previous one? Read on!

First of all, we've created a short video that explains the lifecycle of the ideas on the Portal:

⏯ Lifecycle of ideas on the InterSystems Ideas

Hello Community!

Welcome to the new edition of the InterSystems Ideas News! Learn what we've been up to this past couple of weeks.