Search

Hi developers! As you know InterSystems IRIS besides globals, object, document and XML data-models also support relational where SQL is expected as a language to deal with the data. And as in other relational DBMS InterSystems IRIS has its own dialect. I start this post to support an SQL cheatsheet and invite you to share your favorites - I'll update the content upon incoming comments. Here we go! List all the tables in database: SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' Credit to @Dmitry.Maslennikov Create table with current date and current time as defaults: CREATE TABLE CUSTOMER ( ID INTEGER PRIMARY KEY NOT NULL, NAME VARCHAR(100) NOT NULL, PASSWORD VARCHAR(20) NOT NULL, LAST_UPDATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, REGISTRATION_DATE DATE DEFAULT CURRENT_DATE NOT NULL ); notice functions CURRENT_TIMESTAMP and CURRENT_DATE are without parenthesis. Create stored procedure/function that uses ObjectScript inside: CREATE OR REPLACE FUNCTION IRIS_VERSION() RETURNS VARCHAR LANGUAGE OBJECTSCRIPT { Return $ZV } Call Stored procedure/function: select IRIS_VERSION() as "Version" Call internal functions. Return IRIS Version: Select $version Return current namespace: Select $namespace Run SQL from file (credit @Raj.Singh5479 ): DO $SYSTEM.SQL.Schema.ImportDDL("c:\InterSystems\mysqlcode.txt",,"IRIS") Run SQL from file using python terminal(credit @Dmitry.Maslennikov): irissqlcli iris://_SYSTEM:SYS@localhost:1972/USER < c:\InterSystems\mysqlcode.txt Open SQL shell in terminal(credit @Chad.Severtson): USER>:sql Open SQL shell in webterminal (credit @Nikita.Savchenko7047 ): SAMPLES > /sql SAMPLES:SQL > select top 5 * from Cinema.Film ID Category Description Length PlayingNow Rating TicketsSold Title 1 1 A post-modern excursion into family dynamics and Thai cuisine. 130 1 PG-13 47000 Her Spicy Brothers 2 1 A gripping true story of honor and discovery 121 1 R 50000 Einstein's Geisha 3 1 A Jungian analysis of pirates and honor 101 1 PG 5000 A Kung Fu Hangman 4 1 A charming diorama about sibling rivalry 124 1 G 7000 Holy Cooking 5 2 An exciting diorama of struggle in Silicon Valley 100 1 PG 48000 The Low Calorie Guide to the Internet SAMPLES: SQL > /sql SAMPLES > write "COS!" cos! Add yours? nice! Thanks ... I didn't know you could do things like Select $zversion :) here it s in practice for those interested: USER>d $system.SQL.Shell() SQL Command Line Shell ---------------------------------------------------- The command prefix is currently set to: <<nothing>>. Enter <command>, 'q' to quit, '?' for help. [SQL]USER>>select $zversion 1. select $zversion Expression_1 IRIS for Windows (x86-64) 2022.1.2 (Build 574U) Fri Jan 13 2023 15:08:27 EST 1 Rows(s) Affected statement prepare time(s)/globals/cmds/disk: 0.1884s/34,356/143,526/0ms execute time(s)/globals/cmds/disk: 0.0007s/0/394/0ms cached query class: %sqlcq.USER.cls1 is there no quicker way to list all database tables? Like the postgresql \t? in irissqlcli, you can use \dt or .tables Try ":sql" instead of d $system.SQL.Shell() Holy cow @Chad.Severtson, that's really cool! Do you know when that was added / where I can find more information? I don't see it in the docs on SQL Shell (https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=GSQL_shell). Also, what is the ":" shorthand for and where else can it be used? Would be nice to have Run SQL from a file: DO $SYSTEM.SQL.Schema.ImportDDL("c:\InterSystems\mysqlcode.txt",,"IRIS") or irissqlcli iris://_SYSTEM:SYS@localhost:1972/USER < c:\InterSystems\mysqlcode.txt :py for embedded python @Dmitry.Maslennikov - thank you! Docs reference? Do you know what the ":" syntax is? Hey @Benjamin.Spead, You can find out more about the alias capability of iris session here: Using the Terminal Interactively | Using the Terminal | InterSystems IRIS Data Platform 2022.3 It's quite useful. You can even provide parameter substitution with $1, $2, etc. USER>:? :<number> Recall command # <number> :? Display help :py Do $system.Python.Shell() :mdx Do $system.DeepSee.Shell() :sql Do $system.SQL.Shell() :tsql Do $system.SQL.TSQLShell() :alias Create/display aliases :clear Clear history buffer :history Display command history :unalias Remove aliases HTH wow. Didn't know we have that! And aliases can be setup and transferred too? E.g. like a package (IPM)? Creating Aliases for Commonly Used Commands from docs:If you are using a UNIX® or Linux system, you can provide a list of alias definitions which the Terminal will set automatically at the start of every session. Define these aliases (one per line) in a file named .iris_init in the home directory.never tried this. I rarely work on *X or [SQL]USER>> run filename.sql You can also save the current query [SQL]USER>>save filename.sql Another very cool aspect of the feature :) So it looks like this is just a built-in alias which ships with InterSystems IRIS. Nice work @Evgeny.Shvarov those typical things you want to do quickly and never remember and have to read the docs :-) holy cow #2 :-) so much precious info on this thread! seriously! it's amazing how much knowledge there is to be gleaned within this community :) It has been around for a few years.Personally, I hesitate to use the alias capability lest I find myself in an environment without them! Thanks, Luca! Just a note... LAST_UPDATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, This field will only define the LAST_UPDATED field at INSERT, not for an UPDATE. You probably want something like: LAST_UPDATED TIMESTAMP DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) NOT NULL, This will cause LAST_UPDATED to be set at INSERT and UPDATE to the current timestamp to microsend precision. Thank you @Jeffrey.Drumm !!! For those that posted "I never knew that! Wow!" about the aliases: didn't you read this 2 years ago?😞

