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
      Tue Sep 15 11:25:46 2026
      from Wales, Uk via Telnet
    • Andrew Andrew
      Tue Sep 15 02:46:28 2026
      from Chicago, Il via Telnet
    • Netmages
      Tue Sep 15 01:13:15 2026
      from Santiago, Chile via SSH
    • Rixter
      Tue Sep 15 00:01:34 2026
      from Madison, Nc via Telnet
    • Rixter
      Mon Sep 14 12:01:34 2026
      from Madison, Nc via Telnet
    • Bob Worm
      Mon Sep 14 08:34:31 2026
      from Wales, Uk via Telnet
    • Retrojimmyx
      Mon Sep 14 00:27:04 2026
      from Derbyshire via Telnet
    • Rixter
      Mon Sep 14 00:01:35 2026
      from Madison, Nc via Telnet
  • System Info

    Sysop: Keyop
    Location: Huddersfield, West Yorkshire, UK
    Users: 765
    Nodes: 16 (1 / 15)
    Uptime: 00:34:27
    Calls: 12,760
    Calls today: 4
    Files: 15,362
    Messages: 6,556,983

© >>> Magnum BBS <<<, 2026