Hi Community!

There are two general ways to execute arbitrary SQL in serverside ObjectScript code: EmbeddedSQL and ObjectScript SQL a.k.a. Dynamic SQL.

E.g. if we want to get the value of the property of instance with a certain ID using SQL we can do:

&sql(SELECT Name INTO :name FROM Sample.Person WHERE ID=1)

write name

Same result with %SQL.Statement:

set rs=##class(%SQL.Statement).%ExecDirect(,"SELECT Name as name FROM Sample.Person where ID=1")
  do rs.%Next()
  write rs.name

1 2
0 1.1K

Hi Community!

This is the update on what are the new applications submitted on OpenExchange in January and February 2019

CPIPE

This is a tiny example of how to run a server command from within Caché / Ensemble / IRIS and get back the full output as seen in any server command shell.

QEWD-js

QEWD.js is a Node.js framework for REST APIs, interactive WebSocket and/or Ajax applications, capable of running as a monolithic application or split across MicroServices. Fully supports Cache, Ensemble and IRIS, allowing use of existing Cache ObjectScript code, Cache Objects and Cache SQL, but also allows the database to be abstracted as a persistent JSON / Document database.

PMML-Business-Operation

With this simple Business Operation, you can easily leverage your predictive models (saved as PMML) in a Production. There's both a generic BO and a utility method that allows you to generate dedicated operation / request / response classes.

COSFaker

Helps to generate fake/test data for development purposes

WsockClient.csp and WsocClient.js

Web socket clients on CSP and InterSystems node.js adapter to collect end manage data transferred to the client in InterSystems IRIS or Caché

CachéQuality for VSCode by @Daniel Tamajon

IDE extension that helps you detect and fix quality issues as you write code. Like a spell checker, this extension squiggles flaws so they can be fixed before committing code. You can get it directly from the VS Code Marketplace and it will then detect new bugs and quality issues as you code (ObjectScript and JavaScript)

0 0
0 229

Hi Community!

When you run IRIS container out-of-the-box and connect to it via terminal e.g. with:

docker-compose exec iris bash

You see something like:

root@7b19f545187b:/opt/app# irissession IRIS

Node: 7b19f545187b, Instance: IRIS

Username: ***

Password: ***

USER>

And you enter login and password every time.

How to programmatically setup docker-compose file to have IRIS container with OS authentication enabled? And have the following while entering the terminal:

root@7b19f545187b:/opt/app# irissession IRIS

Node: 7b19f545187b, Instance: IRIS

USER>

0 3
0 492

Hi Community!

Here is a digest of the Developer Community postings in February 2019.

Most viewed

How to Develop InterSystems Applications in Your Favorite IDE 240

Apache HTTPD Web Server Configuration for HealthShare 230

Alternative to using % to make a variable public 151

VSCode-ObjectScript next release 0.7.9 129

Know Your Indices 123

How to return JSON Array in SQL request for a List Property? 122

Tools and Framework Development and Deployment Guidelines . What is The Best Approach? 117

Consume data from websocket 114

What are the pros and cons of keeping INT code 112

Accessing the lock table and another process's variables, potentially on a different server 107

InterSystems IRIS Example Reference Architectures for Amazon Web Services (AWS) 105

Ethereum Adapter for InterSystems IRIS Data Platform 101

Index Handling 76

Using Oauth2 with SOAP (Web)Services 61

See the details below

0 0
0 232

Hi guys!

Suppose you developed a tool, framework, library on InterSystems ObjectScript for InterSystems Data Platform, share it via Open Exchange and want people to install it.

What is the best strategy if it is a library and supposed to be called from different namespaces?

Here are the following thoughts:

1. Tool's developer should be able to use globals to read/store data the tool needs.

2. Tool's consumer should be confident, that the thing he/she installs will not harm the application's data.

3. A tool should be callable from any application's namespace.

4. Tool's installation(in general) should not request manual security changes (e.g. grant the write access to IRISLIB) and %YourClass is not an option.

5. It's easy to uninstall the tool - just delete the namespace/database (maybe delete some web-apps too).

0 10
0 512

Hi Community!

Here is a digest of the Developer Community postings in January 2019.

Most viewed

VSCode extension for InterSystems ObjectScript update 319

Free IRIS Community Edition in AWS 265

InterSystems IRIS 2019.1 preview 203

Seeking field testers for an upcoming VSCode extension from George James Software 185

How to start development 173

Caché and Ensemble 2018.1.1 available 162

n00b questions 145

Save the Date — InterSystems Benelux Symposium 2019 145