Hi Developers! Welcome to the 7th edition of the InterSystems Ideas news bulletin! Read on to learn what has happened on the Ideas Portal since the previous bulletin: ​​​​✓ More than 200 ideas are already on the portal ✓ Idea was implemented by a Community member ✓ Implement an idea and get a tech bonus on the Grand Prix 23 Contest ✓ Ideas posted recently Since the launch of the Ideas Portal, 204 ideas have been posted there. Now 25 of them have already been implemented, and 17 are planned for implementation. @Francisco.López1549 was added to the Hall of Fame for the implementation of an idea IRIS classes for OpenAI API by @Yuval.Golendginer 👏Thank you for implementing this idea👏 Developers participating in the InterSystems Grand Prix 23 Programming Contest can get 4 technical bonus points for the implementation of Community Opportunity ideas. Recently posted ideas 1. Add a "Type-to-Filter" ability in dropdown selections. by @Victoria.Castillo2990 2. Make Data Transformation UI guess about message types automatically by @Evgeny.Shvarov 3. Make Every Operation and Service Expose its message classes by @Evgeny.Shvarov 4. Custom Visualizations for Physicians by @Ikram.Shah 5. Introduce InterSystems IRIS support for Apache Airflow by @Evgeny.Shvarov 6. Introduce an Interoperability module (adapter, operation) for pdf.co by @Evgeny.Shvarov 7. Add a parameter in Visual Trace to see the message contents in XML or JSON by @Sylvain.Guilbaud 8. Specific cache buffers per DB by @Yaron.Munz8173 9. Module deployment support via Production Export in Dev environment by @Alexander.Woodhead 10. Envrionment variable support in System Default Settings by @Alexander.Woodhead 11. Settings should be a part of Mirroring by @Scott.Roth 12. Have nicknames for community users by @Minoru.Horita 13. Make all Production Item Settings available in Defaults Settings by @Stefan.Cronje1399 14. Add hyperlink to documentation web page from management portal options by @LuisAngel.PérezRamos 15. Delete drafts from InterSystems Developer Community by @Yuri.Gomes 👏Thank you for generating new ideas👏 Don't forget to vote, comment, and subscribe to the ideas to track and influence their progress. And look out for the next news bulletin! Hey Community! 👋While reading comments to ideas I found out that the idea "Include support for GraphQL" is implemented. @Gevorg.Arutiunian9096 welcome to the "Hall of Fame" page of the Ideas Portal for implementation of this idea! 👏 Hi Developers! One more idea is implemented by Community members. 👏 @John.Murray thank you so much for implementing the idea Unit testing in VSCode and welcome to the "Hall of Fame" page! 🏆 @Lorenzo.Scalese 👋 thank you for implementing the idea "REST API for Security Package" and congratulations on your second record in the the "Hall of Fame" page! 👏

