Nova postagem

Pesquisar

Artigo
· Maio 22, 2024 3min de leitura

Overview of InterSystems IRIS® SQL usage options - Part 1

  

Hi Community,

In this series of articles, we will explore the following InterSystems SQL usage options:

  1. Embedded SQL

  2. Dynamic SQL

  3. Class Queries


SQL Overview

InterSystems SQL provides a full set of standard relational features, including the ability to define table schema, execute queries, and define and execute stored procedures. You can execute InterSystems SQL interactively from the Management Portal or programmatically from using a SQL shell interface. Embedded SQL enables you to embed SQL statements in your ObjectScript code, while Dynamic SQL enables you to execute dynamic SQL statements from ObjectScript at runtime.

 
1. Embedded SQL

Within ObjectScript, InterSystems SQL supports Embedded SQL: the ability to place an SQL statement within the body of a method (or other code). Using Embedded SQL, you can query a single record, or define a cursor and use that to query multiple records. Embedded SQL is compiled. By default, it is compiled the first time it is executed (runtime), not when the routine that contains it is compiled. Embedded SQL is quite powerful when used in conjunction with the object access capability of InterSystems IRIS.


2. Dynamic SQL

Dynamic SQL refers to SQL statements that are prepared and executed at runtime. In Dynamic SQL preparing and executing an SQL command are separate operations. Dynamic SQL lets you program within InterSystems IRIS in a manner similar to an ODBC or JDBC application (except that you are executing the SQL statement within the same process context as the database engine). Dynamic SQL is invoked from an ObjectScript program. Dynamic SQL queries are prepared at program execution time, not compilation time. 


3. Class Queries

A class query is a tool,  contained in a class and meant for use with dynamic SQL,  to look up records that meet specified criteria. With class queries, you can create predefined lookups for your application. For example, you can look up records by name, or provide a list of records that meet a particular set of conditions, such as all the flights from Paris to Madrid.


Before moving to the first option, let us create a  persistent class Demo.Person, that also extends the %Populate class to populate some data.

Class Demo.Person Extends (%Persistent, %Populate)
{
/// Person's name.
Property Name As %String(POPSPEC = "Name()") [ Required ];
/// Person's Social Security number. This is validated using pattern match.
Property SSN As %String(PATTERN = "3N1""-""2N1""-""4N") [ Required ];
/// Person's Date of Birth.
Property DOB As %Date(POPSPEC = "Date()");
/// Person's City
Property CITY As %String;
}


Run the following command to check the table data after compiling the above class:

SELECT
ID, CITY, DOB, Name, SSN
FROM Demo.Person



Now run the following command to populate 20 records:

do ##class(Demo.Person).Populate(20)

Run the select query again


We have created the table and populated it with some data. In the upcoming article, we will review Embedded SQL.

Thanks

Discussão (0)1
Entre ou crie uma conta para continuar
InterSystems Oficial
· Maio 22, 2024

InterSystems anuncia InterSystems IRIS 2024.1.0.267.2, inclui suporte para Ubuntu 24.04

A InterSystems tem o prazer de anunciar a disponibilidade geral de

  • InterSystems IRIS Data Platform 2024.1.0.267.2
  • InterSystems IRIS for Health 2024.1.0.267.2
  • HealthShare Health Connect 2024.1.0.267.2

Esta versão adiciona suporte para o sistema operacional Ubuntu 24.04. Ubuntu 24.04 inclui kernel Linux 6.8, melhorias de segurança, junto com melhorias no instalador e na interface do usuário. InterSystems IRIS IntegratedML ainda não está disponível no Ubuntu 24.04.
 

Além disso, esta versão aborda dois defeitos em todas as plataformas:

  • Uma correção para algumas consultas SQL usando “NOT%INLIST” retornando resultados incorretos. Anteriormente, emitimos um alerta sobre esse erro.
  • Uma correção para rastreamentos de pilha incompletos em determinadas circunstâncias. 

Como obter o software