IRIS Quarterly Container only releases and Studio 141

Collaboration with Git in Atelier 140

The One Query Performance Trick You NEED to Know? Tune Table! 132

Explore Text Data with InterSystems iKnow Entity Browser 126

Should you trust Codd or your objects? 112

SQL Performance Resources 106

Perforce Example of Shared Development with Atelier 105

Top 5 takeaways from 2018 95

On a csp page, when you return %Boolean from a cache script into a javascript script, you're getting a string, not a boolean 89

Iterate over dynamic object 52

Using PMML models in your Business Processes 51

0 0
0 175

Hi Community!

Here is the digest of what has happened on Open Exchange in November and December 2018!

Application Releases

We had 5 releases in November and December:

Cache ODBC for Node.js

This library aims to provide simple access to ODBC data sources for node.js.

Laracache

Laravel package providing InterSystems Cache as a data source using ODBC

DeepSeeButtons

Tool for analyzing your DeepSee Environment

DSW Reports

Addon for DeepSee Web which provides online reports and PDF emailing reports using InterSystems DeepSee dashboards

AnalyseThis

Utility to easily transform a CSV file into a personalized preview of DeepSee

0 0
0 221

Hi Community!

New Badges're already on Global Masters Advocacy Hub!

We're happy to announce that this year we again introduced three annual badges on Global Masters Advocacy Hub to let you remember how much you contributed to Developer Community in 2018. Here they are:

✔ DC Best-Selling Author 2018
✔ DC Expert 2018
✔ DC Opinion Leader 2018

Let's take a closer look at the DC Wall of Fame 2018 and greet everyone with big applause!

0 0
0 339

Hi Community!

It's time to announce the best articles on InterSystems Data Platforms you published in 2018!

And here are three best articles for the year (criteria is the number of views):

First place: K-Means clustering of the Iris Dataset, by Niyaz Khafizov 1564

Second place: Continuous Delivery of your InterSystems solution using GitLab - Part I: Git, by Eduard Lebedyuk 1206

Third place: Replacing ZEN - Part 1 - Introduction, by Peter Cooper 933

Congrats to authors!

And what are the best articles by InterSystems Data Platforms?

See below

3 0
0 389

Hi Community!

This is a digest of the Developer Community postings in December 2018.

Most viewed

Win Advent of Code 2018 and Get a Ticket to InterSystems Global Summit 2019! 504

Review InterSystems IRIS or Caché and get two $25 Visa Cards! 163

How are stars counted? How InterSystems Caché eXTreme is used in Gaia 158

How to Create Namespace Programmatically in Terminal 153

Calling Javascript within Cache Object Script 136

cache basics 130

QEWD-Up: A New, Fast-track way to create REST APIs 125

Just for Fun. John Conway's Game of Life 114

Atelier 1.3 Update Released 109

How to get files from FTP Server 108

Source control with a shared development instance 85

AnalyzeThis ? Quick start into InterSystems BI 73

Adding Java to a IRIS Docker image 69

Some tips for beginners about using Terminal scripts 55

Get a list of Ensemble Lookup Tables and Schema documents in the current namespace 49

Issues on Mixed Mirrors of IRIS vs. Caché 43

0 0
0 154

Hi Community!

Thank you for being with InterSystems Developer Community yet another year! We appreciate it very much!

We want to know how helpful DC for you today and how could we make it better.

Could you please go through this short 5 min survey which will let us know what do you think about DC and what could be improved.

We wish you a Merry Christmas and a Happy New Year!

Sincerely,

Your InterSystems Developer Community Team

1 0
0 217

Hi Community!

We try a new approach to the InterSystems Developers YouTube Videos called "Coding Talks"!

Coding Talks is a short video in which the developer demonstrates a particular feature or functionality of InterSystems Data Platforms which he/she uses to in coding. Typical format: the face on side and editor with ObjectScript.

Check this video I made by myself participating in Advent of Code 2018 and coding with InterSystems ObjectScript in VSCode.

Coding Advent of Code 2018 Using InterSystems ObjectScript

https://www.youtube.com/embed/GyFJ67jqXCU
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 0
1 386
Announcement
· Dec 3, 2018
DC October-November 2018 release

Hi Community!

As you know or maybe guess we keep working on making Developer Community a better place for you, developers on InterSystems Data Platforms.

And here is the release on what we did in October-November.

Key visible enhancements:

better monthly digests,

InterSystems Best Practices,

Speed up mailings.

And a lot of small, but nice things - check the details inside.

1 0
0 189