Message-ID:

In theory, there is no difference between theory and practice. In practice, there is.

devel / comp.lang.mumps / M2SQL - A Project i developed and release as open source

M2SQL - A Project i developed and release as open source

<1e3070e1-bafc-43bd-8854-503592c7fdd6n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=178&group=comp.lang.mumps#178

X-Received: by 2002:a37:50f:: with SMTP id 15mr1104046qkf.297.1633440272941;
Tue, 05 Oct 2021 06:24:32 -0700 (PDT)
X-Received: by 2002:ac8:4588:: with SMTP id l8mr19221158qtn.207.1633440272778;
Tue, 05 Oct 2021 06:24:32 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.mumps
Date: Tue, 5 Oct 2021 06:24:32 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=80.179.39.49; posting-account=y0Lo1woAAACWlv7O7JU_2cWWNuMWsa9t
NNTP-Posting-Host: 80.179.39.49
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <1e3070e1-bafc-43bd-8854-503592c7fdd6n@googlegroups.com>
Subject: M2SQL - A Project i developed and release as open source
From: rafi.farchi@gmail.com (rafi farchi)
Injection-Date: Tue, 05 Oct 2021 13:24:32 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 23

by: rafi farchi - Tue, 5 Oct 2021 13:24 UTC

Hello Mumps Community ,

I have developed a very promising tool (to my opinion) which let you
map your mumps Globals in a relational view and as a result you can replicate
your mumps data to your favorite Relational data base .
The Replication can be either entire (generally daily) or
incremental , transferring only changes assuring an almost online relational
clone of your mumps data .
The purpose id not migration but benefiting from industry standard reporting tools and BI tools which will run on your clone relational DB.
The performance is very good . Replicating 10,000,000 records on mumps globals to sqlite DB (export and import) will take 2 minutes .
In case of incremental approach , updating 10,000 changes vs 10,000,000 lines Db will take 2 seconds (using sqlite replace) .

link :
https://sourceforge.net/projects/m2sql/

The product itself is completed and i still polishing the documentation .
Will be happy to assist any organization who wish to be a beta site .
It shroud be a medium size mumps data base and a real active application .
I will guide them on the mapping process and improve the product as we go .

Subject	Author
M2SQL - A Project i developed and release as open source	rafi farchi