#Contest

Using SQL Gateway with Python, Vector Search, and Interoperability in InterSystems Iris

Part 1 - SQL Gateway

Hello

In this article we will look at the use of SQL Gateway in Iris. SQL Gateway allows Iris to have access to tables from other (external) database via ODBC or JDBC. We can access Tables or Views from various databases, such as Oracle, PostgreSQL, SQL Server, MySQL and others.

From the previous article, we identified some issues when working with JSON in SQL.

IRIS offers a dedicated feature for handling JSON documents, called DocDB.

InterSystems IRIS® data platform DocDB is a facility for storing and retrieving database data. It is compatible with, but separate from, traditional SQL table and field (class and property) data storage and retrieval. It is based on JSON (JavaScript Object Notation) which provides support for web-based data exchange. InterSystems IRIS provides support for developing DocDB databases and applications in REST and in ObjectScript, as well as providing SQL support for creating or querying DocDB data.

By its nature, InterSystems IRIS Document Database is a schema-less data structure. That means that each document has its own structure, which may differ from other documents in the same database. This has several benefits when compared with SQL, which requires a pre-defined data structure.

The word “document” is used here as a specific industry-wide technical term, as a dynamic data storage structure. “Document”, as used in DocDB, should not be confused with a text document, or with documentation.

Let's explore how DocDB can help store JSON in the database and integrate it into projects that rely solely on xDBC protocols.

Hi Community,

It's time to announce the winners of the "Bringing Ideas to Reality" Contest! 

Thanks to all our amazing participants who submitted 13 applications 🔥 

Now it's time to announce the winners!

Hi Developers,

🎄 Christmas cheer is in the air, and we decided to try something new for the last programming contest of the year. Welcome the 

🏆 Bringing Ideas to Reality Contest 🏆

Submit an application that implements an idea from the InterSystems Ideas Portal that has statuses Community Opportunity or Future Consideration and requires doing the actual programming 😉

Duration: December 2 - 22, 2024

Prize pool: $14,000

Hi Developers!

We are happy to present the bonuses page for the applications submitted to the InterSystems "Bringing Ideas to Reality" 2024 Contest!

See the results below.

Hi Community,

It's voting time! Cast your votes for the best applications in our "Bringing Ideas to Reality" Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Here are the technology bonuses for the InterSystems "Bringing Ideas to Reality" Contest 2024 that will give you extra points in the voting:

• IRIS Vector Search usage -3
• Embedded Python usage -3
• InterSystems Interoperability - 3
• InterSystems IRIS BI - 3
• VSCode Plugin - 3
• FHIR Tools - 3
• Docker container usage -2 
• ZPM Package Deployment - 2
• Online Demo -2 
• 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.

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!👇

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.

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.