Subject: A bridge between worlds: Native MUMPS & Relational SQL in perfect coexistence
Hi everyone,
I wanted to share a small milestone from a project I’ve been working on, driven by a simple vision: enabling modern relational database capabilities without breaking or replacing our trusted MUMPS ecosystem.
Instead of fighting the "SQL vs. NoSQL/Globals" battle or planning complex migrations, the idea here is pure coexistence. By integrating a lean C layer directly into the MUMPS core engine, we can now execute full relational queries, schemas, and live transaction blocks (with explicit COMMIT and ROLLBACK control) natively—right out of our standard MUMPS code.
Your legacy globals remain untouched and run at full native speed. But whenever a programmer needs complex relational filtering or structured data access, they can stream results directly into local MUMPS symbols using a high-speed chunking mechanism and an automated dictionary mapper.
It’s about giving developers the best of both worlds under the exact same roof, keeping MUMPS as the master orchestrator.
The project is open-source and based on the Raymond Newman MUMPS engine structure. If you're curious about the architecture or want to look at the implementation, you are more than welcome to check out the repository:
https://github.com/rafifarchi/hybrid-mumps-engine/tree/mainWould love to hear your thoughts!
Best regards,
Farchi Rafi