34 Application(s) results for #sql
Filter
Show only
Last release on OEX
Categories
Works with
Industry
Application NameDeveloperMade withRatingLast updatedViewsInstalls

openflights_dataset

Openflights demo dataset, datamodel for InterSystems IRIS

A
Andreas Schneider
Docker
3.0 (1)22 Apr, 2025 665

SQL DATA LENS

Fast database sql tool with special features for IRIS & Caché

A
Andreas Schneider
5.0 (1)21 Apr, 2025 1.1k

InterSystems Ideas Waiting to be Implemented

AI extensibility Prompt keyword for Class and Method implementation. Also Prompt macro generator.

To accelerate capability of growing code generation. This proposal suggests new extensibility facilities and hooks that can be democratized to community and / or fulfilled by commercial partners. To add Training metadata to Refine a Large Language Model for code, a "Prompt Input" is associated with an expected "Code Output", as part of a class definition. This provide structured keywords to describe: * The expected output * And / Or Chain-of-thought to generate the correct output | /// The following Prompt describes the full implementation of the class Class alwo.Calculator [Abstract, Prompt = "Provides methods to Add, Subtract, Multiply and divide given numbers." ] { /// The following Prompt describes the full implementation of the method ClassMethod Add(arg1 As %Float, arg2 As %Float) As %Float [ Prompt ="Add numeric arguments and return result." ] { return arg1 + arg2 } ClassMethod Subtract(arg1 as %Float, arg2 As %Float) { &Prompt("Subtract numeric arguments and return result") ) } | The Prompt macro generates code based on the context of the method it is within. Once resolved, it automatically comments out the processed macro. | ClassMethod Subtract(arg1 as %Float, arg2 As %Float) { //&Prompt("Subtract arguments and return the result") return arg1 - arg2 //&Prompt("Model alwogen-objectscript-7.1.3") ) | The generator leveraged at compilation time could be configured in a similar way to how source control is configured for a namespace. Configuration could lock / exclude packages from being processed in this way. A "\prompt" compilation flag could be used to control the default environment behavior and editor compilation behavior. For example to force reprocessing of previously resolved prompts due to a newer more capable version of code Large Language Model, then a "\prompt=2" could be applied. Different models or third-party services could be applied depending the language of the given method. When redacting source code by "deployment", the existing "deploy" facility could be extended to also ensure removal of "Prompt" metadata from code.

A
by Alex Woodhead

3

Votes

1

Comments
Vote

bdb-sql-utils

Various utilities from the SQL cookbook

B
Benjamin De Boe
Docker
IPM
4.5 (2)04 Feb, 2025 756 82

ObjectScript-Over-ODBC

Allow running ObjectScript and especially Global copy over ODBC

Robert Cemper
Docker
IPM
4.5 (1)26 Nov, 2024 398 18

Global-dump-to-SQL

Show Global by SQL SELECT

Robert Cemper
Docker
IPM
5.0 (1)26 Nov, 2024 580 24

IRIS-Test-Data-Generator

Used to generate test data

D
Dylan Cole
Docker
IPM
3.0 (1)29 Sep, 2024 145

BridgeWorks VDM

BridgeWorks VDM is an ad hoc reporting and graphical SQL query application.

Tony Coffman
0.0 (0)26 Aug, 2024 514

geo-vector-search

mathematical use of vector search

Robert Cemper
Docker
IPM
5.0 (3)27 Apr, 2024 283

Collection-Indexing-and-Query

How to get correct index for SQL query generator

Robert Cemper
Docker
IPM
4.0 (2)03 Feb, 2024 265 29

HL7-FHIR-Cohort-Population

HL7 to FHIR Cohort Population

M
Momeena Ali
5.0 (1)25 Jan, 2024 210

password-app-iris-db

Application for storing passwords

O
Oleksandr Zaitsev
Docker
Python
4.5 (2)17 Sep, 2023 321

Global-Scan-to-SQL

Analyze Globals by Subscript-Level

Robert Cemper
Docker
IPM
4.5 (1)16 Sep, 2023 370 24

SQL-for-ERRORS-Global

Map ^ERRORS Global and have a custom query for full content

Robert Cemper
Docker
IPM
5.0 (1)16 Sep, 2023 367 69

The adopted Bitmap

How to enable Bitmaps for nonstandard IDs

Robert Cemper
Docker
IPM
5.0 (1)16 Sep, 2023 233 33

DBeaver

Universal Database Manager and SQL Client

S
Serge Rider
4.9 (15)29 May, 2023 2.6k

Sheep’s Galaxy

Example of using InterSystems IRIS Cloud SQL and IntegratedML

M
Maria Gladkova
Docker
Python
ML
ML
2.0 (1)21 Apr, 2023 457

isc-cloud-sql-python-demo

A simple python and flask app with IRIS Cloud SQL on back

Evgeny Shvarov
Python
5.0 (1)23 Mar, 2023 260

NY Taxi Demo

A simple guide to NY taxi business, leveraging Columnar Storage

B
Benjamin De Boe
Docker
Python
IPM
5.0 (1)10 Jan, 2023 319 40

GoSelector

See Column Selectivity Vs Ratio of Distinct Values

A
Alex Woodhead
IPM
4.0 (1)14 Oct, 2022 168 5

CoffeeCo Full Stack Tutorial

IRIS Coffee Company tutorial

R
Raj Singh
Python
3.0 (1)12 Aug, 2022 294

Python IRIS SQL Procedures Sample

Samples of python running inside SQL InterSystems IRIS Database

Yuri Marx Pereira Gomes
Docker
IPM
5.0 (1)20 Jul, 2022 279 7

sql-rest-api

Simple REST API web app which accepts SQL and returns the result in JSON

Evgeny Shvarov
Docker
IPM
5.0 (1)07 Nov, 2021 583 34

csv2table

Example on how to import CSV to any existing table

Evgeny Shvarov
Docker
IPM
4.5 (1)29 Sep, 2021 255 11

Caché Monitor

Works with many of your databases but is specifically optimized for unique InterSystems Caché and InterSystems IRIS features. It combines many tools with a smart sql editor to provide easy access to your databases. Caché Monitor is like a swiss knife for InterSystems Caché \ IRIS, fast and very easy

A
Andreas Schneider
0.0 (0)15 Aug, 2021 1.8k

Create a unified hospital data extraction scheme based on IRIS for Health

Create a unified hospital data extraction scheme based on IRIS for Health

D
Deming Xu
0.0 (0)30 May, 2021 362

irisdemo-demo-restsql

Simple demo of IRIS exposing REST APIs created based on Swagger that have a SQL database as the backend.

A
Amir Samary
Docker
4.3 (2)04 May, 2021 504

Integration scheme for heterogeneous messages in heterogeneous systems

Integration scheme for heterogeneous messages in heterogeneous systems

D
Deming Xu
0.0 (0)28 Feb, 2021 198

HealthInfoQueryLayer

The application use generic interface to perform query on data schema and used globals as configuration. At run time, the program will implement the query referring to configurations. It's working as a prototype ObjectScript MyBatis Template.

B
Botai Zhang
0.0 (0)26 Feb, 2021 542

iris-multi-model-api-template

a simple demo of InterSystems IRIS multi-model data management via REST API

Evgeny Shvarov
Docker
IPM
5.0 (1)11 Jan, 2021 378 13

sqltools-intersystems-driver

InterSystems support for SQL in the SQLTools extension to Visual Studio Code

Dmitry Maslennikov
Docker
5.0 (1)08 Sep, 2020 620