The Telegram Adapter for InterSystems IRIS serves as a bridge between the popular Telegram messaging platform and InterSystems IRIS, facilitating seamless communication and data exchange. By leveraging the capabilities of the Telegram API, the adapter allows developers to build robust chatbots, automate tasks, and integrate Telegram with InterSystems IRIS applications. The most common scenarios where the Telegram Adapter can be used include: Real-Time System Notifications: Sending immediate notifications about specific events occurring in the system. This can include alerts, updates, or important system information delivered to users or administrators via Telegram. Customer Interaction and chatbot Applications: This can involve various activities such as appointment scheduling, appointment reminders, and conducting NPS (Net Promoter Score) surveys to gather customer feedback. Intelligent chatbots can be created that integrate with existing systems, have access to extensive knowledge bases, and are capable of answering user questions. Training and Testing: It can be used to deliver training materials, interactive quizzes, or conduct assessments through Telegram. Key Features and Functionality Bi-Directional Communication All features of the Telegram Bot API are supported (https://core.telegram.org/bots/api) Out-of-the-box business services, business operations, and messages Adapter Technical Details. The telegram-adapter package includes not only the adapter itself but also ready-to-use business services (Telegram.LongPollingService.cls and Telegram.WebHookService.cls), a business operation (Telegram.BusinessOperation), and the Telegram.Request message class. It is assumed that you will not need to create your own business services or business operations. Each of these business services will create and send a message containing all the raw data (received from telegram) to the designated production component as specified in the settings. Additionally, you have the option to configure automatic file (document) saving from incoming messages. To send a message, you need to create a Telegram.Request message, specifying which API method to invoke, and in the Data field, include the JSON with all the required fields for the Telegram API. For example, let's send a text message: Set msg = ##class(Telegram.Request).%New() Set msg.Method = "sendMessage" // All possible fields are described here https://core.telegram.org/bots/api#sendmessage Set msg.Data = { "chat_id" : (..ChatId), "text": ("*bold text*" _$$$NL_ "_italic text_ " _$$$NL_ "```"_$$$NL_"pre-formatted fixed-width "_$$$NL_"code block```"), "parse_mode": "MarkdownV2", "disable_notification": "true" } Return ..SendRequestAsync("Telegram.BusinessOperation", msg) To send files such as images, videos, audio, and other types of files, you need to add the full file name (including the path) to the Files collection of the Telegram.Request object and use the same path in the corresponding fields of the JSON message. Here's an example: Set filePath = "/path/to/photo.jpg" Set msg = ##class(Telegram.Request).%New() Set msg.Method = "sendPhoto" Do msg.Files.Insert(filePath) // All possible fields are described here https://core.telegram.org/bots/api#sendphoto Set msg.Data = { "chat_id": (..ChatId), "photo": (filePath), "caption": ("IRIS Telegram Adapter Demo") } Return ..SendRequestAsync("Telegram.BusinessOperation", msg) Telegram Adapter Demo The telegram-adapter-demo package includes an example of an Echo chatbot implementation. The bot responds to any text message sent to it. If you send a .png file, it will also reply with a thumbnail of that image, automatically generated by Telegram. To run this example, follow all the installation steps outlined in the documentation provided at https://github.com/nsolov/telegram-adapter-demo#readme. By completing the installation process, you will be able to launch and experience this Echo chatbot example.

Dive into the details of InterSystems technologies with long-term online programs and classroom courses. Then, show off your skills with program and certification badges! Find all the details in this month's Learning newsletter. Don't forget to subscribe to receive the newsletter in your inbox!

Hi Developers! Welcome to the 9th edition of the InterSystems Ideas news! In this issue you can learn about: ​​​​✓ New page on the Ideas Portal - Idea-A-Thon Winners ✓ Implemented ideas for future announcements ✓ New ideas posted recently We've added a new page to the Ideas Portal dedicated to the Winners of 1st and 2nd InterSystems Idea-A-Thon Contests. Check it out to vote and comment on the ideas, if you haven't done so already! Last month we asked what ideas you would like to learn more about. Based on your votes the following ideas were selected: Examples to work with IRIS from DjangoGlobal->JSON->Global converterIntroduce the project of helpful one-liners Thus, you may look forward to discovering more info about these projects and underlying ideas. Drop us a line in the comments, if you wish to learn about other ideas and their realization as well! To round up this newsletter, here are 41 new ideas posted after the 2nd InterSystems Idea-A-Thon Idea Author Create real world application by using IRIS and python Streamlit web framework @Muhammad.Waseem FHIR step by step setup @Scott.Roth Implement IRIS connector for Airbyte data integration engine @Dmitry.Maslennikov Power Platform Connector for InterSystems IRIS @Vadim.Aniskin Implement support to Fivetran, data movement platform @Dmitry.Maslennikov Slides as a new type of content on DC @Yuri.Gomes Facial authentication on Management Portal @Yuri.Gomes Implement autosave for DTL and BPL pages @LuisAngel.PérezRamos Visual trace contents in JSON format @Ashok.Kumar Manage SQL accesses to all or some schemas in a database, instead of managing it a the tables level @Sylvain.Guilbaud Dynamic creation of REST Response @Scott.Roth Add Inbound Interoperability adapter for HTTP Calls @Evgeny.Shvarov Add MarkDown input possibility @Niels.Genne5509 Advanced Interface Monitoring and Alerting @Daniel.Metcalfe Use browser engine @André.DienesFriedrich Group selectable "Service class" by technology, not just alphabetically @LuisAngel.PérezRamos SharePoint File Service and Operation @Ties.Voskamp Enhance the Interface Maps @Paul.Hurley Add a Support category to the Services offered. @Paul.Hurley HL7 test message generator @Vadim.Aniskin Include more examples / documentation @Jason.Neate Using OpenSSH Key for Authentication in IRIS on Systems based accounts @Scott.Roth Reference architectures for VIPs on SDNs in GCP @Eduard.Lebedyuk Change the style of the tables in the official documentation @Heloisa.Paiva Automatic prettification/beautification of JSON in visual trace @Pietro.DiLeo Sync Community and Open Exchange users @LuisAngel.PérezRamos Drivers and auxiliar tools accessible from Community @LuisAngel.PérezRamos Sentient - Use the correct email address @Alex.Woodhead IPM store on Management Portal @Yuri.Gomes Show pending PR and Issues imn OEX package @Robert.Cemper1003 Implement samples of $system.external interface (aka "InterSystems External Servers") @Enrico.Parisi Implement support status for OEX packages @Robert.Cemper1003 Vector Database Web Gateway offload encoding inbound and generative interface outbound @Alex.Woodhead Introduce an Interoperability Adapter for POCT1A and POCT1A-2 standards @Evgeny.Shvarov DB Driver for Django @Stefan.Cronje1399 SQL Return ID @Stefan.Cronje1399 Add Email-Only 2FA @David.Hockenbroch Dynamic object for XML or XML to JSON string converter @Heloisa.Paiva Add SCRAM-512 Authentication to IRIS Kafka adapters @Oliver.Wilms Managing message queue @Marykutty.George1462 👏Authors, thank you for posting your brilliant ideas👏 Stay tuned for the next announcements! In the meantime, post your bright ideas, vote, and comment on existing ideas on our InterSystems Ideas Portal!

Hey Developers, The InterSystems Security contest is over. Thank you all for participating in our coding competition! So it's time to announce the winners! A storm of applause goes to these developers and their applications: 🏆 Experts Nomination - winners were determined by a specially selected jury: 🥇 1st place and $4,000 go to the iris-disguise project by @henry 🥈 2nd place and $2,000 go to the zap-api-scan-sample project by @José.Pereira and @Henrique 🥉 3rd place and $1,000 go to the iris-saml-example project by @Dmitry.Maslennikov More winners: 🏅 $100 go the API Security Mediator by @Yuri.Gomes 🏅 $100 go the Data_APP_Security by @Muhammad.Waseem 🏅 $100 go the Server Manager 3.0 Preview by @John.Murray 🏅 $100 go the IRIS Middlewares by @davimassaru.teixeiramuta 🏅 $100 go the isc-apptools-lockdow @MikhailenkoSergey 🏅 $100 go the Audit Mediator by @Yuri.Gomes 🏅 $100 go the passwords-tool by @Dmitry.Maslennikov 🏅 $100 go the appmsw-dbdeploy @MikhailenkoSergey 🏆 Community Nomination - an application that received the most votes in total: 🥇 1st place and $1,000 go to the zap-api-scan-sample project by @José.Pereira and @Henrique 🥈 2nd place and $500 go to the iris-disguise project by @henry 🥉 3rd place and $250 go to the API Security Mediator by @Yuri.Gomes Congratulations to all the winners! Thank you all for your attention to the contest and the efforts you pay into this contest! Good fellows! Congratulate everyone! Congratulation to all. Thanks DC Congratulation to all participants! 👏 Also thanks for participation to: @Oliver.Wilms and his project https-rest-api@Evgeniy.Potapov and his project TimeTracking-workers See you in the next Contests! Congratulations everyone!!!! Congratulations. Well done to the winners! Thank you for participating in the contest and contributing to our community as a result!! Congratulations to all participants!!

Hi Community, We'll look at moving InterSystems workload to the public cloud, then take a deep dive into the current architectures on the InterSystems cloud platform: ⏯ InterSystems Solutions in AWS Presenters:🗣 Jared Trog, Senior Cloud Engineer, InterSystems🗣 @Regilo.Souza, Product Owner - Cloud Strategy, InterSystems Enjoy watching and stay tuned!

Hey Developers, We are super excited to announce the winners of the InterSystems Globals contest! The winners of the 19th programming contest are as follows: Experts Nomination 🥇 1st place and $4,000 go to the global-mindmap created by @Yuri.Gomes 🥈 2nd place and $2,000 go to the globals-tool created by @Dmitry.Maslennikov 🥉 3rd place and $1,000 go to the iris-globals-graphDB created by @Muhammad.Waseem More winners: 🏅 $100 go the python-globals-serializer-example created by @José.Pereira 🏅 $100 go the global-archiver created by @Lorenzo.Scalese 🏅 $100 go the blockchain - [ IRIS python ] created by @davimassaru.teixeiramuta 🏅 $100 go the Globals: Embedded Python vs. ObjectScript created by @Robert.Cemper1003 🏅 $100 go the zpm-generate-ui created by @MikhailenkoSergey 🏅 $100 go the GlobalToJSON-XL-Academic created by @Robert.Cemper1003 🏅 $100 go the Cubes created by @Sean.Connelly 🏅 $100 go the GlobalToJSON-Efficient created by @Robert.Cemper1003 🏅 $100 go the iris-globals-contest created by @Oliver.Wilms 🏅 $100 go the GlobalToJSON-Compact created by @Robert.Cemper1003 🏅 $100 go the global-name-search created by @Jailton.Viçôzo 🏅 $100 go the React-UI-Global created by @Evgeniy.Potapov Community Nomination 🥇 1st place and $1,000 go to the globals-tool created by @Dmitry.Maslennikov 🥈 2nd place and $750 go to the python-globals-serializer-example created by @José.Pereira 🥉 3rd place and $500 go to the iris-globals-graphDB created by @Muhammad.Waseem Our BIG congrats to all the participants and winners! We can see all the hard work in your participation, and we would like to thank you for devoting your time and building a project for the InterSystems contest. 🙌 What's next? Don't get disheartened if you didn't win. Remember, persistence is the key to success! Participate in the next contest in May 😎 I am really happy. It's an honor to win the expert nomination. After participating in 17 contests, I achieved the dream of winning. Thank you very much and congratulations for all participants. Congratulations to AAAALLLLL!! 😄😄👏👏 Congratulations to All Congratulation @Yuri.Gomes. Well Done 👏 Thanks! A hearty CONGRATS to the winners :)

