Pop-Up Thingie

>>> Magnum BBS <<<
  • Home
  • Forum
  • Files
  • Log in

  1. Forum
  2. Usenet
  3. COMP.LANG.MUMPS
  • YottaDB transactions using SQL, Node.js, Python, PHP, Go and Ruby

    From K.S. Bhaskar@21:1/5 to [email protected] on Mon Mar 15 10:57:24 2021
    On Monday, March 15, 2021 at 1:35:13 PM UTC-4, [email protected] wrote:
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote database
    via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!

    Excellent news! Congratulations, Chris.

    Regards
    – Bhaskar

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Chris Munt@21:1/5 to All on Mon Mar 15 10:35:12 2021
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote database
    via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Antoine Koener@21:1/5 to All on Sat Mar 27 03:31:57 2021
    Le lundi 15 mars 2021 à 18:57:25 UTC+1, K.S. Bhaskar a écrit :
    On Monday, March 15, 2021 at 1:35:13 PM UTC-4, [email protected] wrote:
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote
    database via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!
    Excellent news! Congratulations, Chris.

    Regards
    – Bhaskar

    Excellent work !

    I have quickly review the mg_python source code and found that "strcpy" is still in use. :-(
    And looked a bit more and see that password or username are passed has is from the python code.

    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_python.c#L341
    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_dba.h#L1109

    I've stopped there my review because I think that the code may be full of buffer overflows ...

    I would suggest to check other libraries also for same vulnerabilities...

    Anyway this is still excellent contribution to open source community...

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Chris Munt@21:1/5 to Antoine Koener on Wed Apr 7 10:10:22 2021
    On Saturday, March 27, 2021 at 10:31:58 AM UTC, Antoine Koener wrote:
    Le lundi 15 mars 2021 à 18:57:25 UTC+1, K.S. Bhaskar a écrit :
    On Monday, March 15, 2021 at 1:35:13 PM UTC-4, [email protected] wrote:
    Over the last few weeks all M/Gateway Developments' language bindings, together with our SQL engine, have been updated to include direct access to database transaction processing functionality.

    All products mentioned here will work with YottaDB and the InterSystems databases (Cache and IRIS). All language bindings offer a choice of high performance in-process access to a locally installed database via the API or to a local or remote
    database via the network.

    SQL: https://github.com/chrisemunt/mgsql
    Node.js: https://github.com/chrisemunt/mg-dbx (https://www.npmjs.com/package/mg-dbx)
    PHP: https://github.com/chrisemunt/mg_php
    Python: https://github.com/chrisemunt/mg_python
    Ruby: https://github.com/chrisemunt/mg_ruby
    Go: https://github.com/chrisemunt/mg_go

    Products listed are, of course, Open Source solutions. Enjoy!
    Excellent news! Congratulations, Chris.

    Regards
    – Bhaskar
    Excellent work !

    I have quickly review the mg_python source code and found that "strcpy" is still in use. :-(
    And looked a bit more and see that password or username are passed has is from the python code.

    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_python.c#L341
    https://github.com/chrisemunt/mg_python/blob/5e29a542519667a99cf994e0dc19952c089bf6f6/src/mg_dba.h#L1109

    I've stopped there my review because I think that the code may be full of buffer overflows ...

    I would suggest to check other libraries also for same vulnerabilities...

    Anyway this is still excellent contribution to open source community...

    Many thanks for taking a look at mg_python.

    For the benefit of those not familiar with C programming, the use of the C string copy function - strcpy() - does not necessarily mean that the code is probably full of buffer overflows. The risk is not inherent in the use of this function (which,
    incidentally is still part of the standard C library) per se, but in the way it is (mis)used. I appreciate that some software houses mandate that it should not be used but the alternatives come with their own problems. The cold reality is that there is
    no standard replacement for this function - at least not one that's portable. To give some context: a quick scan of the PHP and Apache code base reveals that the developers of these products still use strcpy(), so we're in good company!

    While these mg_* language bindings have only recently been released as Open Source products the core code on which they are built has actually been in production use for around 20 years and, as such, I believe we have already addressed most, if not all,
    buffer overflow scenarios.

    The username/password referred to in the review is related to the use of the API of the InterSystems products. It is up to the Python developers to decide how this password should be protected. mg_python does not involve itself with the security layer -
    this is the responsibility of the developer.

    Of course, should anyone find an actual buffer overrun in mg_python then feel free to identify the problem and submit the fix. This is an Open Source initiative!

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • Who's Online

  • Recent Visitors

    • Bob Worm
      Mon Jun 8 16:33:22 2026
      from Wales, Uk via Telnet
    • Bob Worm
      Mon Jun 8 14:11:46 2026
      from Wales, Uk via Telnet
    • Krenn
      Mon Jun 8 11:22:02 2026
      from Sydney, Nsw via Telnet
    • Bob Worm
      Mon Jun 8 08:26:26 2026
      from Wales, Uk via Telnet
    • Spearb0y
      Mon Jun 8 06:51:02 2026
      from Massachusetts via SSH
    • Krenn
      Mon Jun 8 05:45:38 2026
      from Sydney, Nsw via Telnet
    • Bob Worm
      Sun Jun 7 20:58:28 2026
      from Wales, Uk via Telnet
    • Michal Wronka
      Sun Jun 7 19:26:28 2026
      from Wroclaw, Poland via SSH
  • System Info

    Sysop: Keyop
    Location: Huddersfield, West Yorkshire, UK
    Users: 715
    Nodes: 16 (2 / 14)
    Uptime: 27:01:37
    Calls: 12,106
    Calls today: 6
    Files: 15,006
    Messages: 6,518,203

© >>> Magnum BBS <<<, 2026