Como de costume, as versões de Manutenção Estendida (EM) vêm com pacotes de instalação clássicos para todas as plataformas compatíveis, bem como imagens de contêiner no formato de contêiner Docker. Para obter uma lista completa, consulte a página Plataformas Suportadas.

Pacotes de instalação clássicos

Os pacotes de instalação estão disponíveis na página Versões de Manutenção Estendida do WRC. Além disso, os kits também podem ser encontrados no site dos Serviços de Avaliação.

Contêineres

Imagens de contêiner das edições Enterprise e Community do InterSystems IRIS e IRIS for Health e todos os componentes correspondentes estão disponíveis na interface da web do InterSystems Container Registry.

Os contêineres são marcados como "2024.1" ou "latest-em".
 

Discussão (0)1
Entre ou crie uma conta para continuar
Resumo
· Maio 22, 2024

¡Queda poco para que acabe el Concurso de Artículos! ¿A qué estás esperando?

Querido miembro de la Comunidad:

No dejes escapar los increíbles premios que están esperándote.

Algunos participantes ya han publicado sus artículos ¡Corre a verlos! 

 

Te dejamos toda la información al respecto en este post: https://es.community.intersystems.com/node/565946

Descripción del concurso: Escribe un artículo en español en la Comunidad de Desarrolladores, sobre cualquier tema relacionado con la tecnología de InterSystems.

Duración: del 6 de mayo al 2 de junio de 2024.

Premios

1. Todos los participantes ganan en el concurso de artículos técnicos de InterSystems -> Cualquier miembro de la Comunidad que participe en el concurso, recibirá un detalle de InterSystems por participar.

2. Premios de los Expertos – los artículos ganadores de esta categoría serán elegidos por expertos de InterSystems y podrán elegir en cada caso:

🥇 1er puesto: LEGO Ferrari Daytona SP3 o Banco Mágico Gringotts™ - Edición para coleccionistas. 

🥈 2do puesto: LEGO Sistema de Lanzamiento Espacial Artemis de la NASA o Chaqueta hombre Patagonia Nano Puff® Hoody.

🥉 3er puesto: Altavoz JBL Flip 6, Amazon Kindle 8G Paperwhite (Onceava generación) o Mochila Samsonite SPECTROLITE 3.0 15.6"

O como alternativacualquier ganador puede elegir un premio de una categoría inferior a la suya

Nota: Los premios están sujetos a cambiar si la disponibilidad en el país no permite su entrega.

3. Premio de la Comunidad de Desarrolladores – artículo con el mayor número de "Me gusta". La persona que gane, podrá elegir uno de estos premios:

🎁 Altavoz JBL Flip 6, Amazon Kindle 8G Paperwhite (Onceava generación) o Mochila Samsonite SPECTROLITE 3.0 15.6" 


¡Mucha suerte a todos!

Artigo
· Maio 22, 2024 6min de leitura

Tests de performance IRIS - PostgreSQL - MySQL avec Python