Hi Community, I published my new app (https://openexchange.intersystems.com/package/global-mindmap) online to write an InterSystems Mindmap with you. Write your mind notes and help to build the InterSystems Mindmap. I will transform the final result in an article. Access: http://ymservices.tech:3000 Thanks @Yuri.Gomes that link doesn't work for me. Hi, In the first time, take about 30 seconds to load, try again, thanks

@Yuri.Gomes. ... I love the diagram!! What about the Evaluation service and the WRC and GettingStarted? Great, I will add! WOW!!! Love it :) Thanks! @Yuri.Gomes - if you go to https://login.InterSystems.com you will see that we have published new icons for all of our applications which are consistent with the ISC look and feel. Feel free to pop these into your diagram for consistency. Any interested in learning more about these services should attend DEV005 at Global Summit where @Pravin.Barton and I will discuss the 15 services and applications you can access via your InterSystems Login Account (Wed at 3:30). Hope to see many of you there! Wow great stuff, thank you @Yuri.Gomes ! Sharing with @Jinmin.Xu, @Piyush.Adhikari, @Paul.Doolub4524, @Vladimir.Prushkovskiy Great Diagram, love it!!!

Hey Developers, Learn about the changes we've made to InterSystems IRIS Containers, including security updates and the new web gateway container: ⏯ InterSystems IRIS Container Updates 🗣 Presenter: @Eve.Phelps, Senior Systems Developer, InterSystems Stay tuned for the latest videos on InterSystems Developers YouTube!

