InterSystems Developer
Posted on December 25, 2022
In this article you will have access to the curated base of articles from the InterSystems Developer Community of the most relevant topics to learning InterSystems IRIS. Find top published articles ranked by Machine Learning, Embedded Python, JSON, API and REST Applications, Manage and Configure InterSystems Environments, Docker and Cloud, VSCode, SQL, Analytics/BI, Globals, Security, DevOps, Interoperability, Native API. Learn and Enjoy!
Machine Learning
Machine Learning is a mandatory technology to build advanced data analysis and automate manual activities with excellent efficiency. It creates cognitive models that learn from the existing data, and perform predictions, probability calculations, classifications, identifications, and automation of "non-creative" human activities based on its self-adjusted algorithms.
In all scenarios, InterSystems IRIS acts as a data platform and environment for creating, executing, making available, and using these machine learning models. IRIS enables the use of ML from SQL commands (IntegratedML), execution of ML using Embedded Python and PMML(Predictive Model Markup Language). You can check how it functions in the following articles:
Title | Description | URL |
---|---|---|
IntegratedML hands-on lab | Practical Overview to IntegratedML | https://community.intersystems.com/post/integratedml-hands-lab |
AI Robotization with InterSystems IRIS Data Platform | AI on IRIS productions | https://community.intersystems.com/post/ai-robotization-intersystems-iris-data-platform |
Web App to Predict Diabetes using IRIS IntegratedML | IntegratedML sample | https://community.intersystems.com/post/web-app-predict-diabetes-using-iris-integratedml |
Predict Maternal Health Risks | IntegratedML sample | https://community.intersystems.com/post/predict-maternal-health-risks |
Using Machine Learning to Organize the Community – 1 | Using Python ML libraries | https://community.intersystems.com/post/using-machine-learning-organize-community-1 |
ObjectScript language
ObjectScript is InterSystems' official programming language. It is easy, flexible, and very powerful in creating backend, integration, and analytics applications. Consult the following articles for more information:
Embedded Python
Python is one of the most popular and commonly used programming languages in the world (https://www.tiobe.com/tiobe-index/). InterSystems IRIS is a data platform open to all main programming languages. However, speaking about Python, this amazing language and its libraries are available for use everywhere in IRIS: in classes, SQL, and integrations/productions. For those who do not know or do not want to know ObjectScript (InterSystems programming language), it's a great option. See the following articles on how to do this:
JSON
JSON is one of the most widely used interoperability formats for sending and receiving data on the market. InterSystems IRIS supports this format in several ways. It is possible to have your native database in JSON (DocDB), serialize and deserialize objects, and process requests and responses in JSON, especially from REST services. Review the following articles:
Title | Description | URL |
---|---|---|
Introducing new JSON capabilities in Caché 2016.1 | Presenting ObjectScript JSON API | https://community.intersystems.com/post/introducing-new-json-capabilities-cach%C3%A9-20161 |
JSON Enhancements | JSON Adaptor API | https://community.intersystems.com/post/json-enhancements |
API and REST Applications
Backend applications are currently developed in the REST (Representational State Transfer) paradigm and are exposed as Web APIs. The following articles will help you see how it works:
Manage and Configure InterSystems Environments
The good management and configuration of IRIS environments are essential for the performance, security, availability, and reliability of the applications used by users. These articles can give you excellent tips on how to do this.
Title | Description | URL |
---|---|---|
InterSystems Data Platforms Capacity Planning and Performance Series Index | Capacity and Performance improvement | https://community.intersystems.com/post/intersystems-data-platforms-capacity-planning-and-performance-series-index |
Deploying Applications in InterSystems Cache with %Installer | Using %Installer to create namespaces, databases, and applications configuration | https://community.intersystems.com/post/deploying-applications-intersystems-cache-installer |
Horizontal Scalability with InterSystems IRIS | Set IRIS instances for horizontal scalability | https://community.intersystems.com/post/horizontal-scalability-intersystems-iris |
The InterSystems Iris Fhirserver running on a Raspberry Pi Raspberry running as a FHIRserver | Run IRIS inside Raspberry PI | https://community.intersystems.com/post/intersystems-iris-fhirserver-running-raspberry-pi-raspberry-running-fhirserver |
Database Mirroring without a Virtual IP Address | Set mirrors using VIP | https://community.intersystems.com/post/database-mirroring-without-virtual-ip-address |
Apache Web Gateway with Docker | Configure SSL and Web Gateway for web applications | https://community.intersystems.com/post/apache-web-gateway-docker |
Work with SAML in IRIS | SAML to Web services | https://community.intersystems.com/post/work-saml-iris |
Mastering the %SYSTEM.Encryption class | Encrypt and decrypt using IRIS | https://community.intersystems.com/post/mastering-systemencryption-class |
Docker and Cloud
The new application architectures work in container Docker and in the cloud, aiming to achieve elastic scalability, shorter installation, configuration, and provisioning times, and reduced infrastructure complexity and cost. Study these articles to learn how to bring IRIS to the cloud:
VSCode
VSCode is one of the most used development IDE in the world. IRIS fully supports this IDE. See the following articles:
Title | Description | URL |
---|---|---|
VSCode-ObjectScript on GitHub | Develop IRIS apps into Web Github VSCode | https://community.intersystems.com/post/vscode-objectscript-github |
GitHub Codespaces with IRIS | Develop IRIS apps into Web Github | https://community.intersystems.com/post/github-codespaces-iris |
VSCode Tips & Tricks - SOAP Wizard | Create shortcut option on VSCode | https://community.intersystems.com/post/vscode-tips-tricks-soap-wizard |
Adding your own snippets to VS Code | Create snippets | https://community.intersystems.com/post/adding-your-own-snippets-vs-code |
SQL
SQL is one of the most used language for dealing with relational databases. These articles demonstrate how to perform queries and data persistence:
Title | Description | URL |
---|---|---|
Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* | Using Indexes to promote advanced search | https://community.intersystems.com/post/free-text-search-way-search-your-text-fields-sql-developers-are-hiding-you |
Improve SQL Performance for Date Range Queries | Do SQL Queries using dates | https://community.intersystems.com/post/improve-sql-performance-date-range-queries |
Static WHERE Conditions | Where on Persistent Classes | https://community.intersystems.com/post/static-where-conditions |
2021.2 SQL Feature Spotlight - Run Time Plan Choice | Select Runtime SQL Execution Plan | https://community.intersystems.com/post/20212-sql-feature-spotlight-run-time-plan-choice |
New in 2020.1: the Universal Query Cache | SQL Cache | https://community.intersystems.com/post/new-20201-universal-query-cache |
Materialized Views | Create views inside persistent classes | https://community.intersystems.com/post/materialized-views |
Debugging Trick with SQL | Debug SQL commands | https://community.intersystems.com/post/debugging-trick-sql |
Using ClassQueries() as Tables | Creating views | https://community.intersystems.com/post/using-classqueries-tables |
M:N Relationship | Mapping N to N relationships | https://community.intersystems.com/post/mn-relationship |
Reading AWS S3 data on COVID as SQL table in IRIS | Get CSV data from AWS S3 to IRIS table | https://community.intersystems.com/post/reading-aws-s3-data-covid-sql-table-iris |
The One Query Performance Trick You NEED to Know? Tune Table! | SQL tunning | https://community.intersystems.com/post/one-query-performance-trick-you-need-know-tune-table |
Data Storage - Information You Must Know to Make Good Decisions When Developing | Configure the data storage section on a persistent class to get more performance | https://community.intersystems.com/post/data-storage-information-you-must-know-make-good-decisions-when-developing |
Improve SQL Performance for Date Queries, AGAIN! | Tunning SQL queries for dates | https://community.intersystems.com/post/improve-sql-performance-date-queries-again |
Scrollable ResultSet Pagination Sample | Paginate SQL results (see comments too) | https://community.intersystems.com/post/scrollable-resultset-pagination-sample |
Day 1: Developing with InterSystems Objects and SQL | Concepts about SQL into InterSystems IRIS | https://community.intersystems.com/post/day-1-developing-intersystems-objects-and-sql |
DB Migration using SQLgateway | Migrate from PostgreSQL, MySQL, and other databases to IRIS | https://community.intersystems.com/post/db-migration-using-sqlgateway |
Importing CSV into the Existing Table in InterSystems IRIS | Import CSV to SQL Table | https://community.intersystems.com/post/importing-csv-existing-table-intersystems-iris |
Four Database APIs | SQL APIs | https://community.intersystems.com/post/four-database-apis |
Indexing of non-atomic attributes | Create advanced index options | https://community.intersystems.com/post/indexing-non-atomic-attributes |
Know Your Indices | Index creation fundamentals | https://community.intersystems.com/post/know-your-indices |
Dynamic SQL to Dynamic Object | Use DynamicSQL | https://community.intersystems.com/post/dynamic-sql-dynamic-object |
Data migration tool - Part I: from Postgres to IRIS | Series of articles on how to migrate from popular databases to IRIS database | https://community.intersystems.com/post/data-migration-tool-part-i-postgres-iris |
Analytics/BI
BI/Analytics allows making decisions based on data analysis in graphs, dashboards, summaries, and detailed tables and based on navigation and data exploration by the analyst user. Here's how to build analytic applications using IRIS:
Globals
Globals are the key mechanism in IRIS for flexibly storing and retrieving data, whether in SQL, in classes, in JSON documents, in BI cubes, or other custom formats. Take a glimpse at how to do this in the following articles:
Title | Description | URL |
---|---|---|
The Art of Mapping Globals to Classes 1 of 3 | Mapping globals to SQL tables and Objects | https://community.intersystems.com/post/art-mapping-globals-classes-1-3 |
Globals Are Magic Swords For Managing Data. Part 1 | Fundamentals about globals | https://community.intersystems.com/post/globals-are-magic-swords-managing-data-part-1 |
GlobalToJSON-embeddedPython-pure | Export globals to JSON | https://community.intersystems.com/post/globaltojson-embeddedpython-pure |
Transactions in Global InterSystems IRIS | Manage transactions on Globals persistence | https://community.intersystems.com/post/transactions-global-intersystems-iris |
Store Mindmaps using Globals | Using globals to persist mindmap data | https://community.intersystems.com/post/store-mindmaps-using-globals |
Security
It is critical to ensure security for any application. Security is related to access and authorization management, tracking and auditing transactions, encryption of the stored and transported content, and setting correct configuration parameters to ensure the protection of sensible resources. Read these articles to understand more about how to establish security:
DevOps
DevOps is a way to adopt practices and tools that make it possible to automate the fast and quality transition from source code from development (Dev) to production operation (Ops). See how to do this in IRIS.
Title | Description | URL |
---|---|---|
Continuous Delivery of your InterSystems solution using GitLab - Part I: Git | Continuous delivery with GitLab | https://community.intersystems.com/post/continuous-delivery-your-intersystems-solution-using-gitlab-part-i-git |
Introducing InterSystems ObjectScript Package Manager | Use ZPM to configure and install third-party packages inside your application | https://community.intersystems.com/post/introducing-intersystems-objectscript-package-manager |
ZPMshow - a helper for tired fingers | How to use ZPM – IRIS Package Manager | https://community.intersystems.com/post/zpmshow-helper-tired-fingers |
How to set up a mirror programmatically | Automate the create new mirrors | https://community.intersystems.com/post/how-set-mirror-programmatically |
Unit Tests and Test Coverage in the ObjectScript Package Manager | Create Unit Tests for ObjectScript code quality | https://community.intersystems.com/post/unit-tests-and-test-coverage-objectscript-package-manager |
Deploying a sharded cluster with Docker and MergeCPF | Automate config using cpf files | https://community.intersystems.com/post/deploying-sharded-cluster-docker-and-mergecpf |
Caché ObjectScript Quick Reference | ObjectScript reference pdf document | https://community.intersystems.com/post/cach%C3%A9-objectscript-quick-reference |
The Anatomy of ZPM Module: Packaging Your InterSystems Solution | Use ZPM to automate deployment | https://community.intersystems.com/post/anatomy-zpm-module-packaging-your-intersystems-solution |
Adding VSCode into your IRIS Container | Embed VSCode inside your docker instance | https://community.intersystems.com/post/adding-vscode-your-iris-container |
How to Create New Database, Namespace and Web Application for InterSystems IRIS programmatically | Automate database and namespace creation | https://community.intersystems.com/post/how-create-new-database-namespace-and-web-application-intersystems-iris-programmatically |
Unit Tests: Quality of your ObjectScript Code | Quality Assurance with Unit Tests | https://community.intersystems.com/post/unit-tests-quality-your-objectscript-code |
Some InterSystems Developer Community Docker Images | Docker community images | https://community.intersystems.com/post/some-intersystems-developer-community-docker-images |
Interoperability
IRIS has a powerful data and application interoperability bus. See how to use it with the following articles.
Title | Description | URL |
---|---|---|
Sending Alerts from Ensemble via Telegram | Production to send data to telegram | https://community.intersystems.com/post/sending-alerts-ensemble-telegram |
[InterSystems IRIS for the First Time] Let’s use Interoperability | Create business services, operations, processes, and productions | https://community.intersystems.com/post/intersystems-iris-first-time-let%E2%80%99s-use-interoperability |
InterSystems IRIS Interoperability with Embedded Python | Create business services, operations, processes, and productions using Python | https://community.intersystems.com/post/intersystems-iris-interoperability-embedded-python |
Ensemble / Interoperability Training Course | Great sample to learn how to create productions | https://community.intersystems.com/post/ensemble-interoperability-training-course |
Some Programmatic Interoperability Examples | Programmatic productions using Python or ObjectScript | https://community.intersystems.com/post/some-programmatic-interoperability-examples |
Listing files in folder | List files in a folder | https://community.intersystems.com/post/listing-files-folder |
Containerising .Net/Java Gateways (or Kafka Integration Demo) | Kafka support using Java or .Net Native API | https://community.intersystems.com/post/containerising-netjava-gateways-or-kafka-integration-demo |
Implementing IRIS Integrations with .NET or Java using PEX | Using PEX to create productions using Java or .Net | https://community.intersystems.com/post/implementing-iris-integrations-net-or-java-using-pex |
Migrate from Java Business Host to PEX | Using PEX | https://community.intersystems.com/post/migrate-java-business-host-pex |
Using Tesseract OCR and Java Gateway | Using Java PEX | https://community.intersystems.com/post/using-tesseract-ocr-and-java-gateway |
Creating a PEX Business Operation | Create Java PEX Business Operation | https://community.intersystems.com/post/creating-pex-business-operation |
OCR and NLP together into InterSystems IRIS | Java PEX Sample | https://community.intersystems.com/post/ocr-and-nlp-together-intersystems-iris |
Creating a custom interoperability business service using an HTTP Adapter | Creating Business Services | https://community.intersystems.com/post/creating-custom-interoperability-business-service-using-http-adapter |
Native API
IRIS is open to working with some of the most used programming languages in the market (Java, Javascript/NodeJS, .Net, C++, and Python). To do it we use Native API for each of these languages. Check out these articles:
Title | Description | URL |
---|---|---|
WebSocket Client JS with IRIS Native API as Docker Micro Server | Using IRIS and NodeJS to do a WebSocket | https://community.intersystems.com/post/websocket-client-js-iris-native-api-docker-micro-server |
IRIS Native API for ObjectScript | Using Native APIs | https://community.intersystems.com/post/iris-native-api-objectscript |
Using ZPM for Node.js | Using ZPM on Node.js projects | https://community.intersystems.com/post/using-zpm-nodejs |
Creating a PDF from a Text file | Java Native API for generating PDF | https://community.intersystems.com/post/creating-pdf-text-file |
How to Start Development with InterSystems IRIS in Less Than a Minute | Start to develop using IRIS | https://community.intersystems.com/post/how-start-development-intersystems-iris-less-minute |
Making a blog using Python + IRIS Globals | A blog on using Python native API | https://community.intersystems.com/post/making-blog-using-python-iris-globals |
Posted on December 25, 2022
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.