Question Jack Rack · Oct 11 Can I build a custom task scheduler inside IRIS with CRON-like rules, retry policies, and distributed execution? The built-in task manager is limited. How can I implement a robust, distributed job scheduler in IRIS with support for dependencies, CRON syntax, and failover recovery? #InterSystems IRIS 0 1 0 47
Question Jack Rack · Oct 11 Can I build a decentralized ledger (DLT) inside InterSystems IRIS using deterministic globals and consensus modules? We want to use IRIS as a backend for a lightweight blockchain or DLT. Can we model blocks using deterministic globals and implement consensus (PBFT, Raft) externally while using IRIS as the ledger? #InterSystems IRIS 1 1 0 22
Question Jack Rack · Oct 11 How do I trace low-level deadlocks between globals, SQL tables, and object transactions across mirrored IRIS instances? We're encountering occasional deadlocks in a mirrored IRIS deployment. How can we track down which global or object write caused the lock cycle, and how does IRIS mirror lock propagation internally? #InterSystems IRIS 0 1 0 38
Question Jack Rack · Oct 11 Can I hook into the IRIS SQL compiler to inject dynamic policies (e.g., tenant filtering, row masking)? We require automatic injection of security predicates at runtime, depending on the user or API token. Is there a supported or hackable mechanism to manipulate SQL parsing/compilation before execution? #InterSystems IRIS 0 2 0 40
Question Jack Rack · Oct 11 How do I implement secure identity federation (OAuth2, SAML) for InterSystems IRIS web apps? We need to authenticate users via Azure AD or Okta. What are the best practices to implement federated authentication using OAuth2/OIDC or SAML in IRIS Management Portal or custom web apps? #InterSystems IRIS 0 1 0 32
Question Jack Rack · Oct 11 How can I integrate InterSystems IRIS with Apache Flink for real-time event stream processing? We use Apache Flink for complex event processing. Is there a way to integrate IRIS (as a source/sink) with Flink’s streaming API, possibly using the IRIS Native API or JDBC? #InterSystems IRIS 0 1 0 22
Question Jack Rack · Oct 11 How do I build a custom cost-based query optimizer rule in IRIS SQL engine? Can the IRIS SQL engine be extended with custom optimization rules (e.g., prioritizing certain indices or join orders)? If not, is there a supported way to influence cost models? #InterSystems IRIS 0 0 0 18
Question Jack Rack · Oct 11 How do I trace IRIS internal locking behavior for debugging deadlocks in object transactions? We’re encountering occasional deadlocks when accessing persistent objects. How can I trace lock acquisition and identify cyclic dependencies in real time? #InterSystems IRIS 0 1 0 34
Question Jack Rack · Oct 11 How can I create a hybrid REST and GraphQL API layer over IRIS data using ObjectScript? We want to expose both REST and GraphQL endpoints over the same data models. Is there a way to implement or integrate GraphQL with ObjectScript and map to class methods? #InterSystems IRIS 0 1 0 33
Question Jack Rack · Oct 11 How can I write an IRIS interoperability adapter for high-throughput WebSocket connections? I need to ingest streaming data over WebSockets. How can I create a custom inbound adapter for IRIS productions that supports many concurrent socket connections? #InterSystems IRIS 1 1 0 31
Question Jack Rack · Oct 11 How do I analyze and tune parallel query execution in IRIS SQL engine for complex joins? I have large joins involving millions of rows. How can I profile and tune the SQL engine’s parallel execution? Are there EXPLAIN plan features to inspect threading and task distribution? #InterSystems IRIS 0 1 0 26
Question Jack Rack · Oct 11 How can I design a dynamic class schema generator in ObjectScript based on runtime JSON input? Given a JSON schema at runtime, I want to programmatically create persistent classes with corresponding properties and indices. Is there a way to dynamically compile and load such classes? #InterSystems IRIS 1 3 0 61
Question Jack Rack · Oct 11 How can I implement an event-sourced architecture with journal-based replay using IRIS globals? I want to build an event store using raw globals and replay events for rebuilding state. Can I hook into IRIS journaling or write my own event log and replay engine? #InterSystems IRIS 1 1 0 24
Question Jack Rack · Oct 11 How do I implement eventual consistency with custom conflict resolution in IRIS mirroring or async replication? For geographically distributed nodes using async mirroring or ECP, how can I detect and resolve data conflicts manually (custom logic) while maintaining eventual consistency? #InterSystems IRIS 0 0 0 17
Question Jack Rack · Oct 11 How can I write a custom JSON adapter to serialize hierarchical IRIS objects with circular references? The built-in %JSONExport() fails with circular references in deeply nested objects. How can I write a custom serializer that supports circular detection and reference tracking? #InterSystems IRIS 0 1 0 40
Question Jack Rack · Oct 11 Can I implement row-level security in InterSystems IRIS using class parameters and runtime filters? We require user-specific row access (row-level security). How can we enforce this in SQL and ObjectScript using custom class parameters and dynamic WHERE clause injections? #InterSystems IRIS 0 2 0 53
Question Jack Rack · Oct 11 How do I perform predicate pushdown optimization in IRIS embedded SQL with dynamic joins? Body: When writing dynamic SQL queries using embedded SQL, how can I force or ensure that filter conditions are pushed down to the data access layer rather than evaluated in memory? #InterSystems IRIS 0 1 0 24
Question Jack Rack · Oct 11 How do I stream process and ETL terabyte-scale HL7/FHIR data using InterSystems IRIS Interoperability? We’re ingesting high-volume HL7 messages and converting them to FHIR in near-real-time. How do we design a streaming ETL pipeline using interoperability (productions) that scales horizontally? #InterSystems IRIS 1 1 0 29
Question Jack Rack · Oct 11 Can I customize the IRIS SQL query planner to optimize recursive CTE execution? I’m using recursive CTEs for hierarchical data, but the planner seems to produce inefficient plans. Can I influence or extend the query optimizer behavior in IRIS? #InterSystems IRIS 0 0 0 17
Question Jack Rack · Oct 11 How can I use $Order() traversal with lock-free concurrency for real-time analytics in IRIS? We want to iterate over large global structures in real-time without blocking or locking readers. How can we safely use $Order() and implement a lock-free analytics approach? #InterSystems IRIS 1 2 0 48