Global Summit returns! After two years of video conferencing and virtual meetings, we at InterSystems are thrilled to reunite with our partners at InterSystems Global Summit 2022. In our first in-person event since the pandemic started, we're welcoming industry leaders and developers to our flagship conference. Registration is now open! ➡️ InterSystems Global Summit 2022 🗓 Date: June 20-23, 2022 📍 Location: Seattle, WA, United States Join us this year for content on how customers like you are using our technology for innovation and what trends affect our future innovations, including new and enhanced products and product offerings. In-Person Live Breakout Sessions, Experience Labs, Small Group Idea Exchange Cloud & cloud services DevOps Embedded Python HL7® FHIR® Analytics Product use cases New products & services Solutions for healthcare, financial services & supply chain/logistics Interactive Because this year's event is live and in-person, there will be ample opportunity for you to interact with InterSystems product teams, including heads of healthcare & data platforms solutions Technical pros Product trainers InterSystems partners and best of all One another Inspirational Speakers from cutting-edge of technology Ideas & best practices from peers & InterSystems partners, product developers Learning opportunities Hands-on experiences with InterSystems technology The best part: We’ll do it all together. We look forward to seeing you at InterSystems Global Summit 2022! Good day, is there a way to register virtually? No, you are expected to come in person! We are looking forward to our first in-person summit in 2019! You can redeem free registration and accommodation if you have enough points in Global Masters. Would be nice to have the support corner again to talk with the WRC folks.

