#Contest

As part of the Open Exchange competition Salford Royal (Dean White and Mark O'Reilly) developed a REST API for sharepoint as a template that works but can also be a starting point to your own Rest Applications 

Prerequisites

This is using the v1 REST sharepoint API you need a tennant id, client id, client secret and tennant name 

Setup 

Configure an OAuth server

The code in the middle is the tennant ID 

Create a client config name as whatever you want 

Set up the oauth client replacing your server ip with the ip of the server you are on (not the VIP address- if not part of a VIP localhost may work) 

The latest "Bringing Ideas to Reality" InterSystems competition saw me trawling through the ideas portal for UI problems to have a go at. 

Hi Community,

We'd like to thank the participants of our first InterSystems Tech Video Challenge, who created nine interesting videos, wrote five articles, and uploaded two applications. And now it's time to announce the winners!

Let's meet the winners and look at their videos:

Hi Community,

A huge thank you to everyone who joined our InterSystems Tech Video Challenge! We’re thrilled to have all these interesting videos.

Don’t forget to check out the bonuses for the videos below:

Hello, Community!

It's time for the next InterSystems Developer Community contest!

✍️ InterSystems IRIS Technical Tutorial Contest ✍️

Create a Technical Tutorial** that can be considered a guide for InterSystems IRIS programmers of any level: beginner/intermediate/senior, from October 14th to November 24th. The tutorial can be in the form of an Article with text and images and/or a Demonstration Video.

Enjoy and let your creativity flow! Show how easy and fun it can be to create solutions with InterSystems IRIS.

🎁 Prizes for everyone: A special prize for each author participating in the competition!

Hi Community,

It's time to announce the winners of the Developer Tools Contest! 

Thanks to all our amazing participants who submitted 17 applications 🔥 

Now it's time to announce the winners!

Hi Developers!

We are happy to present the bonuses page for the applications submitted to the DevTools Contest 2024!

Hi Community,
In this article, I will introduce my application iris-DataViz
iris-DataViz is an Exploratory Data Analysis and Visualization Streamlit Application that leverages the functionality of IRIS embedded python and SQLAlchemy to interact with IRIS, as well as the PyGWalker python library for data analysis and data Visualization. PyGWalker (Python Graphic Walker) is an interactive data visualization library built for Python, aiming to bring the ease and functionality of Tableau-style drag-and-drop visualization into Python environments.

Application Features 

Hi Community,

It's voting time! Cast your votes for the best applications in our Developer Tools Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Hi 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: September 9 - 29, 2024

Prize pool: $14,000

Here are the technology bonuses for the InterSystems Developer Tools Contest 2024 that will give you extra points in the voting:

• IRIS Vector Search usage -3
• Embedded Python usage -3
• WSGI Web Apps - 2
• InterSystems Interoperability - 3
• InterSystems IRIS BI - 3
• VSCode Plugin - 3
• FHIR Tools - 3
• Docker container usage -2 
• ZPM Package Deployment - 2
• Online Demo -2 
• Implement InterSystems Community Idea - 4
• Find a bug in Embedded Python - 2
• Code Quality pass - 1
• Article on Developer Community - 2
• The second article on Developer Community - 1
• Video on YouTube - 3
• YouTube Short - 1
• First Time Contribution - 3

See the details below.

Hello developers!

Last year, for the first time, we held the Technical Article Contest on Japan's InterSystems Developer Community, and 📣 we are holding it again this year!📣

The topics are the same as last year, and you can submit any content related to InterSystems IRIS／InterSystems IRIS for Health.

🖋 InterSystems Japan Technical Article Contest – 2024: Articles related to IRIS 🖋

🎁 Participation prize：Everyone who submits a post will receive our👚Developer Community’s original T-shirt👕!！

🏆 Special Prize：Authors of three selected works will receive special prizes.

Updated on 30/8: Prize information added!Please check it out!👇

Entering the contest is easy!During the period from Monday,September 2to Friday, October 18, 2024）you are welcome to post an article related to IRIS on the developer community, (for details, please refer to the "Entry Requirements""Bonus Points" below).

Eligibility

Everyone is welcome to participate （(all you need to do is: create an account with the InterSystems Developer Community).

Contest schedule

📝 Application period

• Monday, September 2, 2024, 0:0:0: Start date for application
• Friday, October 18, 2024, 23:59:59: Closing date for application

✅ Voting period

• Monday, September 2, 2024, 0:0:0 : Start date for voting
• Thursday, 31 October 2024, 23:59:59: Closing date for voting

* Developer community members vote by clicking 'Like!👍'on published articles.
*The sooner you post an article, the longer it will take to collect ‘Likes!👍'.

Submission Requirements

❗️ You can automatically enter the contest with articles written during the contest period if they meet the following requirements.

• Please submit your articles related to InterSystems IRIS or InterSystems IRIS for Health, inJapanese language.
• Please submit articles of 800 characters or more. (Please check the character count displayed in the bottom right hand corner of the editor before submitting)
• When posting an article, please be sure to set the ‘Contest’ tag.(If you forget to do this, the article posted by you will not be recognised as a contest article)
• Articles by different authors on the same or similar topics are also eligible.
• You can submit multiple articles (for details, please refer to 'Bonus Points'
• Please note that articles that have been translated and published in communities in other countries are not eligible for this contest.
• Please note that the content of your submission will be reviewed by the community team.  

The method for submitting articles and for using the editor is unchanged from last year. For details, please refer to 👉'How to submit articles: 1st Technical Writing Contest’

Prize information🎁

Winners will be chosen based on the total number of votes cast by the judges and the number of ‘likes’ given by community members. The first, second and third place winners will be able to choose one prize from those listed for their respective places (First-place winners can choose one of the prizes listed for first to third places, second-place winners can choose one of the prizes listed for second to third places).

Prizes will be selected at the award ceremony.

🥇 First place

• Apple Watch SE (2nd generation, 2023)
• SanDisk Extreme Portable SSD V2 External 2TB
• Apple AirPods (3rd generation)

🥈 Second place

• SodaStream Genesis Deluxe v2 starter kit
• Moonka 10.1-inch wifi Digital Photo Frame, Motion Sensor, 1280 x 800 high resolution touch panel, built-in 32GB storage
• Moonmoon Totnoelite light alarm clock (Totnoelite plain)

🥉 Third place 

• [Heat&Pressure]Hot eye mask
• Starbucks gift card ( ¥5,000)
• Panasonic Scalp Aesthetics EH-HM7A-S Sebum Cleaning Type Silver

Selection process

The following total scores will be used to determine the winners.

• Number of ‘likes’ received from developer community members (1 like = 1 point)
• Bonus points (see details below)
• Judges' votes (first place: 5 points, second place: 3 points, third place: 2 points)
  • The judges will be selected by the community team.

About the award ceremony

(Added 18 Sep 2024) This year's contest award ceremony will be held during the Developer Community Meetup in Tokyo on Friday, November 8!

For more information on the meetup, please refer to this article👉"InterSystems Japan Developer Community Meetup in Tokyo"

Please consider attending the meetup!

Bonus points

🎯 Earn bonus points for submitting articles that meet the following criteria:

Articles related to Embedded Python: 4 points

Any content related to Embedded Python is eligible. For example, please share your experiences, impressions and ideas.

Reference article:#Embedded Python

Articles related to Generative AI: 4 points

Any content related to Generative AI using InterSystems IRIS InterSystems IRIS for Health is eligible. Please share examples of using Generative AI in combination with IRIS, and your impressions.

Reference article (in English):#Generative AI

Translated article about the work awarded first place in the Python Contest 2024: Text to IRIS SQL with LangChain: Introduction to the Python Programming Contest Winning Work!

Articles related to FHIR: 3 points.

Any content related to FHIR is eligible. For example, please share your impressions of trying out the IRIS for Health FHIR repository, challenges you have faced, or thoughts, code examples and innovations you have made when trying out the Facade for a specific resource.

Reference article:#FHIR 

Articles containing code descriptions: 2 points.

Two points are awarded for including a tried and tested code example in the article.

Publishing working code samples to a Git repository: 5 points

You can get 5 points by publishing code samples to your own Git repository and including the URL of the repository in your article. 

Screenshots or diagrams related to the article content: 1 point

You can earn 1 point for each article containing a screenshot or diagram to supplement the article when testing the operation.

Contest participants who write questions in response to other participants‘ articles: 1 point per article

Contest participants who write questions in response to other participants’ articles will earn 1 point per article.

Contest participants who write answers to questions posted in the community: 1 point for each answer

Contest participants who write answers to questions posted in the community will earn 1 point for each answer.

We will continue to post the latest information about the contest. 👀Don't miss it!

We look forward for your applications!

Hi Community,

It's time to announce the winners of the Python Contest! 

Thanks to all our amazing participants who submitted 9 applications 🔥 

Hi Community,

Let's meet at the online meetup with the winners of the Python Contest. It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Thursday, August 8, 12 pm EDT | 6 pm CEST

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.

Although I enjoy frontend work, CSS remains a complex challenge for me, especially since I learned it through trial and error. The meme of Peter Griffin struggling to open blinds perfectly captures my experience of learning CSS.

But today, everything changes. Tools like Streamlit have revolutionized the game for developers like me, who prefer the comfort of a terminal's black screen. Gone are the days of wrestling with lines of code that look like cryptic messages from aliens (looking at you, CSS!). As Doctor Károly Zsolnai-Fehér from Two Minute Papers always says, "What a time to be alive!" With Streamlit, you can build an entire web application using just Python code. Want to see it in action? Buckle up, because I'm about to share my attempt at creating the frontend for SQLZilla using this awesome tool.

To install it, simply open your terminal and cast this spell:

pip install streamlit

(Or you can add it to your requirements.txt file.)

Create a file, app.py and add this code snippet to display an "SQLZilla" title:

import streamlit as st

st.title("SQLZilla")

Run the Show!

Open your terminal again and type this command to activate your creation:

streamlit run app.py

Voila! Your Streamlit app should appear in your web browser, proudly displaying the title "SQLZilla."

Add an image using image method, to centralize it I just create 3 columns and add on center (shame on me)

   st.title("SQLZilla")

   left_co, cent_co, last_co = st.columns(3)
   with cent_co:
       st.image("small_logo.png", use_column_width=True)

To manage configurations and query results, you can use session state. Here's how you can save configuration values and store query results:

if 'hostname' not in st.session_state:
    st.session_state.hostname = 'sqlzilla-iris-1'
if 'user' not in st.session_state:
    st.session_state.user = '_system'
if 'pwd' not in st.session_state:
    st.session_state.pwd = 'SYS'
# Add other session states as needed

To connect SQLZilla to an InterSystems IRIS database, you can use SQLAlchemy. First, install SQLAlchemy with:

pip install sqlalchemy

Then, set up the connection in your app.py file:

from sqlalchemy import create_engine
import pandas as pd

# Replace with your own connection details
engine = create_engine(f"iris://{user}:{password}@{host}:{port}/{namespace}")

def run_query(query):
    with engine.connect() as connection:
        result = pd.read_sql(query, connection)
        return result

Once you've connected to the database, you can use Pandas and Streamlit to display the results of your queries. Here's an example of how to display a DataFrame in your Streamlit app:

if 'query' in st.session_state:
    query = st.session_state.query
    df = run_query(query)
    st.dataframe(df)

To make your app more interactive, you can use st.rerun() to refresh the app whenever the query changes:

if 'query' in st.session_state and st.button('Run Query'):
    df = run_query(st.session_state.query)
    st.dataframe(df)
    st.rerun()

You can find various Streamlit components to use. In SQLZilla, I added an ACE code editor version called streamlit-code-editor:

from code_editor import code_editor

editor_dict = code_editor(st.session_state.code_text, lang="sql", height=[10, 100], shortcuts="vscode")

if len(editor_dict['text']) != 0:
    st.session_state.code_text = editor_dict['text']

Since the SQLZilla assistant is written in Python, I just called the class:

from sqlzilla import SQLZilla

def assistant_interaction(sqlzilla, prompt):
    response = sqlzilla.prompt(prompt)
    st.session_state.chat_history.append({"role": "user", "content": prompt})
    st.session_state.chat_history.append({"role": "assistant", "content": response})

    if "SELECT" in response.upper():
        st.session_state.query = response

    return response

Congratulations! You’ve built your own SQLZilla. Continue exploring Streamlit and enhance your app with more features. And if you like SQLZilla, vote for this incredible assistant that converts text into queries!

Hi Community,

It's voting time! Cast your votes for the best applications in our Python Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Hi Contestansts!

Here are the results of bonuses gathered by applications in InterSystems Python Programming Contest 2024!

Hi Community,

We are pleased to invite you to the next InterSystems online programming contest, which is focused on Python!

🏆 InterSystems Python Contest 🏆

Duration: July 15 - August 4, 2024

Prize pool: $14,000

Hi Community,
In this article, I will demonstrate below steps to create your own chatbot by using spaCy (spaCy is an open-source software library for advanced natural language processing, written in the programming languages Python and Cython):

• Step1: Install required libraries

• Step2: Create patterns and responses file

• Step3: Train the Model

• Step4: Create ChatBot Application based on the trained model

So Let us start.

Hi Developers!

Here are the technology bonuses for the InterSystems Python Contest 2024 that will give you extra points in the voting:

• IRIS Vector Search usage - 3
• Python Pex Interoperability - 3
• Python in BPL - 2
• WSGI Web Apps - 2
• Python libs: sqlalchemy and dbt - 2
• LLM AI or LangChain usage: Chat GPT, Bard and others - 3
• NoObjectScriptLine - 3
• Hugginface - 2
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Implement InterSystems Community Idea - 4
• Find a bug in Embedded Python - 2
• First Article on Developer Community - 2
• Second Article On DC - 1
• First Time Contribution - 3
• Video on YouTube - 3
• YouTube Short - 1

See the details below.

Hi Community,

Let's meet at the online meetup with the winners of the Vector Search, GenAI and ML Contest. It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Thursday, May 23, 12 pm EDT | 6 pm CEST

Hi Community,

It's time to announce the winners of the Vector Search, GenAI and ML Contest! 

Thanks to all our amazing participants who submitted 15 applications 🔥 

Hi Community,

It's voting time! Cast your votes for the best applications in our Vector Search, GenAI and ML Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

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.

We focused our project on pregnant women and conducted a survey with friends of ours who work at a large hospital in São Paulo, Brazil, specifically in the area of monitoring and caring for pregnant women.

Hi Developers!

We are happy to present the bonuses page for the applications submitted to the Vector Search Programming Contest!

In the previous article, we saw in detail about Connectors, that let user upload their file and get it converted into embeddings and store it to IRIS DB. In this article, we'll explore different retrieval options that IRIS AI Studio offers - Semantic Search, Chat, Recommender and Similarity. 

New Updates  ⛴️ 

• Added installation through Docker. Run `./build.sh` after cloning to get the application & IRIS instance running in your local
• Connect via InterSystems Extension in vsCode - Thanks to @Evgeny Shvarov 
• Added FAQ's in the home page that covers the basic info for new users

Semantic Search

Hey Community,

We have more exciting news! The new InterSystems online programming contest dedicated to Generative AI, Vector Search and Machine Learning is starting very soon! 

🏆 InterSystems Vector Search, GenAI and ML Contest 🏆

Duration: April 22 - May 19, 2024

Prize pool: $14,000

Hi Developers!

Here're the technology bonuses for the InterSystems Vector Search, GenAI, and ML contest 2024 that will give you extra points in the voting:

• Vector Search usage - 5
• IntegratedML usage - 3
• Embedded Python - 3
• LLM AI or LangChain usage: Chat GPT, Bard, and others - 3
• Questionnaire - 2
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Implement InterSystems Community Idea - 4
• Find a bug in Vector Search, or Integrated ML, or Embedded Python - 2
• First Article on Developer Community - 2
• Second Article On DC - 1
• First Time Contribution - 3
• Video on YouTube - 3
• Suggest a new idea - 1

See the details below.

Hi Community,

It's time to announce the winners of the InterSystems FHIR and Digital Health Interoperability Contest! 

Thanks to all our amazing participants who submitted 12 applications 🔥 

Hi Community!

It's time to celebrate our 19 fellow members who took part in the latest Technical Article Contest: InterSystems IRIS Tutorials and wrote

🌟 21 AMAZING ARTICLES 🌟

Our judges mentioned that it was a very tough challenge to choose only three articles each because more deserved points. Despite it all, they persevered and now it's time to announce the winners!

Let's meet the winners and look at their articles: