InterSystemsDev

🔍 No more struggling with variables in #SQL LIKE queries - this guide dives into using LIKE in #InterSystemsIRIS, covering Embedded SQL, Dynamic SQL, Class Queries, special character escaping, and pattern tricks for precise matching 👇

https://community.intersystems.com/post/using-variables-and-patterns-sql

Perfect leaner #patternmatching in IRIS! #TipsAndTricks

77 views19:04

🚀 Learn how #InterSystemsIRIS makes working with #JSON simple: from creating and manipulating data structures to leveraging #SQL functions for advanced interoperability in #healthcare systems 👇

https://community.intersystems.com/post/intersystems-iris-json

Start creating #AI agents that go far beyond simple chatbots!

88 views16:56

⚙️ Want to run FastAPI apps natively in #InterSystemsIRIS? This template shows how to deploy a full #FastAPI app using #Docker, with built-in support for #SQL, #JSON, and more 👇

https://community.intersystems.com/post/running-fastapi-applications-iris

Give it a spin and supercharge your #Python + IRIS workflow!

69 views15:05

🧩 Want to run Django apps natively in #InterSystemsIRIS? This ready-to-use template lets you deploy #Django via #Docker with support for #RESTAPIs, SQL, #JSON & more 👇

https://community.intersystems.com/post/running-django-applications-iris

Try it out and build secure, scalable web apps with Django + IRIS! #Python #SQL

74 views15:05

🚀 Welcome a new entry from the InterSystems Demo Games 2025!

Watch this #video to see how InterSystems FHIR #SQL Builder projects #FHIR data into a dataset for vector embedding, and then powers a #RAG chain with an #LLM + chatbot for smarter insights 👇

https://community.intersystems.com/post/demo-video-fhir-powered-ai-healthcare-assistant

🗳️ If you like this demo, vote for it here: https://community.intersystems.com/contests/current?sort=creation#:~:text=%5BDemo%20Video%5D%20FHIR%2DPowered%20AI%20Healthcare%20Assistant

64 views10:11

64 views12:31

57 views09:45

90 views17:15

🧠 #InterSystemsIRIS 2024 brings #vector types to #SQL! Learn how to harness SQLEmbeddings for similarity search, clustering, and more, right in your #database 👇

https://community.intersystems.com/post/unleashing-power-vector-search-sql-embedding

Unlock powerful new search and #AI features with just #SQL! #VectorSearch

71 views20:49

🔗 Need to connect #InterSystemsIRIS to #SQL Server? This step-by-step #tutorial shows how to set up an #ODBC connection using the Management Portal 👇

https://community.intersystems.com/post/connecting-iris-sql-server-using-odbc-connection

Start integrating your data platforms today!

63 views16:25

🔥Curious how to make your #SQL LIKE queries in #InterSystemsIRIS not just work, but run efficiently, securely, and at scale? This article breaks down the key best practices every developer should know 👇

https://community.intersystems.com/post/optimizing-sql-security-performance-and-best-practices

Dive in and level up your SQL game!

68 views16:02

📊 Learn how to calculate running totals, ranks, and moving averages without cumbersome joins and loops! Dive in for a detailed look at #SQL window functions in #InterSystemsIRIS and see how they provide more accurate and faster #analytics 👇

https://community.intersystems.com/post/understanding-sql-window-functions-part-1

Improve your SQL analysis skills!

44 views20:01

📡 Discover how #InterSystemsIRIS interoperability powers real-time data architectures using CDC - enabling seamless streaming from #SQL and CSV sources into columnar #databases and Kafka for high-performance analytics 👇

https://community.intersystems.com/post/data-streaming-intersystems-iris-interoperability

Learn how to build scalable, continuous, and robust #interoperability data flows!

25 views17:13