Hey Community! Welcome to the 3rd edition of the InterSystems Ideas news bulletin! Curious about what has happened on the Ideas Portal since the previous one? Read on! First of all, we've created a short video that explains the lifecycle of the ideas on the Portal: ⏯ Lifecycle of ideas on the InterSystems Ideas The most important piece of news is a brand new section on the portal - Portal Guide which contains: ✓ information about the Ideas Portal goal, ✓ a complete list of idea's statuses with their description, ✓ links related to the portal. Want to see something else there? Drop us a line in the comments! Another interesting tidbit is that 11 of your ideas are already in the status "Planned or in Progress". And, to complete this news bulletin, here is the list of the ideas that have already been implemented Career-oriented learning paths Change the layout of the "New idea" screen Enable the server widget on Discord Include support for gRPC protocol in IRIS Make JSON representation of messages in Interoperability message viewer instead of XML Create query builder Global->JSON->Global converter Chatbots solution for InterSystems Data Platforms 3DES support InterSystems IRIS as a Datasource for Google DataStudio Introduce a basic template to create interoperability adapters using Embedded Python Introduce the project of helpful one-liners As usual, don't forget to vote, comment, and subscribe to the ideas to track and influence their progress. We're looking forward to your ideas on the InterSystems Ideas portal!

A Minute Of Laughter on the Developer Community with #InterSystemsMemes Meme author: @Mathieu.Delagnes Have your own idea for a meme? Submit in this challenge on Global Masters. About InterSystems Memes rubric: A month ago we launched a challenge on Global Masters where we asked you to create memes about InterSystems technology. We had a lot of fun seeing all the entries so we decided to share this merriment with all DC members! 😁😁😁 Who's next?)) Don't hesitate to share the memes in the comments to this post as well ;) * ~90% under the surface For performance-minded folks: ...