Il me semble que c'était hier, lorsque nous avons réalisé un petit projet en Java pour tester les performances d'IRIS, PostgreSQL et MySQL (vous pouvez consulter l'article que nous avons écrit en juin à la fin de cet article). Si vous vous souvenez bien, IRIS était supérieur à PostgreSQL et dépassait considérablement MySQL en termes d'insertions, sans grande différence au niveau des requêtes.

Discussão (0)0
Entre ou crie uma conta para continuar
InterSystems Oficial
· Maio 21, 2024

InterSystems Platforms Update Q2-2024

Here’s our Q2’2024 quarterly platforms update.  If you’re new to these updates, welcome!  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

With that said, on to the update…

InterSystems IRIS Production Operating Systems and CPU Architectures

Red Hat Enterprise Linux

  • Recent Changes
  • Upcoming Changes
    • We expect Red Hat to release RHEL 9.4 & 8.10 any day now.  Once these minor OS changes are released, we’ll begin minor OS certification for them on IRIS 2024.1.
    • The next major update for RHEL will be RHEL 10 which is expected in Q2 of 2025.
  • Further reading: RHEL Release Page

Ubuntu

  • Recent Changes
    • Support for Ubuntu 24.04 was added in IRIS 2024.1.0.267.2 on May 15, less than three weeks after Ubuntu 24.04 was released.
    • Now that Ubuntu 24.04 is available, IRIS 2024.1 will be the last major version that supports Ubuntu 20.04.  IRIS 2024.2 will only be available for Ubuntu 22.04 and 24.04.
  • Further Reading: Ubuntu Releases Page

SUSE Linux

  • Upcoming Changes
    • SUSE Linux Enterprise Server 15 SP6 is expected late Q2 or early Q3.  Details of what’s included are still emerging.
  • Previous Updates
    • Minor OS certification has been completed for SUSE Linux Enterprise Server 15 SP5 without problems.  SP5 includes Linux Kernel 5.14.21, OpenSSL 3.0.8, and Python 3.11.
    • General Support from SUSE for Linux Enterprise Server 15 SP3 came to an end on 12/31/2022, but extended security support will continue until December, 2025.

Further Reading: SUSE lifecycle

 

Oracle Linux

  • Previous Updates
    • Oracle Linux 9.2 has completed Minor OS certification on IRIS 2023.1 without incident.
  • Further Reading: Oracle Linux Support Policy

 

Microsoft Windows

  • Upcoming Changes
    • Windows Server 2025 is expected to be released in Q4.  We’re keeping an eye on it and formulating plans for support.
    • Windows 12 is expected even earlier with a possible GA date as early as June.  We’ll start the process of supporting the new OS after it’s been released.
  • Further Reading: Microsoft Lifecycle

 

AIX

  • Upcoming Changes
    • We’re planning to only support OpenSSL 3 kits starting with IRIS 2025.1. In IRIS 2023.3 & 2024.1, we provided two separate IRIS kits – one that supports OpenSSL 1 and one that supports OpenSSL 3.  Given the importance of OpenSSL 3 for overall system security, we’ve heard from many of you that you’ve already moved to OpenSSL 3.  If you have concerns about this, please reach out to me directly.
  • Previous Updates
    • Minor OS Certification has been completed for AIX 7.2 TL5-06 on IRIS 2023.1.
  • Further Reading: AIX Lifecycle

Containers

  • Upcoming Changes
    • We are planning to change the base container image from Ubuntu 22.04 to Ubuntu 24.04 with IRIS 2024.2
    • We’re considering changes to the default IRIS container to, by default, have internal traffic (ECP, Mirroring, etc) on a different port from potentially externally facing traffic (ODBC, JDBC, etc).  If you have needs in this area, please reach out and let me know.
  • Previous Updates
    • We have started regular updates of IRIS containers with patches to the base container image and third-party dependencies.  IRIS containers that follow the new tagging scheme now have at least every-other-week updates.

 

Minimum Supported CPU Models

To repeat the reminder from Q1’s platforms update, we announced that InterSystems IRIS 2024.1+ has a minimum required CPU functionality standard for Intel/AMD-based systems.  This allows IRIS to rely on certain CPU instruction extensions, such as AVX & BMI, that will result in significantly better performance of certain operations.  For more information, please see my InterSystems IRIS Minimum Supported CPU Models developer community post.

 

InterSystems IRIS Development Operating Systems and CPU Architectures

MacOS

  • Previous Updates
    • Apple has released MacOS 14 with IRIS support in IRIS 2024.1

 

InterSystems Components

Caché & Ensemble Production Operating Systems and CPU Architectures

  • Previous Updates
    • Cache 2018.1.9 was released on February 14. 
    • There are only 3 more maintenance releases of Caché & Ensemble planned.  See  Jeff’s excellent community article for more info.

InterSystems Supported Platforms Documentation

The InterSystems Supported Platforms documentation is the definitive source information on supported technologies.

 

… and that’s all folks.  Again, if there’s something more that you’d like to know about, please let us know.

Discussão (0)1
Entre ou crie uma conta para continuar