Hey Developers,

We'd like to invite you to join our next contest dedicated to creating useful tools to make your fellow developers' lives easier:

🏆 InterSystems Developer Tools Contest 🏆

Submit an application that helps to develop faster, contributes more qualitative code, and helps in testing, deployment, support, or monitoring of your solution with InterSystems IRIS.

Duration: January 23 - February 12, 2023

Prize pool: $13,500

12 8
1 628
InterSystems Developer Community is a community of 12,212 amazing developers
We're a place where coders learn and share, stay up-to-date, grow together and have fun!

Dear DC members,

We're super excited to share with you our latest Developer Community feature!

🔥 YOUR 2022 RECAP 🔥

Each member now has access to their personalized 2022 activity summary – an overview of their contributions, including the number of posts, comments, views, top and favorite posts / tags, and much more!

10 12
0 331
Article
Benjamin De Boe · Jan 10 4m read
Columnar Storage in 2022.3

As you may well remember from Global Summit 2022 or the 2022.2 launch webinar, we're releasing an exciting new capability for including in your analytics solutions on InterSystems IRIS. Columnar Storage introduces an alternative way of storing your SQL table data that offers an order-of-magnitude speedup for analytical queries. First released as an experimental feature in 2022.2, the latest 2022.3 Developer Preview includes a bunch of updates we thought were worth a quick post here.

8 2
3 212

Because I had no idea how to build an integration solution for HL7 and didn't know where to start, I decided to follow the course Building Basic HL7 Integrations with InterSystems on Learning portal to get at least the idea of where to begin. After I studied all of it, I decided it might be a good idea to share my thoughts and reflections about it with everyone.

8 1
4 254
Announcement
Udo Leimberger · Dec 30, 2022
Happy New Year

Dear community!

It was an amazing 2022 with all of you. Great questions and articles around the whole year and this brings us the most valuable gifts -- wisdom and knowledge.
I want to thank you all for a great year full of fun and pleasure.

This community rocks.

7 6
0 137
Hey Community,
Please check out the 2022 Annual Dev Community Article Digest with the most popular and commented articles.
Thank you all for your contributions to the InterSystems Community in 2022!
General Stats
1676 posts published in 2022:
– 277 articles
– 481 announcements
– 870 questions
– 48 discussions
2,338 members joined the Developer Community in 2022
10,640 posts published all time
12,061 members joined all time
6 3
1 223

Hello Community,

Some of you have passed the InterSystems Official Certification and would like to get a nifty green tick on your profile avatar

and all your certificates in your DC profile so that others know that you know... you know what we mean

So, to add certification to your DC profile, you need to take 3 easy steps:

1️⃣ Go to your DC profile

2️⃣ Go to the InterSystems Certification section

3️⃣ Click on the Load my certification(s) button

and that's it!

5 2
0 66

It's time to announce the Winners for December! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in December:

🥇 @Cristiano Silva , InterSystems Developer at First Line Software

🥈 @Iryna.Mykhailova , Associate professor, Igor Sikorsky Kyiv Polytechnic Institute

🥉 @Rob Schoenmakers , Integration specialist at SInt Maartenskliniek

Learn more about the competition and our awesome winners below.

5 3
0 124
Discussion
Eduard Lebedyuk · Jan 20
Code Golf: Pyramid

New Year, new Code Golf!

You will receive a positive integer for the number of floors. Your challenge will build a pyramid with a "#" character. As usual, the shortest solution wins.

Input

3

Output

  #
 ###
#####

also a valid output

  #  
 ### 
#####
4 23
1 263
Hey Community,
Here is the 2022 Annual Dev Community Question Digest. Let's check out the most popular questions from InterSystems Developers!
General Stats
870 questions published in 2022
6,546 questions published all time
Most Popular
3 6
0 192

cover

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:

3 0
0 60
Article
Robert Cemper · Jan 23 2m read
Global-Streams-to-SQL

In general Global Streams are data objects embedded in Classes / Tables.
Using and viewing them with SQL is normally a part of the access to the containing tables.

SO WHAT?

During debugging or searching for strange or unexpected behavior there could be the need to
get closer to the stored stream. No big problem with direct access to Globals with SMP or Terminal.
But with SQL you are lost.
So my tool provides dynamic access to Global Streams wherever you may need this
Special thanks to @Oliver Wilms for the inspiration for this tool.

3 0
0 50

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.

3 0
1 108

Hey Developers,

Thank you so much for staying with InterSystems Developer Community for yet another year!

Day in and day out our team is trying to make it better and more useful for each and every one of our 12K+ members!

We'd like to know how useful the Developer Community is for you at this point. Please take a few moments to let us know what you think and what could be improved:

👉🏼 InterSystems Developer Community Annual Survey 2022 👈🏼

Note: The survey will take less than 5 minutes to complete.

3 0
1 51

Applications that work with bill payments and receipts, as well as the delivery and inventory of items, generally require the use of barcodes or QR Codes. The latter is used in even broader scenarios since the QR Code can store more information than a simple bar code. Thus, it is important to have the ability to generate barcodes and QR Codes or read the data stored in them from an image or a PDF. This article will show you how to do this using Python and some of its free libraries.

2 1
2 165
Article
Robert Cemper · Jan 23 2m read
Global-Streams-to-SQL #2

Some technical background information

There is not just one class in this package: rcc.gstream.cls but also rcc.gstreamT.cls

While rcc.gstream works with direct access to the stream globals, the *T version uses
a Process Private Global (PPG) as Temporary storage.
using SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar.

2 0
0 43