Hey Developers, Now it's time for all French-speaking users of our community! We're super excited to announce the official start of the InterSystems Developer Community in French! Let me introduce you @Guillaume.Rongier7183, @Robert.Bira and @Irène.Mykhailova as managers of the French Community. Here are the main points you need to know: ➡️ You can switch between sites using the language menu in the top right corner: If you know French, it's great that you can contribute articles, make discussions, ask and answer questions about InterSystems Data Platforms now in French too! Also! ➡️ You can use Language Switcher – the option to switch to the French version of the article. Also! ➡️ If you published a post in English or any other language, it could be translated by anyone in French and will be helpful for even more people! Everyone is able now to add or request a translation to any post on the Developer Community. After selecting any language using the Language Switcher, any user can add a link to the translation of the post or request its translation. ➡️ The same thing works for the French Community site – you can translate the French article into English or any other language. Be sure, you know both languages well! Please feel free to provide any feedback on how to make our French Community better. Welcome to the InterSystems Developer Community in French! 🚀 Let's discuss the topics that you'd like to see and discuss on the FR DC. Take the poll below ☑️ Or feel free to share your suggestions in comments! C'est super! Bienvenue!!! Génial !@Yann.Simons9265 @Aurélien.Lansmanne @Damiano.Porrovecchio Génial! Super nouvelle! J'ai transmis l'info à l'équipe avec laquelle je travaille, ainsi qu'aux personnes qui pourraient être intéressées par Intersystems... On ne sait jamais. Reste à faire vivre cette commu! Merci @Guillaume.Rongier7183 @Irène.Mykhailova et @Robert.Bira, ainsi que tous ceux qui ont oeuvrés à l'ouverture de ce site francophone Bienvenue à tous!! 👋👋👏👏 Enfin la communauté dans la langue deRobert le Magnifique et son fils Guillaume le Conquérant. !* * * * * + + + * * * * * Bienvenue The Great Getsby !